Viewing 15 posts - 6,586 through 6,600 (of 9,725 total)
vk24/7 (2/7/2011)
i hope you missed that screen. one cannot install sql server without a default server when installing database engine.
Minor quibble. You need to remove the word "default" from that...
February 7, 2011 at 10:16 am
Sorry, Dude. The movies work that way because the books work that way. The books are considered a trilogy, and the movies were made as a trilogy. 3 separate works,...
February 7, 2011 at 10:12 am
Picture does not appear to have posted, Steve.
February 7, 2011 at 10:07 am
Steve Jones - SSC Editor (2/7/2011)
Not sure why Jeff or Ron weren't at the Sunday morning run, but I'm sure they'll be at the next one :-P:hehe:
Oh, I have to...
February 7, 2011 at 8:48 am
I have to agree. I like being able to cursor through the proc, having all the orphaned users fixed automatically without any typing. I just open up my saved cursor,...
February 7, 2011 at 8:47 am
smac (2/7/2011)
displayed and where the fields come from.
Also the screen display will be refreshed...
February 7, 2011 at 8:41 am
jeff.mason (2/7/2011)
ALZDBA (2/7/2011)
jeff.mason (2/7/2011)
...
As for karaoke -- the less said the better. 15 DBAs doing Bohemian Rhapsody was too much.
Your Youtube ref is missing :w00t::hehe::-D
Dear Lord, I HOPE...
February 7, 2011 at 8:34 am
This may have nothing to do with the issue, but I advise you to do it anyway, just to make sure it isn't the problem.
Go through User 2's SQL Authentication...
February 7, 2011 at 8:29 am
Lookup Convert() in Books Online. Using the format codes will assist you greatly.
February 7, 2011 at 7:34 am
BCP if you're only doing it once. SSIS (like Craig suggested) if it's going to be repeated more than 2 times.
Don't be scared by SSIS. It's rather simple to...
February 7, 2011 at 7:32 am
Craig Farrell (1/31/2011)
In T-SQL, you'll build a staging table that holds all of the columns/rows.
This can be done in SSIS as well, and might be easier than the SSIS...
February 7, 2011 at 7:30 am
No. You need to look into error checking and rollbacks. Without that, your transaction code is incomplete.
Technically speaking (ACID test talk), if the statements fail due to syntax or server...
February 7, 2011 at 7:28 am
What types of login are the users using? SQL Server or Windows Auth?
If Windows, is user 1 actually logging out of the system when user 2 tries? Or are...
February 7, 2011 at 7:24 am
I would use the dreaded Dynamic SQL to build your email. Embed the whole proc and arguments into the dynamic sql, adding in the proper name, then execute it.
Depending on...
February 7, 2011 at 7:19 am
There are multiple types of snapshots in SQL Server. Please clarify which type you're referring to.
February 7, 2011 at 7:16 am
Viewing 15 posts - 6,586 through 6,600 (of 9,725 total)