Specify that the database be maintained in STANDBY mode rather than NORECOVERY.

Be careful with read-only connections to the standby database though. Sysadmin logins will block log-shipping (ie. application of...

Brian,

In my experience ListAvailableSQLServers has only returned listening servers and those servers explicitly defined in Client Network Utility.

To list enumerate all my EM registered groups, subgroups and servers I use...

Not a pretty solution, but I have seen SPs and Applications that pass information to triggers through CONTEXT_INFO (See "Session Context Information" in BOL)

Cheers,

- Mark

Rather than estimating, I would do it by taking regular transaction log backups whilst applying the transactions in test mode. Look at the size of the tlog backups (or...

Barbara,

This is going to sound stupid but...

despite having an index on a table, SQL does not guarantee to return rows in any particular order unless you explicitly say "ORDER BY...

Possibly implicit transactions are set on under QA but your VBA app needs either a BEGIN TRAN... COMMIT, or implicit transactions set on.

The fact that you get no T-SQL errors...

If in a production database and the users are complaining about a trigger problem which I can't replicate, I sometimes temporarily insert statements to the effect of:

RAISERROR('blah blah...', 0, 1)...

'fraid not.

Cheers,

- Mark

Anything interesting in the SQL Errorlog?

Anything in your SQL Agent Error Log? (right-click SQL Server Agent and select "Display Error Log...").

Is your maintenance plan configured to write a report...

Sachin,

Hardly anywhere I'm afraid.

Just a search of newsgroups to find out how to call it. I don't even know what can be substituted for the...

I think lumigent know how many competitors they've got... hence the insane price.

You may be able to get something useful out of fn_dblog. For starters try: