Also a nice tool for this can be SQLCMD

If you have an inventory table containing all your sqlserver instance names, you can run a script and save all results,....

Create a...

barb.wendling (9/10/2008)

---

I did the same thing, edited the single line to two lines and it worked in QA. I was wondering if anyone had ideas on how this feature (GO...

Most of my jobs only have step with "Fail job if step fails", so I've only checked for the failed steps.

This version only reports if the actual job failed...

You need to use SSMS (SQL 2005) to get the result aimed for with the question.

Apparently it's SSMS that puls this trick !

Indeed With Query Analyser, you'll get the syntax...

Keep in mind SSMS has some issues with e.g. char(13) resulting in a "syntax error near ...."

And off course you'll need to have the default 'go' for batch separator...

sqlserver timestamp is "for internal use only" !!

This kind of columns will be updated by sqlserver itself with every modification to the row !!

This is not a datetime column !!!

We...

Considerations for the "autogrow" and "autoshrink" settings in SQL Server

http://support.microsoft.com/kb/315512

Oh yes, SCADA stuff, not that much sqlserver performance...

just curious: Do you have "auto shrink" enabled for this database ?

(Bad practise ! If you actually need a shrink operation, you'd be better off doing it in a planned...

stop / start the instance and it will re-allocate tempdb with its prior space numbers.

(because it has to clear its work space file)

You need to fill the t-log so it rolls over to the beginning of the file,

so you may have to perform the shrink a couple of times.

Thats why this...

To make it easier for yourself use object aliasses in your queries and the JOIN syntax.

It differentiates join and where clause.

[Code]

Select e.name,

S.name,

C.name

from Employee E

inner join State S

on S.Id...

Thank you for pointing to that Wilfred.

The data is in a consistend state at the standby database, so data is available.

I've tested a snapshot scenario, and it got me totaly...

e.g.

List Installed Software

http://www.microsoft.com/technet/scriptcenter/scripts/apps/user/usapvb06.mspx

There is no move of the datafiles at alter database time !

With Tempdb, your need the alter database to update the catalog

and you'll need the stop/start to create the...