checkpoint is a general command so master is good. dump can be applied inside or outside of the target database. It's just my habit to run maintenance commands on master...

Hi Tom,

for the last shot since your msdb is the problem database we can shrink it to get rid of the unused (or...

You can use Visual Studio 2003/2005 to connect to your database.

And it's strange that you cannot find another computer that has undamaged SQLMS to connect your DBs. Did I...

http://search.microsoft.com/results.aspx?mkt=en-US&setlang=en-US&q=%5bMicrosoft%5d%5bODBC+SQL+Server+Driver%5dCommunication+link+failure

There are a lot causes about the communication error you get. If you can solve it the second one will go away I think.

Hope that helps

It's a big piece of code, glad that I'm not responsible for it

If I was the one who faced this query I would...

I know it'll be difficult but if this is going to run a lot on your system you should:

• avoid using functions on the joins and where clauses (rtrim like functions)
• use...

Glad it worked

Hi Tom,

Sorry for the broken script. I didn't replace "alter" with "create". Anyway, you have the statistics.

I think that (and also what I've found via net) your DTS packages caused...

I can

If you installed a brand new SQLEXPRESS instance, remote connections come default off. You can use "Surface Area Configuration" to turn it off. (Under database engine > Remote Connections)

Cheers,

Zubeyir

Can you explain what do you mean by "updates should be done in the order of most recent records first, then working backward"? Do you mean order of columns that...

I think it's something like that

UPDATE C
SET C.Name = 'Blah'
FROM Customers AS C
WHERE C.Name IS NULL

If I'm wrong please correct me.

By saying "renaming the database" what do you mean? Did you only change the name of the files or you changed the name of the database while you're attaching it.

If you need to do it for just one time you can tell the query analyser to put the results to a file instead of showing them up. (CTRL+SHIFT+F)

Cheers,

Zubeyir

From BOL (mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\adminsql.chm::/ad_impt_bcp_9esz.htm)

When using the full recovery model, all row-insert operations performed by bcp are logged in the transaction log. For large data loads, this can cause the...