I'd suggest to get rid of the "dynamic" stuff.

( All time ref: http://www.sommarskog.se/dynamic_sql.html )

If you need the same proc in # databases, create it in each database !

( Unless it...

Indeed I posted the "old" script (grabbed it from the sql2k lib) :blush:

Using...

You will have to execute the script with a connection to the dodgy database !

If that user was the actual database owner (<> member of db_owner group), it will not...

This material seems quit interesting ...

- http://www.sql-server-performance.com/articles/per/2000io_config_sannas_p1.aspx

- http://sqlserver-qa.net/blogs/perftune/archive/2008/01/28/3300.aspx

- http://blogs.msdn.com/benjones/archive/2005/09/12/463964.aspx

- http://search.techrepublic.com.com/search/best+practice+and+hp+storageworks+and+microsoft+sql+server.html

- http://www.dell.com/content/topics/global.aspx/power/en/ps3q01_muirhead?c=us&cs=555&l=en&s=biz

- http://h71028.www7.hp.com/ERC/downloads/4AA0-2948ENW.pdf

(started at http://whitepapers.zdnet.com/abstract.aspx?docid=166254 )

Some of them are based on SQL2000, but I think the top basic rules are...

keep in mind in this context "temp table" is an #-named table.

Don't create normal tables in tempdb ! You'll loose them at sqlserver restart time!

Create table #tmp (A int not...

this script generates "user synchronisation" statements.

Maybe this will help out:

print 'print @@servername + '' / '' + db_name()'

print 'go'

go

declare @username varchar(128)

declare @Musername varchar(128)

declare @UserType Char(1)

declare @sql_stmt varchar(500)

declare @ExcludeWindowsAccounts Char(1)

set @ExcludeWindowsAccounts...

- can you provide DDL for the objects (including indexes) ?

- many or-s, many functions for filtering (leftx,3) in (...)

may discourage index usage !

Post the execution plan...

to see if you have IO problems regarding the tempdb you can offcourse always use:

/* track sqlserver IOstall time*/

set nocount on

SELECT ' use ['+ name +']

go'

+ case dbid when 1...

-We record this at the sqlinstance itself and only grant insert access to that particular table of our "admin" db.

- This just to avoid having issues if your central audit...

:humble:

I'm not worthy to even read this article, but I've been a bad boy and did just that. 😀 Mea culpa.

Clear, to the point, no rocket science involved, practical, very...

Maybe this can help out:

- Beware this uses xp_cmdshell (should only be used by sysadmins)

- yep it uses a cursor, but in this case that's perfect.

- TEST IT - TEST...

Indeed, you can use UNC, as long as your service account/proxie account of your backup job has the rights to read/write at that location.

This also works on sql2000. (been using...

IMO this union-part is far better readable/interpretable and less fault sensitive than the total of union parts provided in your script.

What you need to figure out is if the...

Setting a primary key by itself, is a conceptual issue.

A...

If this is a "single user" database, you can also use the db option "auto close". This way you will free up system resources, the db is still available and...