Viewing 15 posts - 34,696 through 34,710 (of 39,725 total)
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...
July 30, 2004 at 7:48 am
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...
July 30, 2004 at 7:35 am
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
July 29, 2004 at 2:36 pm
That's what I'd do, use the FSO. There are other ways, but this is the easiest and smoothest I've found.
July 29, 2004 at 2:32 pm
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...
July 29, 2004 at 11:48 am
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...
July 29, 2004 at 10:11 am
You can't use a VB function in SQL, but many of them are duplicated in SQL Server.
July 29, 2004 at 10:01 am
It is, especially when you have to license all developers. I've not successfully licensed any product for everyone.![]()
July 28, 2004 at 6:06 pm
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...
July 28, 2004 at 2:36 pm
Good suggestion. We bought this forum software, so I'll check and see if they've added it or I'm missing it.
Steve
July 28, 2004 at 2:34 pm
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...
July 28, 2004 at 2:32 pm
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...
July 28, 2004 at 7:59 am
Try something with this: http://www.sqlservercentral.com/columnists/sjones/tamestrings2.asp
July 27, 2004 at 11:13 am
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...
July 27, 2004 at 11:06 am
Viewing 15 posts - 34,696 through 34,710 (of 39,725 total)