You need to stream this out with ADO. It doesn't need to be C# code, simple VBScript or Powershell could help here.

http://support.microsoft.com/kb/258038

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=7354

http://andrewu.co.uk/clj/load_and_save_file_helper_functions/

you can call system functions in the trigger (suser_sname(), user user_name()) to find out which account is used.

Developers can make fine admins, they just usually don't. It comes down to human nature and it's because they're likely to make changes or fix things on the fly, with...

You can create views to simplify the querying.

There are other ways of dealing with this, such as indexed views, moving data to another database that is less normalized for performance,...

You can view the execution plan in SSMS for the query and see the order in which things are applied. The short answer is "it depends". The optimizer will consider...

I'd like to think that MS has credited their code where needed, but that's a good point. They used to give credit to the BSD TCP stack, which was used...

I'll take a look at see what happened.

Is that more than 16 data files? Or is it with log files?

sp_attach_db has hardcoded 16 file limit because of the parameters. Look at the code. If you're doing more...

Thanks for the note.

We have asked that people whitelist, which should help. Not sure what else we can do here. The newsletter is fairly simple, though my editorials ramble...

There is no global public role. There's only a public role in each database and you can't remove that role. I wouldn't think any system functions relied on that, but...

Hey, thanks for the chemistry notes.

I think I'll volunteer to help calibrate the breathalyzers around here. Bring them to my house between 6 and 7 on Fri and Sat. I'll...

Lobbying successful. Points awarded back and I agree this was poorly worded.

Try adding two SQL steps in the DTS package.

First: drop table with the name for the first.

Then do a create table, you can get the SQL from the transform...

It is open to anyone, but really geared for people in MCS or MS Partners that can bill it out.

It's so new as well, I'm not sure there's a value....

Sorry, forgot that was for log space only.

One thing you could do is track the space in tempdb using a proc and either store it in an admin table somewhere,...