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.

Haven't seen it, but perhaps the start of the job defaulted to success in the table? Usually if a job doesn't complete, from what I remember, there is nothing in...

Good suggestion. We bought this forum software, so I'll check and see if they've added it or I'm missing it.

Steve

These are articles are by the author of the whitepaper and will be coming every Wed for the next few weeks. They form the basis for a methodology that doesn't...

I love this

Questions posted to the site should be free of syntax errors...especially when one of the options as an answer is ... The query has a syntax error.

In...

Try something with this: http://www.sqlservercentral.com/columnists/sjones/tamestrings2.asp

SELECT o.*, r.rownumber

FROM [order details] o

JOIN

(

    SELECT TOP 10 o.productid n, o.quantity, COUNT(*) AS rownumber

    FROM rs r

    GROUP BY o.productid

    ORDER BY COUNT(*) ASC

) b ON b.productid = o.productid

WHERE...