Viewing 12 posts - 1 through 12 (of 12 total)
Thanks!
You made this "unintentional db admin / coder's" day!
April 18, 2013 at 11:07 am
DOH! Really (as in silly me)
Thanks!
November 2, 2012 at 6:04 pm
Thanks for the reply ...
Tried manually entering the UNC. While windows explorer copies fine to the backup server, sql 2005 fails with an error ...
Error 5: Access...
November 2, 2012 at 10:10 am
Ok, will do BUT ... the main gist of this post was your mention of the "profiler"?
We are trying to determine the vulnerability?
October 26, 2012 at 9:48 am
Sorry .. by all means .. I'm new here ... my bad.
A new thread or somewhere you'd prefer?
Robert
October 26, 2012 at 9:38 am
Wow, this is an old thread but still very pertinent.
We are rapidly migrating to SQL 2005.
But we were attacked by injection ... every vharchar field in...
October 26, 2012 at 9:26 am
I typed in the line
DECLARE @NewVal BIGINT = (SELECT MAX(member_id) FROM dbo.member WITH (TABLOCKX))+1;
exactly ... and I get a syntax error Incorrect near '('
October 25, 2012 at 9:56 am
We were also going to make the account number column a key. Then add it is a 0 and update it.
As we cannot add two 0's, (not unique)...
October 25, 2012 at 9:38 am
Thanks for your fast response.
The reason we're doing this is simple.
In order to upgrade our db environment, using clustering, mirroring or whatever methods we choose ... we...
October 25, 2012 at 9:35 am
Did Google this first and it seems some SQL 2005 do not have the Design option.
So one literally has to run an ALTER rather than in 2000 where it...
October 25, 2012 at 8:35 am
Viewing 12 posts - 1 through 12 (of 12 total)