Recent content by Joeybear23

Yeah, I have them all registered with SSMS, but that only gives me an on/off status. To browse through them, I have to double-click on each one and then browse through. That wouldn't be a problem, except while in the object explorer none of the registered server structure is gone (groups, etc)...

I am very much accustomed to SQL 2000 Enterprise Manager, and have been awkwardly fumbling my way around the 2005 Management Studio. I do not like how you have to physically connect to each server before you can browse through the server settings, jobs, error logs, etc. With 2000 EM, you have...

I have heard of others having to flat-out wipe and reinstall when putting in a motherboard with a different chipset. SQL/SAP DBA

Actually, the correct answer is that it is "high density" x4 memory, which only certain chipsets can properly utilize. SO, if you decide to buy memory for your computer, make sure you are either getting a standard x8 stick, or have a board that can use x4 RAM. The following AMD chipset boards...

Thanks, garebo. I checked the BIOS version, and I am running the most current. The stick is having the same problem in another computer, so I have conluded it is either a bad stick or just labelled incorrectly. I have contacted the vendor of the RAM and am working out a solution with them...

Also, both sticks are DDR 333 PC2700 SQL/SAP DBA

I have a 1GB stick and a 256MB stick in my home PC, and it is recognizing the 1GB stick as only 512MB. Motherboard: K7VTA3 v6.0c Processor: AMD Sempron 2200+ I would like to rule out everything but bad RAM before sending it back for a refund/replacement. Everything RAM related in the BIOS is...

In order to install Reporting Services, you must have IIS and SQL on the same server... SQL/SAP DBA

Well, I figured it out: I had to uninstall and reinstalll msdtc as per http://support.microsoft.com/default.aspx?scid=kb;en-us;279786 SQL/SAP DBA

Index tuning wizard. SQL/SAP DBA

I don't drop databases often enough to tell you for sure, but it has been hit and miss when I do, and I often have to delete the files manually after dropping. SQL/SAP DBA

The index wizard is a wonderful tool. SQL/SAP DBA

Use hardware compression, which should be the default for the device anyway. It should fit fine when running SQL backups, but going to 1 drive will make it slow. If you send it to 2 simultaneously, your performance will double. I have never used SDLT (I use DLT and LTO2 in my environment). So...

Would it not be: REPLACE (COLDES, ',',' ') SQL/SAP DBA

Here is the text from BOL: REPLACE Replaces all occurrences of the second given string expression in the first string expression with a third expression. Syntax REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3' ) Arguments 'string_expression1' Is the string...