Viewing 15 posts - 211 through 225 (of 2,387 total)
Can you post the result back of "dbcc sqlperf (logspace)" and indicate which log file is for that database? Did you perform full or differentail backup when you received the...
November 17, 2004 at 11:44 am
I suspect this database is inaccessable, Can you confirm that?
November 17, 2004 at 11:27 am
Make sure the drive which hosts your database log files is accessable.
Post your SQL Server errorlog here too.
November 17, 2004 at 10:17 am
November 17, 2004 at 10:13 am
You got access violation, In order to find out what are the causes, you have to send the dump files which reside in \MSSQL\LOG folder to Microsoft.
Is there any reasons...
November 17, 2004 at 10:05 am
You are right. If it is not primary key or unique key, You can simple drop it with "drop index" command.
September 17, 2004 at 9:49 am
Clustered index is a constraint and you have to use "alter table drop constraint" command to drop it. See command sample and details from BOL.
For index creation, check "create index"...
September 17, 2004 at 9:04 am
September 17, 2004 at 8:58 am
You also have to configure SQL Server resource to depend on this new disk resource.
September 16, 2004 at 9:45 am
That is because you have linked server setup and use 'sa' as remote login.
September 16, 2004 at 8:38 am
Clustered Index Scan means table scan. You need turn the indexes in this lookup table.
September 16, 2004 at 8:31 am
Make sure the new disk resource is in SQL Server group.
September 16, 2004 at 8:23 am
How do you create the documents? Your application may set timr in different zone than your server setting.
August 31, 2004 at 8:43 am
Your database may corrupted prior you run the query. Restored the database backup to anotehr server or new database and run DBCC CHECKDB.
August 27, 2004 at 11:24 am
Viewing 15 posts - 211 through 225 (of 2,387 total)