Sorry, an announcement coming. I've set up separate feeds here:

WMV: http://www.sqlservercentral.com/Xml/Rss/Articles/Editorial%20-%20WMV/

iPod (MP4)

http://www.sqlservercentral.com/Xml/Rss/Articles/Editorial%20-%20iPod/

MP3

http://www.sqlservercentral.com/Xml/Rss/Articles/Editorial%20-%20MP3/

I think you'd need to to two passes of the file, or perhaps some strange scripting.

Honestly Whitt, I think simpler is better. I'd pull the whole file into SQL Server...

I certainly don't mind interviewing, but I'd like to think someone would hire me 🙂

Course, hoping I don't ever have to find out 😉

And just thought of this: add a separate BAT/CMD file for each new drive letter. It will help you keep organized, you can count the number of files to be...

What's "best", is a hard question. And it varies by manager and company.

To me, the best is someone that fits with the team, gets along, works hard independently but within...

Keep in mind that the log can be bigger than the data size. It depends on transaction volume. I could have a 1MB database with 1 table, 1 row, 1...

SQL 2K5 includes the SQL Native Client, which isn't included with the SQL 2000 tools, nor with W2K or XP. I think Vista has it, but that problem is likely...

It sounds like the user just doesn't have INSERT permissions on the table in the other database. SELECT permissions are different from INSERT permissions.

You don't need datawriter. Create a...

select * From sysschedules

Goes for all jobs. Maintenance plans are jobs.

Also keep in mind that blocking is normal and expected. It should just be of a short duration. If you're having longer durations, I'd trace (Profiler) the user you think...

Johan has some good ideas. I think you need to go with the custom role that you have, work out the permissions.

And write us an article! I'm sure other people...

I still think it's a fundamental bad idea to include periods.

It will also distract and confuse others, which is something you should consider. The job is bigger than you and...

John,

It can be a pain, but I'd script it out so you can see it in front of you, maybe ask someone else to verify that you have things moving...

I'd be interested to hear about the MAC address. I thought everything sent in the connection was determined by the client sender, not the network or any automatic/authentic service. Since...

If the files are large, you still have to copy them. There's no magic SQL Server way to get them to the new drive.