That's not in SSMS It's an add on

I used to backup some every hour, some every 15 minutes. No idea about banks, but most of these guys would have multiple levels of protection, clusters, replication, etc.

You'd be...

Well, still the same prescription here.

Thought after all this advice, I think I'll be looking for an LCD soon.

Can you not pull out the last SELECT TOP 1 and store that in a variable. Then Not sure why you have () = (). Are you looking for an...

How much mem on the server and what are the big users? Look in Task Manager

BCP is nice, if you can "identify" the records to be backed up, you can script this or even use a scheduled DTS job to send it out.

Be sure your...

Use a global temp table:

create table ##mytemp()

Sounds like you're having a rough day.

Here's a few things to check. First, double check the account the SQL Server is starting with and I'd make it an administrator. I...

That is strange. Never seen that. The Autoclose will result in this message, but not sure why you'd see this with no dbs having those names.

Check master.dbo.sysdatabases to see if...

I've usually had EM script fine, but I'm not sure if I've done hundreds of tables. I usually have everything in one script.

One thing you could do to debug...

Thanks for all the comments. I think I'm leaning towards a Nokia. I don't do a lot of email/data entry/web, so not sure I want a Windows Mobile, but I'll...

Try connecting with Data Sources in control panel and see if you can get a test connection to work.

Also, how are you specifying credentials. Which server name is going in?

Karim,

I think you might be the smartest DBA in a few months if you keep this up

The boot page, I suspect, is what...

Is this SQL 2005? I thought they fixed this but perhaps not.

In SQL 2000, there definitely is no way to determine this. I used to schedule a script to load...

No idea here. You might need to call PSS, but I suspect they'll tell you SP4.