Viewing 15 posts - 826 through 840 (of 1,319 total)
Check this out:
http://www.sqlservercentral.com/Forums/Topic636438-357-1.aspx
-- You can't be late until you show up.
January 14, 2009 at 2:44 pm
Lynn Pettis (1/14/2009)
-- You can't be late until you show up.
January 14, 2009 at 9:35 am
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...
-- You can't be late until you show up.
January 9, 2009 at 7:36 am
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...
-- You can't be late until you show up.
January 8, 2009 at 2:13 pm
Did you stop and start the SQL Server Agent? It would be the least invasive thing to try during business hours.
-- You can't be late until you show up.
January 8, 2009 at 1:48 pm
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...
-- You can't be late until you show up.
January 8, 2009 at 1:24 pm
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...
-- You can't be late until you show up.
January 8, 2009 at 12:57 pm
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...
-- You can't be late until you show up.
December 30, 2008 at 2:44 pm
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...
-- You can't be late until you show up.
December 30, 2008 at 1:53 pm
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...
-- You can't be late until you show up.
December 30, 2008 at 1:13 pm
Brandie Tarvin (12/30/2008)
But again, he doesn't seem to be listening to that advice.
BINGO! That's when I signoff on the OP.
-- You can't be late until you show up.
December 30, 2008 at 6:39 am
run this and post what is returned. look it up in BOL.
sp_helplinkedsrvlogin
-- You can't be late until you show up.
December 24, 2008 at 10:06 am
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...
-- You can't be late until you show up.
December 24, 2008 at 9:54 am
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...
-- You can't be late until you show up.
December 23, 2008 at 2:48 pm
Steve Jones - Editor (12/23/2008)
Subject:Respected sir/madam, [Regarding experiece and company name with 2 years experience]
my name...
-- You can't be late until you show up.
December 23, 2008 at 1:58 pm
Viewing 15 posts - 826 through 840 (of 1,319 total)