SQLRNNR (6/15/2011)

---

If there is nothing about those 4000 records to be deleted that makes them similar to one another, then you have to delete 1 by one. If you...

select convert(int,'.') --fails

select convert(money,'.') --0.00

so if your data is only a period, what value did you expect?

i think you'll have to switch to dynamic sql instead for stored procs,views and functions...

edit: just plain bad advice/not needed. see opc.three's excellent comment below.

any possibility it's not a table, but a view or proc or a poorly named constraint or something that happens to be named 'sample'?

select

schema_name(a.schema_id) as SchemaName,

a.name as ObjName,

a.type

from...

actually, a user...

😀

One Procedure To Rule Them All? Lord Of The Rings Style?

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...

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,...

Syed Jahanzaib Bin hassan (6/14/2011)

---

Give other users Readonly rights

...and then try to take the full backup

...and then restore it with different name

...after restore is complete then drop...

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...

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...

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...

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...

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...