Neccessary ? Well it depends on your site/organization. I've been doing MS SQL since v4.21 through SQL 2K5 and have not had one instance of needing to know XML and...

The only additional advice to add is to make sure you make things an MSI package using the MS tools - not that of a third party vendor. Your support...

Any process will work, it really depends on a number of things that are site dependent. Things like size, number of servers number and type of environments, use of source code...

Could you post the actual error message please ?

Yiou could try using Meta-LUNs instead of LUNs. Also, have you maxed out the cache on your SAN yet ???

Eric, I do not think that it it the advertiser that's causing the CPU surge. If it was then the SSC (Steve) would have been inundatdd with complaints. I've used the site...

I've reada a number of things on this (although never had the need) ... here's something that I Google'd ...

http://episteme.arstechnica.com/eve/forums/a/tpc/f/12009443/m/937007490831/inc/1

In SQL 2K, SPs are the culprit a DBA can control. However in SQL 2K5, there is now the "Pandoras Box" of "CLR" ...

But in reality Steve, as a DBA,...

It cannot be done via native SQL and QA. If you cannot do it from QA then you cannot do it from C#.  However, you may consider restoring to an...

• Do I gamble ? NO.
• Do I view porn ? NO.
• Do I watch movies ? NO.
• Do I listen to streaming music ? NO.
• Do I user external email at work ? NO.
• Do...

I too have been gettting intermittent "URL not found" errors when linking to discussions. 90% of the time the links work. Now for the 10% that fail the first try,...

@@servername is set on SQL Server startup. Even though you execute the sp_dropserver/sp_addserver the value is still null. You need to restart SQL Server.

have you checked things against:

http://www.connectionstrings.com/

Loner, no platitudes nor advice about getting another job ... just a few words (wise or not) that have server me well in life so far ...

"There is ONLY...

The information about changing the 'logical name' of the file is partially correct. I state this because you cannot change it on the restore, however you can perform an ALTER...