I was expecting these types of responses, but I wasn't sure quite how I wanted to frame this. And Mr. Blandry, wrist slap noted and it stings!:hehe:

We definitely have to...

It's possible that you have machine (OS/hardware ) issues. One quick check, swap the network cable out.

Beyond that, can she log in from another machine? Can you log in from...

there are issues with the VLFs sometimes. You can use this script to try and shrink things. Note that it will mess with your log and backups, so I'd plan...

I don't think I'd advocate trashing existing systems and moving to VMs for many people at all. Instead I'd start learning about it, and perhaps shifting some systems to VMs...

It sounds like you're in a bad situation. Honestly, you are playing with fire here. One issue, and it's possible that you will be without data, and then without a...

I think if the transaction fails with a full tempdb log, it gets rolled back. It seems to me I've seen that written somewhere.

Can you make the job fail? It...

There are absolutely systems with multiple inserts in a split second, and it's not 1000 needed, it's 2 that can cause issues.

I still don't see a reason why identity won't...

I'd agree that you shouldn't mess with the design, and I'd also be careful about basing things on date. Dups will occur, and then you'll be in the case where...

Well, I for one, am sad the NBA ended last night. I was rooting for a Laker's chapionship, but in 6 or 7 games.

Based on that, I think you want the application to generate the flat file and then save it to the server. It doesn't need to have SQL Server generate it.

And if it's for a client app, why not client side.

I just thought as well that SSRS might be the simplest way to do this if clients are going to...

I believe this is an uninstall and reinstall. You should be able to detach databases, and script out user/passwords if you need to.

If you just need to extract data server side, I'd look at SSIS. Or DTS in SQL 7/2000. You can use the data export wizard to create the basic...

Both of your emails, and your name, are protected by SSC. I can see them when I look up the account, but no one else can.

Nothing else is worth a...

The issue with SQLCMD is passing in the output file name.

You could, for example, calculate the filename in T-SQL, then pass that to SQLCMD as part of an XP-cmdshelll string....