Viewing 15 posts - 5,356 through 5,370 (of 9,712 total)
I schedule my jobs to print to an error log for each step and check Include Step Output. For SSIS packages, I use the Operating System job step format (instead...
August 12, 2011 at 6:15 am
The Dixie Flatline (8/12/2011)
Congratulations and good luck, Lynn.
Ditto.
August 12, 2011 at 6:10 am
Roy Ernest (8/11/2011)
Wonderful. Congratulations.
Thanks. @=) And thanks to everyone else, too.
Roy Ernest (8/11/2011)
August 12, 2011 at 5:50 am
sqlmaverick (8/11/2011)
I don't know how to attach the code separately.
Putting the code in a code block is relatively easy. When you post, look to the left of the text box...
August 12, 2011 at 5:43 am
SanDroid (8/11/2011)
I am only a Microsoft Certified Trainer and Red Cross Volunteer.
Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused. How does Red...
August 12, 2011 at 5:38 am
davemiller3 (8/11/2011)
Thanks for replying -Here's an update: if I remove the distinct from the statement, it runs (the cursor opens). Whatever that means !!!!
The DISTINCT keyword...
August 12, 2011 at 4:42 am
NJ-DBA (8/11/2011)
select a.country,a.zone,a.branch,a.user1 as 'user', b.user1 as user2from test a, test b
where a.user1='farooq'
and b.user1='jawwad'
Um, don't use this code. It's outdated, deprecated, and will disappear from SQL Server in the future...
August 11, 2011 at 1:23 pm
sqlmaverick (8/11/2011)
August 11, 2011 at 1:21 pm
davemiller3 (8/11/2011)
I have a cobol stored proc / assembly that runs the following code:
....
The SQL runs fine in both versions of SQL. It runs fine as an...
August 11, 2011 at 1:20 pm
Include Action Execution plan in SSMS (check under Query). Often time, execution times can be explained by the way the SQL Server db engine decides to do similar queries in...
August 11, 2011 at 1:18 pm
Grant Fritchey (8/11/2011)
Well done Brandie. The only real author I know and we still haven't met.
I think it's hilarious that you think you're not a real author.
You're writing, aren't you?
You're...
August 11, 2011 at 11:44 am
I'm published again! "Tales We'll Tell Tomorrow" is the final chapter in the Shadowrun Street Legends sourcebook. It's a novelette this time and my editor loved my fight scene.
If you're...
August 11, 2011 at 11:10 am
Thank you for the response. I appreciate it.
August 11, 2011 at 9:07 am
Additional filegroups also comes in handy for partial backups and segregating read/write information from read only information.
So don't assume that because everything is on the same logical drive that prevents...
August 11, 2011 at 8:43 am
You're very welcome. Let us know the results once you have them (good or bad) as that will help others who stumble across this thread in the future.
August 11, 2011 at 8:41 am
Viewing 15 posts - 5,356 through 5,370 (of 9,712 total)