Maybe no more disks around

You probably need to run a backup transaction xxx with no_log to free up space. You would also want to setup a regular log backup or move to simple mode.

The server decides this and the DBA has no control over this.

You'll need to reduce the size of the result set, or remove some things like ordering. What kind of 50M result set can you actually work with? If this is...

I think you need to enable remote connections as a server setting. Try sp_configure or the properties for the server.

And the key should be periodically changed. Wouldn't want someone to "crack" last year's backup and then be able to use the key to get current card numbers.

With that, be...

Anytime and definitely a varchar. Perf should be fine.

Haven't changed anything. Is it IE 6?

If you work with the DMO libraries, there is a ListSQLServers method call that will scan for those servers responding on 1434. this is sometimes blocked, especially after SQLSlammer, so...

If you netstat, is SQL Server listening on 1433 or possibly another port?

I'd double check the firewall. Firewall rules aren't necessarily global. You could have something blocked on that IP.

Charles has a good example.

If you mean the representation of the code as the numbers, then I'd use that. If you mean an image of the code, I wouldn't use that.

You can setup the...

firewall?

I'd suggest calling Microsoft PSS. The $249 cost isn't much and you are dealing with the low level internals here. They can help you work through this, though they may...

You can't do this with a case because that processes for each row. You'd need some way to "join" the two queries together. In other words, how do you get...