Viewing 15 posts - 6,661 through 6,675 (of 18,926 total)
David Benoit (4/27/2011)
Stefan Krzywicki (4/27/2011)
That mindset is unlikely to go anywhere. Many managers know that if they're not keeping an eye on the workers, they have nothing to offer the...
April 27, 2011 at 9:34 am
hydbadrose (4/26/2011)
I gave up- I am not getting any friendly reply...
I gave you a fully tested, fully working solution which as far as I know you have not even bothered...
April 26, 2011 at 3:58 pm
Revenant (4/26/2011)
Ninja's_RGR'us (4/26/2011)
Revenant (4/26/2011)
UMG Developer (4/26/2011)
Revenant (4/26/2011)
Two points you can make to your (prospective) employer.First, telecommuting saves the employer about $500 per month for workspace..
How do you figure? ($500/month/workspace seems...
April 26, 2011 at 11:30 am
Revenant (4/26/2011)
UMG Developer (4/26/2011)
Revenant (4/26/2011)
Two points you can make to your (prospective) employer.First, telecommuting saves the employer about $500 per month for workspace..
How do you figure? ($500/month/workspace seems like a...
April 26, 2011 at 11:15 am
dbo.sysindexes is pre 2005. It's there only for backward compatibility along with pretty much anything that was available in 2000 and before.
April 26, 2011 at 10:36 am
I preffer to say that you started too late... I can't believe it took you 20 minutes to write that message :w00t:.
April 26, 2011 at 10:29 am
David Burrows (4/26/2011)
hydbadrose (4/26/2011)
Ok so for the following script how would you change in whole;
As I already stated
Sample data to test with (important especially...
April 26, 2011 at 10:27 am
I don't have 2008 to test but that's the first thing I'd try.
sp_helpindex 'tblname'
If that fails I'd go to sys.indexes. It pretty much has to be in that table.
April 26, 2011 at 10:04 am
April 26, 2011 at 9:42 am
hydbadrose (4/26/2011)
,ISNULL((select B.[UsedSpace(MB)]
from [TESTDB].[dbo].DB_USAGE B
where B.[SQLName] = a.[SQLName]
and B.[DBName] = a.[DBName]
and DATEPART(yyyy, B.[ExecuteTime]) = DATEPART(yyyy, DATEADD(mm, -3, a.[ExecuteTime]))
and DATEPART(MM,...
April 26, 2011 at 9:36 am
I've never done it with smtp, but apparently it's doable.
From MS : http://msdn.microsoft.com/en-us/library/ms345234.aspx
April 26, 2011 at 9:30 am
hydbadrose (4/26/2011)
Can some one please help me. I need to have this script ready by end of this month.
Dude, COPY, PASTE, RUN my script. That should get you 99.99%...
April 26, 2011 at 8:54 am
scking (4/26/2011)
April 26, 2011 at 8:35 am
jstariha (4/26/2011)
April 26, 2011 at 8:23 am
Michael Valentine Jones (4/26/2011)
Brandie Tarvin (4/26/2011)
You're right. Totally my bad. I was working of a SQL 2000 assumption and by the time I figured out I was wrong, I was...
April 26, 2011 at 8:14 am
Viewing 15 posts - 6,661 through 6,675 (of 18,926 total)