Viewing 15 posts - 9,046 through 9,060 (of 9,399 total)
You know, a simpler question is nice every once in a while. In fact, I found myself studying it to see what I missed. 🙂 Thanks.
August 14, 2013 at 6:05 am
Another possibility is to use a format file to define your data layout and then use the BULK INSERT command to actually perform the data load. The format file...
August 14, 2013 at 6:01 am
jasona.work (8/13/2013)
The last time I was in a car that felt this sure-footed on the road, was a 1996-7 Eagle Talon TSI....
August 13, 2013 at 1:59 pm
As far as synchronizing connections, there's nothing I'm aware of.
SSMS can detect if a text file changes on disk and prompt you to reload, but nothing with the database as...
August 13, 2013 at 12:08 pm
I believe TDE really only protects against the smash-and-grab risk. People with SELECT permission on the table can still access the data - it's transparent to them. If...
August 13, 2013 at 9:31 am
This is as simple as using Windows to copy and paste the file. If you need it automated, you could write a batch file to copy one or all...
August 13, 2013 at 9:22 am
The Cayenne definitely has a muscle car engine. I saw a TV program once where it actually won in a heads-up 1/4 mile against a motorcycle. Before anyone...
August 12, 2013 at 11:18 am
I did some research (via Bing) and found an interesting article about this very topic: http://www.benjaminnevarez.com/2011/05/optimizer-statistics-on-linked-servers/. It looks like it's based in the permissions of the user executing...
August 12, 2013 at 9:33 am
So, to summarize:
1. You have a database job that calls your stored procedure.
2. Your stored procedure does not call the stored procedure named sp_table_statistics2_rowset.
3. The job runs and complains...
August 12, 2013 at 8:04 am
This really ins't much to go on. Tell me...what are you doing in the procedure sp_table_statistics2_rowset? Specifically, line 105 is the source of the error.
August 12, 2013 at 7:57 am
You could probably shell out to something like WinZip, but I have to agree with Koen - don't use SQL for this. Use .NET or another language.
August 12, 2013 at 7:18 am
DOH! Sean posted the article while I was typing. I guess I don't have to look now.
August 12, 2013 at 6:07 am
peterswe (8/12/2013)
select *
from Job_Queue
where JobQueueID not in
(SELECT JobQueueID
from Payment
where JobQueueID is not null)
will...
August 12, 2013 at 6:06 am
ChrisM@Work (8/12/2013)
Stefan Krzywicki (8/9/2013)
L' Eomot Inversé (8/9/2013)
ChrisM@Work (8/9/2013)
dwain.c (8/9/2013)
ChrisM@Work (8/9/2013)
August 12, 2013 at 5:54 am
Viewing 15 posts - 9,046 through 9,060 (of 9,399 total)