Viewing 15 posts - 29,356 through 29,370 (of 39,771 total)
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
I think the naming and style are related, but not necessarily the same, especially when looking at tools. Naming should be standardized within your organization so code can be easily...
March 2, 2008 at 10:00 am
The server should always respond to both the windows server name and (local). You don't remove or rename a default instance.
If you are talking about the client tools, follow Tommy's...
February 29, 2008 at 12:43 pm
Viewing 15 posts - 29,356 through 29,370 (of 39,771 total)