It doesn't have any effect on the server. It's code that might be using this account to connect that would break. If it does, it shouldn't be using this...

The way the SQL parser works, it can't compile a plan without having a table name available, so this isn't allowed. Dynamic SQL (EXEC) as shown above is the only...

What do you mean by secure?

From the source or what you've collected? If you want to secure what you've collected, keep it in a separate db (I'd recommend one on...

Can you post the actual queries? Doesn't sound like you missed anything, but I'd like to see them. Also, if you check the data, what is the selectivity for the...

For backup, use the native SQL backup to get a backup to disk. NtBackup can take it to tape if you need it.

For reports, I'd use Reporting Services. Not sure...

First, should put this in the SQL 2000 forums (I've moved it).

Second, how did you move the dbs?

Third, is memory adjusted differently for SQL Server? same for data file layout...

RTM is the original release of 2000. That is build 194 (8.00.194). Service Pack 4 is 8.00.2039

What does @@version return? There are hotfixes post SP4, so your version might be...

Jeff brings up good points, though I'm not sure everyone feels that way. If you have experience and have gotten certified (MCDBA, MCITP), then you can show that the test...

I actually tend to agree with Sir Slicendice that it's hard to predict where you'll be, to what level you'll have success, what type of scalability is needed, etc. And...

Veritas centralizes many of your backups, but are you going to tape or disk with Veritas? I've had problems before with Veritas and Seagate's drivers in restoring databases, so be...

Be careful about using live data to generate test data without some obfuscation. If you have personal data (names, phones, SSNs, etc.) you should change these around somehow. Make some...

I haven't done property management, but I did some work with education and we had a very free slowing type of architecture as well.

We used to handle this two...

I hear from a lot of companies and some are pretty good abourt training their people and helping them keep current IF they are using those technologies. If they're not,...

Being in the US working for UK, I think the UK is doing a bit better right now in raw numbers.

I think offshoring will still happen, but it's not a...

For a manager, an MBA would be better, in my opinion. I don't think a CS degree matters that much for any position in IT. I've never given any major...