170 reputation
8
bio website
location
age
visits member for 2 years, 4 months
seen 23 mins ago

Dec
10
awarded  Commentator
Dec
10
comment MS DTC errors on SQL Server 2008 R2 but not SQL Server 2000 running on difference instance
Another strange development. I attempted to run subinacl to adjust the permission levels - access denied even running as administrator on the server
Dec
7
comment MS DTC errors on SQL Server 2008 R2 but not SQL Server 2000 running on difference instance
abort request issued to transaction child node or parent node. The actual error message is deep in the MSDTC logs that need to be translated using tracefmt
Dec
6
asked MS DTC errors on SQL Server 2008 R2 but not SQL Server 2000 running on difference instance
Nov
15
comment Is it useful to have the SQL Server instance root directory on a separate drive?
Plus, separating a drive into two or more partitions won't really help disk I/O. But yes, I totally agree with you. It makes things look so much nicer to put the database files in the root of the drive and it makes it easier to spot things. I usually put everything into directories like D:\Data E:\Logs F:\Backup ,...
Nov
2
answered SQL Server 2005 replication for a data warehouse
Oct
16
answered SQL Server Monitoring Tools
Oct
5
awarded  Editor
Oct
5
comment Slow backup and extremely slow restores
I created a linked server and copied the data in. Then I scripted out the indexes in MS-SQL
Oct
5
revised Slow backup and extremely slow restores
added 100 characters in body
Oct
4
asked Slow backup and extremely slow restores
Sep
13
comment Options for keeping two SQL Server Compact databases in sync?
If you have another SQL server, you could use merge replication to synchronize the data using web synchronization. The two compact editions would be the subscriber and the regular SQL server would be the publisher
Aug
24
answered How can place SQL Server online on the internet?
Aug
16
answered Difficulty in moving a SQL Server database
Aug
8
answered SQL Server 2008 R2 Express size
Jul
9
awarded  Student
Jul
9
asked How to remove a database server from Utility Explorer
Jul
9
awarded  Supporter
Jul
9
answered what replication option should I choose?
Apr
26
awarded  Teacher