Try

SET SHOWPLAN_ALL ON

GO

YOURQUERYHERE

GO

SET SHOWPLAN_ALL OFF

GO

see if you get the query plan information. Try using sp_updatestats to make sure statistics are inline, then DBCC UPDATEUSAGE to make sure no inaccuracies...

This sounds like file permissions preventing access to the file or the path to the file is invalid. What are you submitting in the @FileName value? It looks like you...

Ok I am confused. You say you are trying to add a custom error message to two different servers by adding to the first then copying to the secound. However...

if exists (select *

from tempdb.dbo.sysobjects

where id = object_id(N'tempdb..#temptbl'))

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Edited by - antares686 on 06/18/2002 ...

Depending on the Version of SQL tyours is from you can save to file or table when you set the trace up. These options are on the first page of...

Actually no, you can use Profiler to catch the query being sent from the client, this will give you the exact SQL query statement. Then take this and paste into...

The only item that has existed is sp_denylogin to lock nt accoutns from the server but there is nothing to do so for SQL logins, either they do or don't...

Also depends on how often you backup your server in regards to intial size. If the full backups are down weekly you should backup and empty the Transaction Log right...

Actually the same thing was available in SQL 7 and NT but the name was different of "Extended Memory". See "extended memory size Option" in SQL 7 BOL. For 2000...

I feel the last statement was always true as you can create dynamic queries in procedures liek so

EXEC('SELECT * FROM tblX')

and the dependecy will never be marked. There have been...

It is an application from the client install option of SQL. Like EM you just execute it, should be in the MS SQL Tools program folder. If not but you...

Either run a trace, use Queyr Analyzer to see the execution plan, or run PerfMon for cache hits and see if this query is constantly having to hit the actual...

Make sure the account SQL AGent is running under has the proper permissions and exists on the Win2000 server. Looks like it is failing the login. Have you tried any...

I would do a Transaction log or a full to file backup then run the script then the full backup.

"Don't roll your eyes at me. I will tape them in...

It is referring to Line 13 of some piece of code. Which traces did you turn on? Personally I would use DBCC TRACEON (-1,1204,1205,3605) to get a better output with...