Are clients connecting now? They shouldn't be if they're using server name. If they're using IP, it should work.

There are some products that can restore a single object, but they'll pull back the data for that object.

Otherwise if you just want the objects, no data, then I'd use...

Space is row length * rows.

So you can work out the max for a row, but it doesn't give you space used by a table. There are other scripts that...

There are quite a few things that you can't do in Enterprise Manager against 2005 servers. You'll need to move to SSMS.

There's a facility for running DTS packages in 2005....

First, please don't post in all CAPS.

There's no easy way to explain this. The query optimizer runs through a number of plans and tries to guess which indexes or joins...

I took that series (431, 441, 443, 444) and I thought 431 was the hardest. There were a lot of configuration and admin type questions, which I thought were nit...

Bottom line is you can. You won't hurt the database server or data, but users might have app issues.

We have these set up as redirects for tracking purposes. It helps us to go back and see which links are popular.

We've included the source from which the link comes,...

Go with R10 if you can afford it. Separate logs and data.

nope. This is a major shortfall of maintenance plans.

I've used scripts instead to power backups. It's easy to find some on this site or others, which will scan for non-system...

For one, worker threads shouldn't be set to the max. The default of 255 will handle 1000 sessions.

Second, as Colin asked, what else have you changed?

reboot.

Something's wrong. I've seen this at times and the only thing that will clear it is a restart of SQL Server. The rollback will likely completely quickly when it restarts.

select * from information_schema.columns where table_name = 'Customers'

will give you the max length of the values, but the issue is that each row can have different data. What exactly are...

While I agree with the two responses above, why do you want to do this? I'd be curious to know what you're trying to achieve.

I tend to agree with Colin and Grant, but which is which in the batch %? You have Query One twice.