Viewing 15 posts - 1 through 15 (of 43 total)
I cannot wait for this!!!!!!!!!!!!!!!!!
SQL Saturday in my own town. It's going to be amazing!
April 1, 2009 at 3:20 pm
"You can also paypal $30 to email@example.com for a ticket as well."
April 1, 2009 at 7:47 am
This has been, by far, the best video from JumpstartTV that I have seen. You packed a good amount of data on a topic in 3 minutes and gave...
January 28, 2009 at 8:41 am
You can use a cursor and step through each table searching for the users and store the found information in a temp table.
July 27, 2007 at 1:23 pm
Make sure to place a GO statement after each SP you are modifying.
If this isn't the problem, could you post some example code so we can see exactly what...
July 26, 2007 at 7:16 am
To suppress the # rows affected message just include this before your query.
SET NOCOUNT ON
This will take care of the trailing message from the query results.
July 6, 2007 at 7:28 am
I would agree with George, you should look at DTS first. If BCP is required, you can use the queryout option with BCP. It would be a little bit of...
June 22, 2007 at 9:59 am
Not to sound like a smart$%% or anything, but did you have a question about this or were you just posting what you did?
June 18, 2007 at 2:18 pm
Can you post DDL and example data of the tables you are referencing and sample XML that is being used in the query?
June 15, 2007 at 1:27 pm
SELECT TOP 1 cust_id FROM nums ORDER BY sys_create_dt DESC ?
June 7, 2007 at 2:31 pm
I would manually determine if that directory is called scripts or scipts. I have a feeling that this is a type also.
Try running : Xp_cmdshell 'dir E:\Scripts\FULLBACKUP.BAK' and see what...
June 7, 2007 at 2:27 pm
My first guess would be that the GUI is using the user credentials of the service to perform that backup and your user does not have permissions to restore from...
June 6, 2007 at 12:03 pm
Wow...beat me to it and beat the #%^% out of my answer. Nice explanation
June 5, 2007 at 10:52 am
I can't wait to get home and install it on my lab at home!
June 5, 2007 at 10:46 am
Because I am curious as to why ORDER BY is unacceptable to use in this case. It is intersting to me. I am not sure why you would question curiosity.
June 1, 2007 at 12:47 pm