Viewing 15 posts - 1,306 through 1,320 (of 2,496 total)
The account running SQL Server needs to have the 'Read Write' privilege on the MSDTC service.
The Windows default is that Everyone has this privilege, but some places tie down this...
June 8, 2009 at 4:13 am
I agree with most of what George says, but prefer to treat msdb as a user database and move it, but this is just personal preference.
I like to...
June 8, 2009 at 3:23 am
Steve is right. There is nothing in the products that will prevent this from working but you do need to test.
The most likely problems will be in your application,...
June 8, 2009 at 3:13 am
If you are asked 'Is anyone in the office wearing a red shirt' what do you do?
a) Go round the entire office counting the number of people and making a...
June 8, 2009 at 3:02 am
See my answer at http://www.sqlservercentral.com/Forums/Topic728579-146-1.aspx? for a script that will do this for you.
June 8, 2009 at 2:52 am
There are scripts in FineBuild that can migrate SQL logins complete with their original passwords. You can get FineBuild from the link below or direct from CodePlex. Look...
June 8, 2009 at 2:49 am
If you have any Windows support people at your site, talk to them before you change the Hosts file. There are various options that can be used to make...
June 8, 2009 at 2:46 am
Sometimes you see announcements on April 1 that SQL Server can run on Linux.
Some people believe them, but so far nobody has got SQL Server working on Linux, but that...
June 4, 2009 at 7:13 am
You have to be careful when using @@ROWCOUNT. Your example should work as you expect, but the example below will not...
UPDATE .....
SELECT @MyErr = @@ERROR
IF @@ROWCOUNT > 1 ...
In...
June 4, 2009 at 7:09 am
SQL Server is a relational database. You can store objects in SQL Server, but it does not provide any native support for object inheritence.
If you need this suppoprt, then...
June 4, 2009 at 7:01 am
The standard way to deal with this is to create a table holding currency codes, the currency symbol, number of decimal places, etc. There is an ISO standard that...
June 4, 2009 at 6:54 am
You can use SQL Mail in both SQL 2005 and SQL 2008. It is deprecated and may not exist in the next SQL version but is still supported...
June 4, 2009 at 6:48 am
I saw something in the SQL 2008 SP1 fix list that implied you could now move the Resource database, but I have not followed this up yet. IMHO there...
June 4, 2009 at 6:42 am
If you want to have a playground environment, then subscribing to TechNet or MSDN is a good idea.
I have subscribed to TechNet for maybe 4 years, and it give me...
June 4, 2009 at 6:40 am
BOL is Books Online.
GSquared has a good idea about spiltting your RAID group.
June 4, 2009 at 5:46 am
Viewing 15 posts - 1,306 through 1,320 (of 2,496 total)