Viewing 15 posts - 2,191 through 2,205 (of 2,387 total)
Try sp_fkeys.
Check http://www.sqlservercentral.com/scripts/contributions/246.asp contributed by cneuhold
Edited by - Allen_Cui on 02/25/2003 07:51:18 AM
Edited by - Allen_Cui on 02/25/2003 07:52:31 AM
February 25, 2003 at 7:37 am
1. Create SQL Script to backup the database
2. Create a batch program to call OSQL.exe that will run the script created on step1.
3. Schedule the batch program in system with...
February 24, 2003 at 2:26 pm
Can you login from her machine with your NT login?
What type of user she is? NT Admin or just normal user?
February 24, 2003 at 2:22 pm
What is the fill factor setting for this table? DBCC DBREINDEX will reorganize the table according to the fill factor and that could be the reason.
February 20, 2003 at 12:00 pm
I don't agree with the BOL. As long as you add the cluster service account into SQL Server login with 'sa' right, your cluster server will work fine.
I don't think...
February 20, 2003 at 7:49 am
From BOL.
"Using AWE Memory on Windows 2000
Microsoft® SQL Server™ 2000 Enterprise Edition uses the Microsoft Windows® 2000 Address Windowing Extensions (AWE) API to support very large amounts of physical memory....
February 19, 2003 at 2:42 pm
Are you sure you don't have AWE enabled in SQL Server?
Why you don't have /3gb enabled?
February 19, 2003 at 2:25 pm
I assumed /3GB and AWE are enabled in your server and SQL Server configuration. Can you confirm it?
February 19, 2003 at 2:00 pm
What is the number of 'Avg. Disk Queue Length' when you saw high number in 'Avg. Disk Write Queue Length'?
How much memory your server has and how much for SQL...
February 19, 2003 at 12:52 pm
If you have to run Full Text search service, you have to add 'NT Authority\System' to your SQL Server logins with 'sa' right. You also need add your own NT...
February 19, 2003 at 12:36 pm
Assuming you are talking performance counter 'Avg. Disk Write Queue Length' under physicalDisk object. According to the definition of this counter -- "Avg. Disk Write Queue Length is the average...
February 19, 2003 at 10:14 am
Because you have already denied the access for BUILTIN\Administrators, so any local admin accounts will be denied too.
Remove BUILTIN\Administrators from your SQL Server logins and grant the local admin account...
February 19, 2003 at 9:46 am
How large your transaction log is originaly set? Simply set database to single mode isn't good solution. You sould try to find out any transaction/activities/maintenance's jobs that cause the transaction...
February 19, 2003 at 8:57 am
That command is not used to set the variable. It retrieves the NT variables to a temp table so you can select the variables from it as you want.
February 14, 2003 at 10:05 am
Download MDAC component checker from http://www.microsoft.com/data
February 14, 2003 at 9:25 am
Viewing 15 posts - 2,191 through 2,205 (of 2,387 total)