Hi...

I wrote quick little Backup Checking product to check all my SQL Server backups... You will need to register to download it though...

http://www.brettstools.com/CommunityForum/tabid/57/aff/21/afv/topicsview/Default.aspx

ftp? or tcp?

Different systems different outage windows... Ours are usually a 4 hour outage window. With 1200+ servers and 300 SQL instances supporting New Zealand, Aussie, Europe and the US...

Hi...

Your getting the named pipe error because you are connecting to the remote server via named pipes and not tcp/ip.

The quickest and easiest way to get around this is to...

The easiest way to test if you can connect to the server from the client is from the command line...

telnet <IP Address> <Port>

EG: telnet 10.51.27.8 1433

If it works the command...

I was told that this was a feature of the GUI as Microsoft did not want you querying the tables this way and therefore made it slow... Or at...

This query will tell you the status (ONLINE, OFFLINE, SUSPECT, etc...) of all the databases on your server, however it will not tell you if the database has been dropped...

For SQL Server 2000 the statement will succeed... For SQL 2005 you need to qualify the Order by statement with the table name. This question should have been...

Hi...

To prevent backups from deleting, you could always change the backupextension for each maintenaince plan and deletion plan. Make one plan ba1, another ba2, etc... and set the delete...

You could always, create the temp table, transfer the records you want to the temp table, drop the orignal table and then rename the temp table to the orignal table name...

What version of SQL are you using?

How many of the 70 million rows are you deleting?

I have loaded 200GB in one go using 6GB files without a problem

Hi...

I have used this command to get all the instances from SQL Server for a software licensing app.  It's run from within a vb6 app and I just shell out of...

Can you post what the application event log says in regards to this.