network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 2 months |
| seen | May 17 at 21:23 | |
| stats | profile views | 11 |
|
May 17 |
comment |
How do I add a index column to a database with non unique columns What kind of database? |
|
May 3 |
comment |
What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012 CI - Insensitive AS - Accent Sensitive |
|
Apr 4 |
comment |
Role of Database Administrators DBA should be responsible for DDL. You will end up with a mess if you let the developers have that role! |
|
Jan 23 |
comment |
How to delete and create user remotely on SQL Server 2000 More like 150+. We already have 22 converted to 2008R2. The size really won't be much different than our warehouse |
|
Jan 18 |
comment |
Bulk insert into SQL Server from VMWare guest using distributed switch Is VM showing any errors? |
|
Jan 18 |
comment |
How to delete and create user remotely on SQL Server 2000 I posted on FB that maybe I need to consider writing some code in case of zombie attack just to cover all bases! All of this is because someone ran a job during business hours after I told them not to do that and messed up some data. |
|
Jan 17 |
comment |
How to delete and create user remotely on SQL Server 2000 Revoking access deletes the user. Revoking login is only for windows accounts but that did give me another idea - change the users rights |
|
Jan 17 |
comment |
How to delete and create user remotely on SQL Server 2000 Yes, just to ensure that the person at the remote location can't access the database during this process. Not the login but just the user |
|
Jan 17 |
comment |
What is the difference between a “record” and a “row” in SQL Server? I once asked a question in MS forum many years ago in the wee hours of the morning after working on a problem for a long time and accidentally mentioned the word 'record' and yeah, he jumped on me for that one. Now I have a problem with all of the development team calling it record, just to see me wince. |
|
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 |
|
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 ,... |
|
Oct 16 |
comment |
Pull replication stuck on Microsoft SQL Server 2000. What is the safest way to get it running again? Not sure what you mean but 'Stuck'? I have had broken replication that took quite a bit of work to get it fully removed before I could reestablish replication. Using sp_removedbreplication<database name> is one of the steps but have also had to use sp_removesrvreplication on more troublesome cases and on the worst cases, I had to go in and remove all of the replication triggers/views/sprocks |
|
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 |
|
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 23 |
comment |
Some free SQL tools that I use often Think of it as a FAQ - these questions come up often |
