linked servers are notorious for slow performance; the reason is typically becuase the data is copied from the linked server into your servers tempdb, and then your operation/joins are performed...so...

you are right...it looks like his maxnum() function returns the next available value...so it should be one less than that when added to row_number, unless he doesn't care about skipping...

well third party log sniffers are great , but you can set up a trace going forward for free.

Also, remember that the Application name can be faked by a developer-savvy...

forget the cursor, use a the row_number function or a Tally table to join to to get your starting max number:

something like this, if the query returns multiple rows, would...

i still have to support a few SQL 2000 clients that have not upgraded yet, it's not that uncommon that companies do not upgrade when their db system does what...

maybe one of the articles required registration on another site, so you duplicated the same email for registration for that article? check your cookies or firefoxes saved passwords...see if you...

there was a similar thread, where someone wanted to cleanup misspellings int eh database to get teh addresses normalized;

take a look at this thread:http://www.sqlservercentral.com/Forums/Topic743750-338-1.aspx

we threw together some interesting scripts to...

it's statistics that is killing your query.

as statistics get more and more out of date, the saved execution plan takes longer and longer, as the original plan is inaccurate.

reindexing also...

anitha is incorrect, he's confusing the way oracle or other databases handle triggers, vs the way SQL Server works.

SQL Server's trigger is called once for any statement, whether it is...

Lately I'm swimming in spam messages from fake addresses that come from (supposedly) a .es domain email address, like 'santos2@telecable.es'; (I hope SSC can fix that for me too...just kidding)...

the default trace should have what you are after;

i just did a backup, and confirmed that it appears in the trace.

here's some code for you to test with:

declare @sql varchar(max)

declare...

I hope I can help clarify a bit.

some of the 3rd party Log readers , like from RedGate, can read your database and log files, and show you who did...

try this: http://www.microsoft.com/downloads/details.aspx?familyid=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en

That's straight from microsoft: the SQL 2000 MSDE (Desktop Edition), which is the old free for testing and evaluation version.

a simple syntax error;

INSERTED is a virtual table that exists just inside the trigger...so there is no table called [TRAIN].[dbo].inserted [/b]

this should be:

SELECT @SRVSTAT = SRVSTAT,

...

Scripting this out is not all that difficult; I slapped together the examples just from the top of my head...you just have to do it one piece at a time....the...