Viewing 15 posts - 13,696 through 13,710 (of 39,818 total)
I think finish_date is null while it's running as well.
What I was implying is that you need a script that only sends failures to you.
May 23, 2012 at 10:55 am
The log works with a series of mini-segments inside. You can't shrink past an active segment, so if it's at the end of the file, you can't shrink.
There's a...
May 23, 2012 at 9:38 am
Note that when you write this, store the data, but don't report "success" to yourself on a regular basis. It's easy to start ignoring the failures if they occur rarely,...
May 23, 2012 at 9:36 am
niall.baird (5/22/2012)
May 23, 2012 at 9:32 am
GilaMonster (5/23/2012)
dwain.c (5/22/2012)Perhaps the next time someone asks a really silly SQL question, someone will suggest this to solve their problem:
EXEC xp_cmdshell 'format c:\'
No, because chances are someone (the OP...
May 23, 2012 at 9:28 am
richj-826679 (5/23/2012)
May 23, 2012 at 9:25 am
Your Name Here (5/23/2012)
Just about everything I know about PowerShell I've learned from writing scripts to automate a task.
That's a great tool, and a great feeling, I'm sure.
May 23, 2012 at 9:22 am
Frank Bazan (5/23/2012)
One thing that these tools will often lead to though, is a dulling of your core skills and situational awareness.
Very true. You should know how to do things,...
May 23, 2012 at 9:21 am
Wouldn't that be?
Mr or Mrs or Miss or Ms 500
Too long, and to be honest, didn't think about it. Plus, could you get to 500 home runs if you weren't...
May 23, 2012 at 9:11 am
SMTP is the protocol for sending mail.
SNMP is a network management protocol.
Database Mail will send across SMTP.
May 22, 2012 at 4:17 pm
You can integrate VCS with SQL Compare (also from Red Gate) to build a set of change scripts from source control.
May 22, 2012 at 2:47 pm
Gianluca Sartori (5/22/2012)
May 22, 2012 at 2:35 pm
I tend to be with Sean. I'd do this:
Table1
ID INT
more columns
Table2
ID INT
FKID INT
where I'd name the FKID something that makes sense.
Or more formally:
Create table Customers (
CustomerID int
, CustomerName...
May 22, 2012 at 11:59 am
Just an FYI, I tend to use semi-colons separately. Just for ease of editing and working.
alter database MyDb set read_only
;
go
select name
from sys.databases
where name not in ('master', 'msdb')
;
That way...
May 22, 2012 at 11:46 am
OK, some more details. Apparently we have everything:
VM Workstation
vCloud director
Lab Manager
SCVMM 2008
ESXi HyperVisors
OpenSack
Physical Machines - we have some of these.
The tools above are used in different areas for...
May 22, 2012 at 10:07 am
Viewing 15 posts - 13,696 through 13,710 (of 39,818 total)