Thanks Gila,...

anthony.green (1/22/2013)

---

Do you have traceflag 1222 enabled?

If so can you post the deadlock graph from the error log

If not run

DBCC TRACEON (1222, -1)

and then post the graphs once a deadlock...

I had to create a login for the windows admin user in SQL with permissions to the MSDB

Yes SQL Server Integration Services is running, how do i check what port its running on? after some googling it seems it can only run on port 135?

opc.three (12/13/2012)

---

Connection from their IP? I thought you said you were connecting to a remote MySQL server. From a network security perspective only an outgoing connection from the server running...

Awesome , thankyou

I think it should be fine, i get the data from a MySql database belonging to an external supplier. We have only allowed the connection from their IP so shouldn't...

ESAT ERKEC (12/5/2012)

---

Task Manager -> Resource Monitor ->Disk-> Filter the sql server.exe and then look at the ratio can you see mdf and ldf file of mirror db....

for windows 2008...

Anyone have any suggestions? What other things I may check to see what the bottleneck is?

Thanks

Don't think you can create a trigger on a temp table:

see this post

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96386

Minnu (12/4/2012)

---

Hi SSC Team,

i have created a stored procedure with a "table variable" in it,

inserted some records into table variable based on some conditions.

and my requirement is :

i have another...

Okay I've done a bit of digging and its more than likely the mirrored db that is causing the high I/O disk activity. Below are the stats ive collected

Info gathered...

Want a cool sig (11/29/2012)

---

bugg (11/29/2012)

---

Hi All,

I have created an SSIS package that grabs data from an external suppliers mySQL database and then imports into our database.

To get this to...

Awesome responses guys thank you so much, this site rocks 🙂

I've been flat out doing queries and other schema changes and haven't had a chance to run dbcc checkdb yet...

Joie Andrew (11/18/2012)

---

First and foremost before even considering any changes to the current schema if it were me I would work to identify the current environment a little more. Specifically...