Viewing 15 posts - 6,571 through 6,585 (of 9,707 total)
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
Lowell, that's brilliant code. Even though this wasn't my question, I may have to keep your solution in my SQL files for future reference. @=)
February 7, 2011 at 7:12 am
I am curious, though. Why would anyone burn data files on DVD? There are more reliable and much better storage options available that allow for bigger files. These options will...
February 7, 2011 at 7:10 am
1) Only pull the columns and rows you need from the source (instead of everything). -- In other words, Filter, Filter, Filter.
2) Run the package when little-to-no other traffic or...
February 7, 2011 at 7:06 am
FYI: Port 1434 is the default UDP port.
On my local box, I have two Dev servers installed (2k5 & 2k8). Looking at my SQL Server Configuration Manager, both servers have...
February 7, 2011 at 7:01 am
karthikeyan-444867 (2/6/2011)
I have installed sql server 2005 in my home machine. when i open management studio, it is prompting to choose the server name (By default nature). I didn't create...
February 7, 2011 at 6:48 am
anilkullam, as this is an old thread, you are more likely to get assistance if you start your own new thread and use english to ask the question instead of...
February 7, 2011 at 6:45 am
Viewing 15 posts - 6,571 through 6,585 (of 9,707 total)