Viewing 15 posts - 29,401 through 29,415 (of 39,818 total)
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...
March 2, 2008 at 7:51 pm
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.
March 2, 2008 at 5:29 pm
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...
March 2, 2008 at 5:28 pm
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...
March 2, 2008 at 11:22 am
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....
March 2, 2008 at 11:19 am
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...
March 2, 2008 at 10:42 am
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...
March 2, 2008 at 10:41 am
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...
March 2, 2008 at 10:37 am
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...
March 2, 2008 at 10:34 am
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...
March 2, 2008 at 10:30 am
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...
March 2, 2008 at 10:24 am
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...
March 2, 2008 at 10:12 am
I haven't seen that or seen any complaints of it, but I'll ask some people to check.
March 2, 2008 at 10:09 am
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...
March 2, 2008 at 10:07 am
Viewing 15 posts - 29,401 through 29,415 (of 39,818 total)