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

if you can provide the actual CREATE TABLE statements for the tables in question, we could help you better;

sp_fkeys tblBOQ would give all the dependant tables to the table(is that...

yes, it will still work, you just have to follow all of the nodes of the tree:

for example, say my "Childtable" has FK records to it:

it might not be obvious,...

another way to do the same thing is to order by the length, then by the column:

select * from #temp order by len(Response),response

...well not the same thing, but similar...with the...

a much better solution is to use a set based operation; cursors are much slower.

you didn't provide any details, so here's a rough example:

by "copying", I'm assuming you mean to...

i would suggest adding a trace as well as the fine trigger example above; there's a thread here with my example of the trace i use:

http://www.sqlservercentral.com/Forums/FindPost745574.aspx

with the trace, you'd see...

with a table with no index, SQL server automatically creates a heap index, so there is at least some information on your table.

for the count, I'm guessing that although it's...