Viewing 15 posts - 1,186 through 1,200 (of 2,387 total)
See http://support.microsoft.com/default.aspx?scid=kb;en-us;246775 even though it is for SQL Server 7.0.
September 9, 2003 at 11:48 am
Depending on the database size, you may not see the different by placing mdf and ldf in same RAID set if the database is small. But it is alway be...
September 9, 2003 at 11:45 am
Unless you have been run Profiler, otherwise, you would not be able to see who did.
You could download free tools from http://www.lumigent.com/downloads/schemaalert/ for future alert.
September 9, 2003 at 11:42 am
Run scm.exe ? to see the complete syntax.
http://support.microsoft.com/default.aspx?scid=kb;en-us;230236
sc.exe is from NT/2000 resource kit. I like it better than scm.exe.
September 9, 2003 at 11:32 am
sc.exe but scm.exe can also give similar information.
September 9, 2003 at 10:00 am
Could something changed by the script? Can you post it?
September 9, 2003 at 9:35 am
quote:
Now i can't use the test-db because there is a problem whith the db-property!!
September 9, 2003 at 9:31 am
RESTORE DATABASE AugTrack WITH RECOVERY
September 9, 2003 at 9:27 am
xp_cmdshell 'sc.exe \\yourservername query MSDTC'
xp_cmdshell 'sc.exe \\yourservername query SQLSERVERAGENT'
September 9, 2003 at 9:24 am
Unless you recreate it, You wouldn't be able to see it.
September 9, 2003 at 9:20 am
Create your own database role, grant execution permission on sps to this role and add your user to the role.
September 9, 2003 at 9:14 am
How do you insert/delete/update data from VB programs, via stored procedures or hardcode insert/delete/update statements?
If you use sps, the login doesn't have to have insert/delete/update to the tables, you only...
September 9, 2003 at 8:14 am
There are some articles talking about this in http://www.sqldts.com.
September 9, 2003 at 7:44 am
Contro panel --> SQL Server 2000 license.
Edited by - allen_cui on 09/09/2003 07:42:43 AM
September 9, 2003 at 7:42 am
quote:
We have a 90 GB database that is set to autogrow by 10%. We noticed it grew last friday.1) How...
September 9, 2003 at 7:28 am
Viewing 15 posts - 1,186 through 1,200 (of 2,387 total)