for 2005 it is;

Click on TOOLS --> OPTIONS --> SCRIPTING

and set Script USE <database > to FALSE

I can imagine that it is the same for...

using a cursor to do this will be very slow, the better way seems to be to use a tally table and split the data up with this;

check out...

The SQL 2005 bible is one the best books out there in my opinion.

http://www.amazon.com/Server-2005-Bible-Paul-Nielsen/dp/0764542567/ref=pd_bbs_sr_3?ie=UTF8&s=books&qid=1226923680&sr=8-3

Change the password, if anyone is using it (they shouldn't be) then I am sure they will make themselves known fairly quickly

Loner (11/13/2008)

---

That guy's title is Senior DBA/developer. Obviously he does not know anything about SQL Server administration and I am very much doubted he is a good SQL developer....

It's an undocumented stored procedure and does not appear in books on-line, am not sure why as i find it useful.

try this link for help

http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

try this code to get the file paths for each db on a server.

DROP TABLE #DBFiles

CREATE TABLE #DBFiles

(

[DBName] [nvarchar](100),

...

For books the best one i have used is

SQL server 2005 Integration Services from Wrox

http://www.amazon.co.uk/Professional-Server-2005-Integration-Services/dp/0764584359/ref=pd_bxgy_b_img_b

and I find this website very useful http://www.sqlis.com/

try this code out

DECLARE @name VARCHAR(100)

SET @name = 'firstname'

SELECT upper(LEFT(@name,1)) + lower(RIGHT(@name,LEN(@name) -1))

Though you have to be really careful with automaticaly just upper casing the first character of names, ...

That is for one...

To restore a differential backup, you first need to restore the full back up with the NO RECOVERY option.

It may be possible to do this without a cursor,

If you post your code , table structres and sample data then I am sure you will get a...

Restarting the server weekly sounds lilke a case of really bad code.

Is there one procedure that is causing the issue?

Post this is the 2K forum.

with SQL 2005 you can use TRY CATCH blocks for error handling, put the code for rolling back your changes in the CATCH block

http://msdn.microsoft.com/en-us/library/ms175976.aspx