We have scripts which create all the other objects. The only piece we don't have is users and permissions.

But a shared lock like that should go away on it's own, right? As long as nothing else is locking the table)

-K

If I create the clustered index first will that help speed up creating the other indexes?

-Kevin

Nevermind. user error 🙁

-K

OK, I figured that one out:

select c.name "Column Name",

o.name "Table Name"

--i.name "Index Name sometimes"

from sysindexes i,syscolumns c,sysobjects o

where c.id=i.id

and i.id=o.id

and o.xtype<>'S'

BUT HOW ABOUT GETTING THE SIZE OF...

Thanks, I'll give it a try.

-Kevin

I transfer 40 million row talbes (fat tables)

quite often. You mean each one of those rows is passing thru my pc in between the 2 servers???

(not that you didn't say...

Andy,

I am not sure what you meant by:

"High cpu is often (but not always) a symptom of memory shortages driving disk activity. "

Also, each server has 8GB of RAM but...

ME again.

I am running SQL Profiler for 3 days straight.

Would much resources would that use up?

Could that be hosing my CPU? Is the profiler only a resource hit when...

We have vb apps. which run 65 sql strings consecutively all using the same table in a join.

I was wondering if sql server was holding it in memory on it's...

I figured it out:

Why can't I backup/restore my SQL Server database to the network?

The reason is that the MSSQLSERVER service is running under a separate set of NT credentials....

No, they said they were not happy with the SQL Navigator product for SQL Server.

I guess it was designed for Oracle and did not port well.

-K

SQL Navigator tech. support told me they are no longer building it for SQL Navigator and they are stopping support of it.

Here is what my research found:

AdeptSQL Workshop ...

YES

THANKS!!! Works great 🙂