MyDoggieJessie (8/28/2013)

---

I've created an automated process that logs all the CREATE, DROP, ALTER events from the default trace file into a centrally stored table (basically using a stored-procedure and a...

Try Pivot Query

Hi,

Not tried it by myself but may be useful to you:

sqlcmd <yourscript>

IF ERRORLEVEL 1 goto err_handler

goto done

:err_handler

...

What is your intention by putting BREAK?

Never tried that. But must be feasible through custom code. Please post the solution if you resolve it.

You can use ping [SQL Server Name] to get the ip.

Wish to play daily, but manage 2-3 times a week

Hi AndrewJacksonZA,

Did this work? If you remember 😉

It worked. Thanks for the post.

Have you tried Val?

Storing files on File Server is better option if file size is huge.

Sure! Tha would be a great repository.

Please refer http://www.sqlservercentral.com/Forums/Topic1280879-1550-1.aspx

You can achieve this by using DBCC commands. Please refer post below:

How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005

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

SELECT X.* FROM

(

SELECT

distinct

case when w.leavingdate is null then COALESCE( al.CheckTime, c.[Date]) else null end Date

,case when w.leavingdate is null and al.status='I' then al.eID else '' end eid

,case when...