Check this out:

http://www.sqlservercentral.com/Forums/Topic636438-357-1.aspx

Lynn Pettis (1/14/2009)

---

Nothing wrong with trying to fix a problem yourself. Some of us still do that as it also reinforces solutions. I learn better by doing it...

In Chicago we're supposed to get 8 inches of snow today (it's already begun) before having an artic blast next week that'll keep us around 0 degrees farenheit, as the...

Ok, this is getting weirder. If I run the following:

select *, 'servername' as location from syslogins

For Windows users location displays "servername" but for sql users, it shows their loginname. It's...

Did you stop and start the SQL Server Agent? It would be the least invasive thing to try during business hours.

You could have a "config" db with identical configuration tables but with server appropriate data. Restore the reporting db and all it's data, sps, function, whatever, but never overlay your...

Ed, why use the -g switch as opposed to simply setting a lower fixed amount for SQL within EM? Are there advantages to using the switch?

Arun, how can you function...

I have SharePoint on one of my servers and I cannot put it in simple mode due to the volume of data being added. Read Gail's article and see my...

After reading Gail's article, you need to analyze what your business needs truly are. How much data loss can you withstand? If 30 minutes, backup your logs at a 30...

Restricting growth will cause the database to become pretty much inoperable (except for reads) if it maxes out due to your limitations. Size it accordingly, backup it up regularly and...

BINGO! That's when I signoff on the OP.

run this and post what is returned. look it up in BOL.

sp_helplinkedsrvlogin

I'm not familiar with SQL2005 but in SQL2000, when opening the properties on my linked server, there is a security tab. If compatible in 2005, what do you have listed...

And while you don't seem to be quite there yet, a simple SQL script using the four part naming convention would be as follows:

--edit - delete computerB.OptCon.dbo.tablename - then the...

Steve Jones - Editor (12/23/2008)

---

Here's a great email to the webmaster. Figured it would look great in this thread.

Subject:Respected sir/madam, [Regarding experiece and company name with 2 years experience]

my name...