Viewing 15 posts - 7,381 through 7,395 (of 13,469 total)
i recently threw some of my free time at a local non-profit; they've been around for twelve years, but still didn't have a web site.
That was one of those undefined...
June 14, 2011 at 9:12 am
based on the error, is there any chance someone has the database open? the linked server requires exclusive access, right? that error "It is already opened exclusively by another user,...
June 14, 2011 at 9:03 am
Syed Jahanzaib Bin hassan (6/14/2011)
...and then try to take the full backup
...and then restore it with different name
...after restore is complete then drop...
June 14, 2011 at 7:02 am
i'll leave the research and testing to you, but here's a quick list, in the order that i would try first:
1. use the OPTION(OPTIMIZE FOR @p1 UNKNOWN) or OPTION(OPTIMIZE...
June 14, 2011 at 6:36 am
sounds like "parameter sniffing"
typical symptoms:
1. SSMS with hardcoded values = fast
2. With Recompile = fast
3. run from an application with values other than you tested with = slow.
there's a lot...
June 14, 2011 at 6:09 am
i think it's all back to html and your form...clearly someone typed a value into a input type="text", right?
and all values in a form are encoded to html-acceptable values....
can you...
June 13, 2011 at 11:04 am
missing too many details..
you have two tables, header and footer, or is this a text file?
if it is a pair of tables, is there a relationship betwene the header table...
June 13, 2011 at 9:38 am
yep implicit conversion:
also note your command is wide open to sql injection; you'd be better off switching to parameters.
add the N to the front of your command:
sqlString...
June 13, 2011 at 9:24 am
are you using parameters from the asp page?
the datatype of the parameter is probably the issue in this case;
can you show us how the parameter is being passed to your...
June 13, 2011 at 9:11 am
well this stands out to me:
There isn't a single process which uses every field in the table.
that means some, or many of the columns might be null...for me,that alone would...
June 13, 2011 at 8:50 am
we'd have to see your code, but are you doing something like this? remember @@ROWCOUNT gets reset with EVERY command, including SET operations, so you have to be careful.
DECLARE @mycount...
June 13, 2011 at 8:20 am
allmhuran (6/13/2011)
words like "array" and "loop through"
couldn't help but think of an old cowboy movie with someone saying "Them Thar is Fightin' Words!"
June 13, 2011 at 8:17 am
lol...i use it myself whenever i feel like it...but can i justify using it at all; it was the fastest to grab tool in the toolbox...nah, can't justify myself at...
June 13, 2011 at 8:03 am
following up on what Ron said, my google search lead me to lots of pdf files, as well as some information about creating UB92 or it's "digital equivilent"
is this just...
June 13, 2011 at 7:50 am
on windows 7 machines, security is tighter...local users are not automatically added as SQL administrators unless you specifically add them;
easiest way,since you said SQL 2005, is to use the surface...
June 13, 2011 at 6:42 am
Viewing 15 posts - 7,381 through 7,395 (of 13,469 total)