Viewing 12 posts - 31 through 42 (of 42 total)
Its only a preference within my company. It will be the first column no matter how I do it. Developers have direct access to the development databases and we want...
July 13, 2004 at 1:25 pm
In short, I want to add a new column at the front of every table within the database. There is hundreds of tables and it would take me a very...
July 13, 2004 at 12:35 pm
Another DBA accidentally launched a batch (.bat) file which rebooted the server, which resolved the issue. However, the link was working fine. I stopped and started the DTS services and...
June 2, 2004 at 10:24 am
Thank you to all those that have responded. I am using scripts to capture logins, database users, and database user permissions into flat files. The user database will be backed...
May 13, 2004 at 2:43 pm
THAT'S IT! I used this many moons ago and I could not remember what it was.
Thank you.
March 30, 2004 at 8:04 am
Sqlscan.exe sounds excellent. I will take a look at it. However, I was hoping to finda a command or tool that would locat SQL Server 2000 or 7.0. Actually, it...
March 30, 2004 at 7:41 am
That's ok if the ROWGUID column remains. We will be re-implementing replication upon successful move to the new server.
March 15, 2004 at 5:24 am
Snapshot and Merge (continuous update) Replication.
March 12, 2004 at 5:18 am
I thank both of you. You gave me exactly what I needed.
January 9, 2004 at 7:39 am
Is 1.05TB for SQL Server instance or for a database? A SQL Server 2000 instance can have multiple databases and an NT server can have multiple instances.
January 9, 2004 at 7:03 am
If the application requires individual logins, as apposed to an application login, you could assign each login with only the database role db_datareader and utilize a Database Application Role with...
November 19, 2003 at 5:43 am
I figured it out. If I code BACKUP DISK=pubs\pubs_db_200311111104.bak it will create my backup in C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\pubs\pubs_db_200311111104.bak
November 11, 2003 at 9:09 am
Viewing 12 posts - 31 through 42 (of 42 total)