T-SQL cannot do this . You will need some sort of scripting to handle the transfer. You might be able to kick off the transfer with xp_cmdshell, but you are...

A bit late, but be sure you research the issues from SP2, especially with maintenance plans. You might want to prep CU2 or 3 as well.

Got this back from Erland Sommarskog, MVP.

Haven't tested, but this might work for you:

http://www.sommarskog.se/share_data.html#CLR. Also:

--

I've tested this now, and the code is below. Alas, it only works on...

Not sure why you're merge two disparate applications, but running multiple applications off a single database makes perfect sense to me. If the data is related.

I might have an application...

Echo the above statements and good luck!! Also congrats!

Don't worry too much about 2005. Most of the stuff that worked in 2000 still works, so you can keep being successful....

It could also be lots of temp tables being filled.

However you can increase the size of tempdb and it will build this on startup, without affecting model. If you need...

There are reasons to encrypt in the database, protects data in backups, loss of database, etc. However if it's a big deal, the wire should be encrypted as well. There's...

SQL Server may not see a USB DAT drive as a valid location.

In any case, you don't want to backup to tape directly in case there are issues with hardware...

I am guessing that the permissions in the filesystem on F are giving you issues. Be sure that the service account for SQL Server has rights to read and write...

You can search and find these answers, or ask them individually. There is a build list on this site with build numbers. There are scripts for root blockers, and if...

I have seen some blog postings as well from Michael Stonebreaker and while it does seem to make sense, the people posting have a product to sell and that has...

Why does it have to be in master?

You cannot add the user to master without them being a member of public. That's a fundamental construct in SQL Server.

You can have...

I haven't seen that or seen any complaints of it, but I'll ask some people to check.

This upgrade was completed.

Please post in the appropriate forum. This has been moved to the SQL 2000 forum.

As far as your question, that is a sharepoint question. It is the application and would...