You can also use CHARINDEX to find the place where the underscore is and take a substring up to that point.

Apparently I can't win.

Those who mentioned CE or MSDE, you are overthinking the question. It isn't meant to trick you, but to test your knowledge. I would have assumed that...

At first glance, I'm thinking dynamic sql is the other way, but I might be interetsed in 12 procedures instead. Not like they'd change that often.

Having a Beta group is a possibility. we've talked about it, but it adds overhead for us to somehow get the question out to people, and have them answer it....

It should be able to be done if you are backing up everything iwth the product. You can also backup the data with Veritas (or anything else) and the logs...

If you can compose and deliver and HTML email, many systems use a small 1x1 pixel white image to track reads. They create a few million unique ones, mail the...

Keep in mind that there will be lots of traffic to 1434, the MS tools might be sending things to this. I belive Enterprise Manager sends some UDPs out to...

I'd create a role in B and assign that permissions. Then if you can use an NT group with both roles, do that. If not, add everyone with the role...

They do not need to be administrators. It makes things easier, but you can set permissions to  use any local or domain account.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811

Thanks for the followup

That's what I'd do, use the FSO. There are other ways, but this is the easiest and smoothest I've found.

I tend to agree with Bill. SQL Backups just work. Some third parties work better than others, and I've had issues with some. We use Litespeed here (not that it's...

You can preallocate more space to tempdb. It is possible that it is trying to grow to accomodate the query and it is too slow, so the optimizeer reports an...

You can't use a VB function in SQL, but many of them are duplicated in SQL Server.

It is, especially when you have to license all developers. I've not successfully licensed any product for everyone.