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

the only things you identified so far is a slight shortening of a couple of keywords....saving a handful of keystrokes doesn't mean that's an improvement, just a preference.

same thing, different way:

[font="Courier New"]UPDATE mytable

SET myfield= '************' + RIGHT(myfield,4)

WHERE LEN(myfield) = 16 --only change items that are exactly 16 chars

SELECT * FROM mytable WHERE LEN(myfield) <> 16 [[/font]

...

do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

everyone uses the "View Latest Posts", so you need to post this only...

do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

everyone uses the "View Latest Posts", so you need to post this only...

do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

everyone uses the "View Latest Posts", so you need to post this only...

do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

everyone uses the "View Latest Posts", so you need to post this only...

I've done something similar, but made sure it was an application that happens to conenct to SQL server, not do it via SQL server itself.

.NET DataSource object has the ability...