Did you try something like below?

EXEC master..sp_helptext sprocName

Does your script overwrite existing file?

You may use the SQL Server Profiler, or check the EventViewer or other tools to trace.

Here is a link. Maybe you know it already. My understanding is the backup on native mode is for Windows 2K or above.

http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=7156

Look at the three tables in the msdb, sysjobs, sysdbmaintplan_jobs, and sysdbmaintplans. We can join these tables with necessary criteria and export to our...

I think that you can. Look at the three tables in the msdb.

sysjobs, sysdbmaintplan_jobs, and sysdbmaintplans.

Join these tables with necessary criteria and export to your target server.

An example of...

I had this kind of experience. I had to restart the SQLAgent.

Expand replication folder;

Expand publications folder;

Delete all items under it.

Then, run Disabling replication ...

Hopefully, it will work.

Could you use Transfer Jobs Task in the DTS Package?

Normally, a compressed backup takes less time than a regular backup if we rule out difference in backup devices. It is always true in my experience (I cannot say there...

Normally, the sizes of log files do not affect stopping SQL services. But if there are some other jobs running against the server, the jobs may need to rollback. Rolling...

How about this one?

http://www.motobit.com/tips/detpg_read-write-sql-image-file/

Try the SQL Profiler.

You need to drop subscribers before cleaning up the publishser and distributor.

It may be a connection issue. When threads exceed its maximum setting (or capability), you may have this error. Here is a link. Hopefully, it is useful.

http://knowledgebase.datadirect.com/kbase.nsf/SupportLink+Online/2475396BD?OpenDocument