unfortunately you can't call SET PARSENAME inside a procedure...

so you can't wrap noeld's code and put it inside a proc; maight work as dynamic SQL, but I'd have to test...

it depends on the application they are connecting to;

i think if i connect in SSMS, since i can "read" from sysdatabases, i can see all the db's ont he server...but...

i noticed if i add an 800 line block, it'll show all 800 lines; i'd rather have a scrollbar for the code in question, if possible.

seems to hate less-than and greater-than symbols:

this line has the ampersand-LT-semicolon:

salesMonth <=@month and YTD = 0 OR salesMonth = @month and YTD <> 0

this is as you'd type it

...

testing regular text vs the {code} blocks:

with ampersand LT semicolon escapes:

salesMonth <= @month and YTD = 0 OR salesMonth = @month and YTD <> 0

as typed

salesMonth 0

salesMonth ...

you are suffering from "parameter sniffing"; you can search here on SSC for the suggested solutions;

the issue is the default values for your parameters...

since they are assigned NULL, the compiler...

cool, glad you found it; it's probably nothing more than updating the ArcServe program to have your new sa password, or even better, create a login just for that process.

profiler will not show much more than an attempt to login, so that won't help much.

i think the key is to nslookup or ping 10.15.101.24

is that the server itself, or...

ok i put together a script i thought would identify statistics that might need to be updated...

but when i run the results of the script, a few of the tables...

AFAIK, disabling...

i just slapped this together.

i'm using sp_revokeaccess instead of sp_dropuser, because the users might be orphaned and not tied to a login;

this yanks them out the way i expected:

[font="Courier New"]ALTER...

when i think "database", i think SQL server, so that multiple connections can get to a source of data and select/insert/update.

i think of a flat file as a snapshot ofdata...

in .NET, your Datasource has the ability to .WriteXML(pathToFile) and .ReadXML(pathToFile), so it's very easy to load tables into your dataset form say, SQL server, and then write them to...

the virtual table INSERTED, which exists only for the duration of the trigger, has all the records that were updated.

if you show us your current trigger in SQL, we can...

a cursor is like the add + function, where set based is like multiplication.

Using addition as

yeah you can do 2+2+2+2+2+2+2+2 = 16, because that's what you are used to,...