Viewing 15 posts - 27,106 through 27,120 (of 39,768 total)
You don't need separate endpoints.
For the witness, it can be anything, including a desktop running Express. No reason not to run one somewhere.
September 10, 2008 at 6:37 pm
I'd agree with David that in the short term, on a project or two, the mega hours help you. I've worked overnight on SQL issues at times and I've learned...
September 10, 2008 at 3:42 pm
Hey, I have a lot of those skills!
Actually going to work on them now as a break from work. See what the horses have left. :w00t:
September 10, 2008 at 3:07 pm
This isn't T-SQL code. It's VB Script, so you can't use CAST. You could use a VBscript function, such as CDBL
http://msdn.microsoft.com/en-us/library/3ca8tfek(VS.85).aspx
September 10, 2008 at 10:42 am
SQL server has a listener that must respond to connection requests. The listener has to "take" a port from the OS when SQL server starts up. If you look in...
September 10, 2008 at 8:22 am
Strict timekeeping doesn't make sense unless you're being paid hourly. People will do the work or they won't, and that's what you track.
I usually let people know in an interview...
September 10, 2008 at 8:21 am
CAST works, but without seeing data or errors (or attempts) we have no way to help.
The error messages are usually obvious. You might not like what you're seeing, but they...
September 10, 2008 at 8:19 am
Quite a few slick car salesman here in the US have great soft skills. Not sure that's good.
September 10, 2008 at 7:15 am
Yikes, ouch, hey!:P
I'm slow, apparently in more ways than one, but it's corrected. No spell checked in that text box :w00t:
September 10, 2008 at 6:47 am
-E does trusted connections (as noted above).
-U/P is for SQL Authentication.
You can only choose one for your connection.
September 9, 2008 at 10:04 pm
Why not just use the SELECT UNIONS instead of the temp tables in the select? It appears that you're using static values in there.
September 9, 2008 at 10:00 pm
September 9, 2008 at 9:55 pm
what does the error log show for listeners?
what about netstat -a?
September 9, 2008 at 9:52 pm
Run a trace. There must be some shrink command being run.
September 9, 2008 at 9:45 pm
Is there a listener on #1? Check the error log, be sure that it's listening for remote connections. It could be set to only local connections.
September 9, 2008 at 9:40 pm
Viewing 15 posts - 27,106 through 27,120 (of 39,768 total)