With 2005 and later we now have the DMVs that can be used for this. Take a look at the sys.dm_db_index_usage_stats view. It has the last_user_scan,...,last_user_update columns. One thing to...

So first there are a few things you can do:

1 - If you happen to have sql server 2008 versions then you can use the new import/export wizard as...

Steve Jones - SSC Editor (1/16/2011)

---

Jeffrey has the solution that will probably work best, but you might want to test a couple scenarios out. Ultimately the way your system responds...

I might suggest that you handle the duplicates in the SSIS data flow or in a staged table instead of relying on a trigger. I am not a big fan...

That is right, we still have about 5+ servers that are still SQL 2000 not including their DEV and TEST counterparts.

Good question.

Tricky, tricky, trick question. This would take a history buff to get this one right. Thanks for the History leason.

Maybe everyone has misunderstood my post. I know how to figure out what fill factor to use for different tables. I know that 0 is the same as 100.

I...

Use the db_ddladmin role instead of db_owner. Possibly even create your own database role to limit this even more.

Just curious, is your distributor agent using SQL Server Authentication or Windows Authentication and does the corresponding login on the subscriber server/database have adequate permissions.

Explaination is a little off.

I think you meant count_big(*). COUNT_BIG(all column_2) will not count the...

I forgot to state that the local server is SQL Server 2000 and the remote server is SQL Server 2005 sp3 64bit.

I want to say that this is because of the repeating '5' three times.

yes, I meant start and then stop in the datediff...

You know, that could be a result of having different date formats (no T between date and time would be my...

You are correct, this seems to be an ugly situation to begin with.

There are a lot of assumptions to be made otherwise it will still fail. The first datetime...

If all you need are dates and can do with out time of day and assuming that all rows have date first with similar format, You can try this:

datediff(d,convert(datetime,left(start,10)),convert(datetime,left(stop,10)))

However front...