Viewing 15 posts - 31 through 45 (of 149 total)
"I found that the Windows Cluster group is offline, and the IP address is showing as failed because its already in use."
Somebody stole your MS Clusters's virtual IP address.
Go get...
May 12, 2011 at 1:59 pm
For kicks, grant "sa" as the job owner and see if it keeps happening.
😀
May 12, 2011 at 10:49 am
"The file name "\\pulse\Image_Storage\ToProcess\" specified in the connection was not valid."
It looks like it's looking for a file name but it's given a Directory path.
"IGIVE Connection manager "IGCXML" Description: The...
May 12, 2011 at 10:03 am
I said 8GB because it sounded like you didn't want to have less than 4GB for the OS. Anything more than 8GB for SQL is better.
A box with 12GB is...
May 12, 2011 at 8:56 am
Have you checked the hard drive performance during this slowness? What's the Disk Queue lenght metrics show?
Also, If I were you I wold set the start memory for SQL at...
May 11, 2011 at 5:06 pm
jordonpilling (5/11/2011)
Problem is, this procs call about 15 other procs (got to love 3rd party software).
Aw man.....
Nested SP's, you have my sympathy.
Try scheduling the agent job to run 20...
May 11, 2011 at 2:48 pm
OK, I figured it out. I had to disjoin the domain first because it is now in the LAB. Kind of weird :hehe: considering I changed ALL the SQL services...
May 11, 2011 at 2:44 pm
Are you using an SSIS package? If you are, you need to put logic in there to replace NULL with CHAR(32) before you insert it into your SQL table.
I think...
May 11, 2011 at 2:36 pm
Try changing the column to a varchar() and assign a default value. If I recall correctly, nvarchar() requires the data to be padded. So if you have an nvarchar(10), you...
May 11, 2011 at 12:34 pm
Set each cell in the SQL table a "Default Value" that is either an empty space or "N/A" or "<UnKnown>" or etc...?
May 10, 2011 at 5:09 pm
Yes.
Here's why I say it does.
The linked server uses one set of credentials provided by the Oracle DBA.
When creating the linked server in SQL 2005 those are the credentials...
January 28, 2011 at 11:34 am
I thought about that but as I am told by the "Network Guru's", nothing like that is happening.
I think I will move the time closer to business times just...
January 28, 2011 at 11:26 am
It's in another IP segment but in the same building. If there were any network/packet rules even the manual run would've failed. The manual runs worked.
January 28, 2011 at 11:20 am
Update...
After resetting the time to run in the wee early morning, it did the same thing. Ran for 12 seconds and reported "Success" for all steps but no data.
So I...
January 28, 2011 at 11:12 am
Viewing 15 posts - 31 through 45 (of 149 total)