I would try and isolate within the stored procedure the query that is causing the issue, if you view the execution plan, you should be able to work out if...

yep that means it will run the job every 15 minutes between the times specified every day and that includes the weekends

cidr (10/7/2009)

---

Hi there,

There's a job in Agent that from what I can see runs at 12am. However, there's a couple fo things I'm not sure about. The @freq_subday_type...

One way to check it to look at your sql log, it lists the port it is listening on.

Not sure what you are trying to achieve here, you have good suggestions in previous posts. if you want data movement to be based on a data change to a...

Speaking from my experience it is the out of work experiences that make a team motivated, I have seen various attempts done by management to try and motivate teams. if...

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=63&threadid=44702&enterthread=y

I take it that you granted the execute permissions as well to xp_cmdshell

GSquared (10/6/2009)

---

Steve Jones - Editor (10/5/2009)

---

Thinking like a CIO/CEO/or manager should change your job. Think about their point of view, their needs, etc. and it will help you. You don't...

chandu.ade (10/6/2009)

---

Hi,

I have a single duel core CPU with 4 GB RAM Windows2003SP2 with SQL2005SP2. After applying SP2 for SQL the CPU utilisation is going to 100%. SQL Server...

I would go down the BI route, there is more work for the BI side and being certified in BI will give you more of an advantage career wise.

if there is anything that I have learnt from these forums, is that the stupidity of questions is not in scale to the number of points for that op. the...

first reply i thought of was, check out your local hardware store, then i read your question properly instead of skimming it.

I saw this solution on another site, link as...

Matt Whitfield (10/6/2009)

---

1. 2^64

2. Tables have to be named after animals, so the limit is as many animals as you can think of.

3. The usual naming convention for stored procedures...

disk resources can be added to the sql group, either approach will work.

just though i would mention, SSIS is not cluster aware. based on the previous post

I get problems occassionally normally down to a sql server process taking too long to complete.