Hi Girish,

Checking the MSDB is okay if the target database is also on the same server as the source. If the target DB is on a remote server it may...

Hi Chris,

The solution is supposed to apply the logs in NO RECOVERY mode so that more logs can be continuously applied automatically. The last step of actually bringing the database...

Is it an OS copy or an FTP copy? For OS copy - copying from one server to another you can use an Execute Process Task and put the operating...

Microsoft has provided Express editions for all Visual Studio tools. So if you want a browser based solution, you can use Visual Web Developer. If you want a desktop based...

You can do this using an SSIS package. Have you tried it and are you facing any problems with it?

Doesnt seem to be a problem with Log Shipping itself. This seems to be a problem with the SQL Server Agent job trying to open the file to log its...

Vinu - one way to do this (not using stored procs) is by using the Windows Performance Monitor. In perfmon, you can configure an Alert for object Processor - "%Processor...

There are two other ways you can explore:

1. Create a linked server to the text file and then you can use INSERT queries like you do inserts into a normal...

From within a stored procedure you can use the extended stored procedure master..xp_cmdshell. So if you want to write to a text file you can use something like:

exec master..xp_cmdshell 'echo...

Matt - Depending on the situation it may not be necessary to go through 10 months of log. Example: If it is a table in which data is only being...

One way to do this could be - assuming you have the transaction logs (or can recall the tapes/files), you might use a tool like Lumigent Log Explorer or Redgate's...

Yes, SQL Server Agent is not included in SQL Server 2005 Express. To run stored procedures regularly you can use Windows Task Scheduler to invoke the sqlcmd command line utility....

Check this link. You may get some pointers from there:

http://www.sqlis.com/55.aspx

There is no way in SQL Server 2000 exactly like Oracle's integration with Java. Starting with SQL Server 2005 you have CLR integration where you can run stored procedures or...

What exactly do you mean by "handle". If you want to prevent queries which are expected to run for longer than certain number of seconds, you can use the Query...