measured in days, it's same as the length of a piece of string in cubits.

I wrote an app called sqlspec that may be of use to you. It shows dependency diagrams and pk-fk diagrams for all objects in any database on every major...

bcp operates on flat text files, not mdb.

you don't need to drop the table - why not just drop and recreate the index? you could do so with ALTER TABLE for example

I say sequel.

A friend of mine says "squeal"

🙂

if you care about ANSI compliance, better to use INFORMATION_SCHEMA views. but who cares about that... 🙂

if you are loading the table again with 200m rows, it's faster to drop the index, load the table, then recreate the index.

also, I hope you are using BCP or...

yes, drop is fast too.

delete is slow because the whole mess is logged to the transaction logs.

I'm afraid you'll just have to wait this time because the server is busy...

next time try TRUNCATE if you are wiping out the whole table.

if you save and close the query window in SSMS, it will usually respond to that.

maybe you misunderstood me. SqlSpec DOES document jobs. You just need to specify that you want it to document jobs.

SqlSpec does document jobs, but not by default. To do it, you need to check the...

glad to hear you are a fan of documentation tools. here's a shameless plug for one I wrote. 🙂

It supports 11 different DBMS in addition to SQL Server....

I wrote an app called SqlSpec that does this. It supports 11 different DBMS platforms, including SQL Server. See the link in my sig below for details.

there are many options...

onlo (12/13/2007)

---

Dear all,

Microsoft said :

SQL Server 2005 Books Online (September 2007)

Script Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new...