Viewing 15 posts - 1,966 through 1,980 (of 7,498 total)
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
Good and valid replies so far.
Actually it is YOU who needs to elaborate on data loss for your business clients !
You would need to suppose they have no knowledge what...
June 13, 2011 at 4:18 am
at least your breakfast goes well with your popeye / goofy / ISV-promotion T-shirt :hehe::w00t::-D
-edited-
currently 45 years old kid
June 13, 2011 at 4:12 am
If you need the details, you'll have to use profiler to capture it all.
Maybe have a look at my little article on how we performed it for our usage gathering:
June 13, 2011 at 4:05 am
Viewing 15 posts - 1,966 through 1,980 (of 7,498 total)