Viewing 7 posts - 76 through 82 (of 82 total)
Hi
DBA hat on
the parrallel packets to me just cause waits 🙂 if you look in sys.dm_os_wait_stats order by wait_time_ms desc .
If your cx packets is in the top 10 I'd...
July 19, 2011 at 5:16 pm
Hi
my guess would be that the problem isn't in your code.
That looks like it's just unable to access the server.
Ensure you can telnet to the server and that you can...
July 19, 2011 at 4:57 pm
Have you restarted the agent ?
exec sp_configure 'agent xp', 1
reconfigure
July 19, 2011 at 4:52 pm
Hi
I suggest to get an idea of any query is to hit ctrl+ l and get the query plan and see where your cost is.
Yes to the other replies,...
July 19, 2011 at 4:39 pm
The user that you are using don't have access to the file system.
Grant yourself relevenat permissions on the drive you want to create the DB on.
Cheers
Jannie
July 19, 2011 at 4:37 pm
Do you mean that you can send mail when you test the profile but when you use SQLserver agent and operator it fails.
If this is the case, ensure sp_configure 'agent...
July 19, 2011 at 4:35 pm
hi
Answer to your question, yes!
I have seen replication skip command on a default profile where it's not mean to skip, however this is not due to SQL's fault, it's always...
July 19, 2011 at 4:29 pm
Viewing 7 posts - 76 through 82 (of 82 total)