Viewing 15 posts - 1,966 through 1,980 (of 7,502 total)
Grant Fritchey (6/15/2011)
That's 10,000 posts, done.Wait, now it's 10,001.
Congratulations, Grant.
Apparently you have been very active today, now you're already at :
Points: 10,881, Visits: 21,283
June 15, 2011 at 7:02 am
If your db is using full ( or bulk ) recovery model, you can and should be making log backups !
There are 3th party tools like APEX log that can...
June 15, 2011 at 5:47 am
The picture use used in the editorial reminded me of the good old ROT13 solution on thread http://www.sqlservercentral.com/Forums/Topic579917-338-1.aspx some years ago. :w00t:
June 15, 2011 at 5:33 am
Can you confirm you are not using SQLServer Express Edition ?
and / or post the @@version of your sql instance ?
June 15, 2011 at 5:05 am
Of course you could use the rownumber or rank functions to just generate a sequence number, but IMHO that column must have had a reason and usage rules during design...
June 15, 2011 at 12:00 am
You'll find your info at http://www.sqlservercentral.com/articles/Administration/2960/
Current service pack for sql2005 is SP4.
I would go for that one.
June 14, 2011 at 10:10 am
I must have read over the "legacy" excuse, so I'll use it myself :sick:
In our environments app devs need to modify their own sprocs or won't allow modification by the...
June 13, 2011 at 1:24 pm
Maybe this can get you started:
-- Overzicht Linked Servers SQL7.0 en SQL2000
-- SELECT srvid, srvstatus, srvname, srvproduct, providername, datasource, location, providerstring, schemadate, topologyx, topologyy, catalog, srvcollation, connecttimeout, querytimeout, srvnetname, isremote,...
June 13, 2011 at 1:13 pm
I'm not a asp/html addict myself, but as shown in the trace result, there is your problem.
So your queries from ssms and asp didn't match.
I'm sorry I cannot help out...
June 13, 2011 at 1:06 pm
Steve Jones - SSC Editor (6/13/2011)
He ignored the fact that...
June 13, 2011 at 9:52 am
Klause Aschenbrenner also did a good job with his ppt.
June 13, 2011 at 9:44 am
In that case, I'd start a profiler trace and capture the actual command sqlserver receives
June 13, 2011 at 9:40 am
Apart from the SQLInjection vulnarability of your query , I would start sql profiler to see what query text actually comes in for sqlserver.
Did you test your query using:
.... where...
June 13, 2011 at 9:24 am
When using a witness, and configuring auto failover, your principal needs a quorum with the mirror OR with the witness. If none of both quorums can be established the principal...
June 13, 2011 at 4:49 am
I just reread your original question and need to revise my answer a bit.
You cannot mirror sqlserver master database !
June 13, 2011 at 4:38 am
Viewing 15 posts - 1,966 through 1,980 (of 7,502 total)