Viewing 15 posts - 1,201 through 1,215 (of 2,387 total)
Do the objects in second database owned by DBO? I guees they are not.
September 9, 2003 at 7:21 am
quote:
Not sure what you mean in regards to "start SQL Server with -T3608"
To...
September 9, 2003 at 7:16 am
Our UNIX person used PCNetLink to share the directory in UNIX so the directory can be seen by NT/2000 machines. Once it can be accessed from SQL Server, You can...
September 8, 2003 at 7:38 am
First, you need to check SQL Server errorlog to see any error messages indicate why MSDB was suspended.
In order to restore MSDB database, start SQL Server with -T3608, drop the...
September 8, 2003 at 7:29 am
Can they ping to the server? Can you post the exact eror message after connection failure?
September 5, 2003 at 1:21 pm
quote:
Even if you do a check on the server role within T-SQL, a sysadmin role user will return as a serveradmin...
September 5, 2003 at 1:17 pm
That is exactly the question I have. Can't explain.
September 5, 2003 at 12:57 pm
What about to use GETDATE function to get the current date and time and other Date and Time Functions. See BOL for details.
September 5, 2003 at 12:48 pm
quote:
Yes, but it will not return 1 row
It should return only one row.
September 5, 2003 at 12:28 pm
quote:
last week the transaction log file of one of the databases grew from 30G to 60 G
September 5, 2003 at 12:04 pm
I am the lucky one and will go to the PASS. See you there.
September 5, 2003 at 11:58 am
Have you tried same suggestion to column 'entrydate'?
September 5, 2003 at 11:57 am
quote:
Is this has anything to do with MDAC?? The server is using TCP/IP and Name Pipes.
September 5, 2003 at 11:55 am
Try following script to generate drop indexes statements from all user tables.
select 'drop index ' + object_name(ind.id) + '.' + ind.name
from sysindexes ind, sysobjects obj
where ind.id =...
September 5, 2003 at 9:38 am
As Ray suggested, create no-clustered index on that ID column and Check the execution plan to enaure the select uses the index.
September 5, 2003 at 9:23 am
Viewing 15 posts - 1,201 through 1,215 (of 2,387 total)