It will work for SQL 2005 as well if we change

Select db_name()

,object_name(s.object_id) As ObjectName

--,object_schema_name(s.object_id) As SchemaName--...

Not for a long time I hope, GETDATE() and GETUTCDATE() are too widely used

I rarely use...

To me

Log Shipping = Trans Log backup + Scheduled restore

so if you want High Availability or warm standby, use Log Shipping (which also gives you log backup at the same...

I would think so, default instance is really another named instance called MSSQLSERVER

I have uninstalled 1 of...

The typical batch issue

.bat

VBScript

PowerShell

Perl

3rd party - RedGate Multi Script, xSQL Script Executor (free), etc..

see this post from last week

http://sqlblog.com/blogs/linchi_shea/archive/2008/12/04/executing-a-large-number-of-sql-scripts.aspx

As far as I know, you need to customize it to...

+1 to above

USE msdb

SELECT TOP 100 *

FROM RESTOREHISTORY WITH (NOLOCK)

--WHERE destination_database_name IN ('XXX')

ORDER BY restore_date DESC

e.g: C: Partition = 50 GB installed O/S and SQL Server 2008

D: Partition (SQL Data)

...

you should just run the CTE/Derived table section to confirm RowNumber returns the correct #

I think that this part won't work, as it does NOT sort by the [VOODCD] column...

How much disk space is there for the log drive?

Also, does the log have restricted max size?

Any other maint. tasks like reindexing etc? that would cause the log to grow

In SQL Server 2005, the SQL Server Profiler graphical user interface displays the Duration column in milliseconds by default, but when a trace is saved to either a file or...

Make sure you won't lock yourself out (i.e. create your account/domain account in SQL with sysadmin, or know the sa account)

By default, I believe SQL 2008 doesn't include BUILTIN\Administrators as...

dva2007 (12/8/2008)

---

If you are not using data driven subscription then it would be bit difficult to handle. U need to use data driven subscription which u can set up so...

Good to hear

I have had...

Google seemed to think so, I would think so too

I'd suggest try it first (make sure you setup the credentials/logins correctly), there is no harm

We have linked server in SQL...

Above is a duplicate post

resolved in this post

http://www.sqlservercentral.com/Forums/FindPost614656.aspx