count(*) usually pulls the count from sysindexes. There were problems with this being accurate in SQL 65 (possible 70). I think in 2000, this is accurate.

Steve Jones

steve@dkranch.net

Perhaps some data item is causing QA to drop the connection. Is this a specific table or all tables/servers? Is it the same amount of rows each time?

Steve Jones

steve@dkranch.net

Perhaps some data item is causing QA to drop the connection. Is this a specific table or all tables/servers? Is it the same amount of rows each time?

Steve Jones

steve@dkranch.net

If the log file doesn't shrink (after following both posts above), there is a script in the library here that will help.

Steve Jones

steve@dkranch.net

Can you connect via isql? Or Query Analyzer?

EM uses more than one connection and if you are single user mode, you cannot use this.

Steve Jones

steve@dkranch.net

Agree with Andy. Use the upgrade and go to 2000 directly.

Steve Jones

steve@dkranch.net

And please follow up here. I (and others) are curious to find out what is happening.

Steve Jones

steve@dkranch.net

I agree a log would be the outage window, but keep in mind if you are out for longer than the window for a transaction log, you will need to...

Clustered index stores the data in the order of the index (physically). Nice for columns used in range queries (like dates). Only one per table as you can only store...

You are welcome. That's a handy one to keep in mind.

Steve Jones

steve@dkranch.net

Not easy. You'd have to build a SQL join for each column you need. USually this is done with dynamic SQL as

select emp.emp-code, b.time as b.date, c.time as c.date

...

You can in T-SQL, but it's an ugly mail message you have to build. I too wish MS had included this.

Send it to sqlwish@microsoft.com

Steve Jones

steve@dkranch.net

When you use Windows Auth, the windows credentials (essentially a token) are passed to SQL Server, which then verifies this with a DC.

First, it's a security risk across the Internet...

Antares is correct. When you execute certain stored procedures (system ones) permissions are rechecked for security purposes. I think the solution proposed above is a great one.

Steve Jones

steve@dkranch.net

If it doesn't have to be realtime, then I usually insert the data into a table and have a job come create those users every minute.

I had a similar issue...