maybe you could use the agent just to call xp_cmdshell with T-SQL instead of Operating system (CmdExec)?

another problem that i remember was backups in general.

the DBA's there liked to create maintenance plans that did t-log backups every 30 minutes. so, after SP created a new databases,...

from my experience, having those crazy long names caused a problem for me.

I was tasked with creating a process that used TDP ( a backup solution from IBM ) which...

jumarcil (11/9/2010)

---

Hi Guys;

I am getting the same error as Newbie: "invalid query" The DB is created; so is the sql agent job; running in mixed mode.

I am...

your SQL server is using the memory that you have allocated to it.

if you allowed the SQL Server to determine how much is allocated, the answer is all of it.

if...

leonid.yakhkind (8/2/2010)

---

Hi,

I'd like to create do multi-instances SQL Server 2005 install on one physical server that is going to be a DR (disaster recovery) SQL server for the a few...

[linked_name].master.dbo.sp_helptext 'spoc-name'

will work just fine

yes... 5 hours for 100 GB is WAY to long....

your disk sub system is either 15 years old or something is wrong because of a driver update at the OS...

hows the disk space where you have tempdb?

I have seen what you are describing once before and it was because my drive where tempdb was not big enough to...

i have been running this product all through the beta. (about 2 months now) it has come along way....

my company will be buying it first QTR 2011. (had to wait...

mchofman (11/8/2010)

---

I also found this. I haven't tried it yet, but reading the eventlogs through SSIS is also a very nice method.

http://www.softpedia.com/get/Internet/Servers/Server-Tools/SSIS-Event-Log-Source.shtml

This package provides an SSIS 2005 Data...

is your SQL Server running on the default instance or a named instance?

Locker916 (11/8/2010)

---

Thanks very much for the article. I'm having an issue and I'm hoping someone can offer some assistance with troubleshooting.

I followed the steps in the article and have created...

Matt Hayes (11/8/2010)

---

This example seems to work a treat on two of my SQL Servers (one a 2005 box and the other a 2008 box), however I cant seem to...

http://msdn.microsoft.com/en-us/library/ms190445.aspx