Viewing 15 posts - 31 through 45 (of 517 total)
jessyb (9/27/2011)
September 27, 2011 at 10:49 am
Did you try setting that user's default database to Master and specifying the db name in the connection string? Chances are it's already in the string, so having it was...
September 27, 2011 at 10:43 am
Instead of uninstalling the instance, you could use the failover cluster configuration manager and set each instance to only use specific nodes. This would give you flexibility in the future...
September 27, 2011 at 10:39 am
Yes, and you should be backing up the logs regardless of whether or not it's mirrored.
Unless I'm misunderstanding your question..
September 27, 2011 at 10:33 am
ckingtaylor (6/15/2011)
June 15, 2011 at 8:35 am
Are you upgrading versions by any chance?
Try running the restore from t-sql and check the messages tab to see what it's doing. Most of the time the hanging after 100%...
March 11, 2011 at 4:13 pm
Read uncommitted is the same as setting nolock for all queries in the proc, yes. You do not need to specify it again.
March 9, 2011 at 9:54 am
Text = varchar
Ntext = Nvarchar
Try casting to nvarchar(4000).
edit: Or if you're doing the conversion in SSIS, make sure you're converting to double-byte chars and not single-byte.
March 2, 2011 at 3:42 pm
The easiest way I could see doing this would be to return all columns regardless of what the user selected (having them in the table at least..not necessarily populated, which...
March 2, 2011 at 3:39 pm
When you run a query like that, what happens is SQL will pull the entire table back over the link and then run it locally (possibly twice in this case)....
March 2, 2011 at 3:33 pm
frfernan (2/22/2011)
I will explain a case when I coded a cursor as a good solution to a problem.
Some months ago I coded a Stored Procedure to purge a table...
February 22, 2011 at 11:21 am
GilaMonster (2/17/2011)
Derrick Smith (2/17/2011)
Now the real problem with SSMS Intellisense:How do you stop it from auto-completing when you press period or space?
Turn it off and get a replacement that...
February 17, 2011 at 5:54 pm
I don't think there are any non-ssc ads on askssc (or redgate, who owns the site), but I could be wrong.
February 17, 2011 at 3:45 pm
In all honesty, it's probably to generate more page views to the site to generate more ad revenue.
SSC doesn't make any money if you just read the reply in your...
February 17, 2011 at 3:39 pm
Now the real problem with SSMS Intellisense:
How do you stop it from auto-completing when you press period or space? This has been the single most frustrating aspect of SSMS for...
February 17, 2011 at 3:37 pm
Viewing 15 posts - 31 through 45 (of 517 total)