I have a VBScript (uses DMO) that will script out a 2000 server and I believe has what you need. In essence, it creates a script that will build an...

A "tail log backup" refers to this situation:

The database has a failure and isn't usuable. You would like to be able to restore to the point in time just before the...

I created a few stored procedures for Maintenance on SQL Express and execute them via the Windows Task Scheduler and an OSQL command in a batch (command) file. Works fine....

GilaMonster, thank you for the explanation. I would like to read the article on the technical details. 

have you been here:

http://msdn2.microsoft.com/en-us/library/ms143706.aspx#runtime_installing

There is, or was, (I think it's part of SP1 now) a backward compatibility kit that will allow you to view and run DTS packages. It also has an upgrade...

The only way I know of is to stop and start the SQL Server service.

CBaptiste - thanks for your reply - I have most of it done in VB.Net already.

Our developers use a variety of tools. Fortunately, the syntax for creating database objects hasn't...

Thanks for example. I am in no way a VB coder let alone a VB.Net coder. I was hoping to not need to read the disk file into a command,...

Our development teams use Source Safe for code control. When a stored procedure(s) is ready for release, they will send us (DBAs) a list of the procedures that are to...

For SQL 2000 it is SA unfortunately. SQL 2K5 doesn't require SA.

Just a PS to this item:

The Backward Compatibility feature lets me capture all the things I need. using VBScript and SQL DMO. I would imagine that this feature won't go away...

As I said, I inherited the script and I don't know much at all about scripting. This is what I get:

Set svr = CreateObject("Microsoft.SQLServer.Management.SMO.Server")

'Server svr = new Server(); this...

Thanks Brian, I appreciate it. I already have a VBScript that uses SQL DMO to script out all the objects. I need to convert that to SQL SMO and the...