Viewing 15 posts - 26,746 through 26,760 (of 39,922 total)
These can be hard to diagnose. The load on the server (either one) could be delaying the response to the connection attempt or the acknowledgement. In either case, you'd need...
October 19, 2008 at 11:39 am
When you execute the job, the SQL Agent service account (or a proxy that is configured) is who executes the batch file. That account needs to have rights to execute...
October 19, 2008 at 11:37 am
IF you don't have access to the SQL Server, there's no way to check if this is working. How are you planning on configuring alerts if you can't access the...
October 19, 2008 at 11:36 am
And don't shrink the log or database regularly. This is an emergency or rare utility for when something irregular happens.
You need to have regular full and LOG backups.
October 19, 2008 at 11:35 am
And you must convert this to a character string. Numbers do not allow multiple periods in them.
October 19, 2008 at 11:31 am
Even a solid network connection can get busy, and chances are it will happen when you have a backup running. It's not worth it. Get enough space for a local...
October 19, 2008 at 11:30 am
Clustering can be complicated and I'm not sure how many people would have encountered this. If this isn't critical data and you have backups, or can afford delays or losses,...
October 19, 2008 at 11:29 am
do you mean from the Windows DHCP log? What's the format? I'm guessng it's text. SSIS might be the best solution to automate this. Build a package that reads the...
October 19, 2008 at 11:27 am
That's it? I wear you two out on the Financial Crisis poll 🙂
October 19, 2008 at 9:33 am
One thing I like, and I'd urge those in the US to support is http://bailoutsleuth.com/ from Mark Cuban. Write your representatives, state and federal, and let them know they have...
October 19, 2008 at 9:32 am
Good information above.
When you fetch data from a cursor, you're grabbing a row. That returns a status code (OK, end of cursor, etc) and you check fetch_status to determine if...
October 18, 2008 at 5:04 pm
And be sure the SQL Server is running.
I'd also try some pings/odbcpings from the new client to see if it can connect to the server.
October 18, 2008 at 5:03 pm
check the error log and see what happened, but my guess is that you will have to drop the snapshot and recreate it.
October 18, 2008 at 5:02 pm
I was going to suggest what Perry mentioned.
Have you tried multiple Windows users?
October 18, 2008 at 5:01 pm
Thanks for the note.
Were both the Agent service account and SQL Server service account on the same domain?
October 18, 2008 at 4:59 pm
Viewing 15 posts - 26,746 through 26,760 (of 39,922 total)