Viewing 15 posts - 2,146 through 2,160 (of 9,641 total)
rgtft (10/2/2011)
Jack Corbett (9/30/2011)
"An error has occurred while sending this row to destination data source.".
Is it a network connectivity issue? It seems I've gotten that vague (non-helpful) error message...
October 3, 2011 at 6:38 am
Thanks for the congratulations all.
It's nice to be recognized, but I also know that when I've been in the room with MVP's and the people I've met from this...
October 2, 2011 at 6:19 pm
GilaMonster (10/1/2011)
Jack Corbett (10/1/2011)
I just hope I can honor that award the way that all the...
October 2, 2011 at 6:13 pm
Hey guys I got some really cool news today. I was awarded MVP status!
I just hope I can honor that award the way that all the MVP's on here...
October 1, 2011 at 10:40 am
Gee thanks. I'm glad I edited it and put that sentence back in. This one has me befuddled completely.
September 30, 2011 at 2:13 pm
george sibbald (9/29/2011)
wasn't meaning to have a go Jack, I just read it that the op was after a percentage.
I know you weren't George. But you did get me....
September 29, 2011 at 2:48 pm
george sibbald (9/29/2011)
Jack Corbett (9/29/2011)
SELECT
DF.name,
size,
FILEPROPERTY(DF.name, 'spaceused') AS pages_used
FROM
sys.database_files AS...
September 29, 2011 at 1:45 pm
SQLRNNR (9/29/2011)
Lowell (9/29/2011)
does SQL 2000 support logon triggers? i think that's only 2005 and above, rioght?Correct
Logon Triggers can be used for this if, but they may not work because the...
September 29, 2011 at 11:39 am
SQLRNNR (9/29/2011)
Jack Corbett (9/29/2011)
September 29, 2011 at 10:46 am
You can do this as well:
SELECT
DF.name,
size,
FILEPROPERTY(DF.name, 'spaceused') AS pages_used
FROM
sys.database_files AS DF
September 29, 2011 at 10:43 am
No. If an account is granted login rights to a SQL Server you can't restrict what application they use to connect. At least not within standard SQL Server...
September 29, 2011 at 10:28 am
I noticed the row estimations at the beginning. Stats were updated today, so I don't know why they'd be off. I'll look at doing the update before to...
September 28, 2011 at 4:03 pm
Here's the actual execution plan. This is pretty much what it should look like. I am deleting from all the child tables prior to this so they should...
September 28, 2011 at 2:50 pm
That's what I thought. It'll be awhile....
September 28, 2011 at 12:35 pm
Okay, here's an actual plan where no actual work is needed because I have to run the entire process before this will run successfully.
I'll re-run the process to the point...
September 28, 2011 at 12:13 pm
Viewing 15 posts - 2,146 through 2,160 (of 9,641 total)