Viewing 15 posts - 35,086 through 35,100 (of 39,793 total)
EM and QA do not connect via the ODBC Data Sources. In your Start | Programs | MS SQL Server, there is a Client Network Utility. You can set a...
April 8, 2004 at 11:03 am
I'd bet the on the 64bit issue. If you can't recompile, I'm not sure what you can do. Did you register this on the server adn in SQL?
April 8, 2004 at 10:40 am
I've had issues with moving this before. Instead, the easier solution, IMHO, is to let each person install the client tools on their workstation. Simple, fast, not that large, and...
April 8, 2004 at 10:35 am
The short way to do this is to open Excel, put down your tables, the columns and sizes, then estimated row counts. Add some percentage for indexes based on the...
April 7, 2004 at 11:46 am
I don't think you can do this on the maintenance plan, but you can do this with scripting. However, if the password changes, you need VERY good documentation about when...
April 7, 2004 at 11:42 am
I'd get MS to work with the SAN vendor on this. SQL is reporting a lower level OS error.
April 7, 2004 at 11:31 am
Can you load this DLL with VBScript/VB/C++ on this machine?
April 7, 2004 at 11:29 am
Correct, set a strong pwd since you never know when it will get switched.
April 6, 2004 at 4:19 pm
Can't see the image. What does it say? No issues for 2 installs here.
April 6, 2004 at 11:25 am
Cursors are less efficient, but sometimes are the best approach. As for why he chose cursors for this issue, I have an idea. Here's my approach:
http://www.sqlservercentral.com/columnists/sjones/batching.asp
April 6, 2004 at 10:52 am
Wow, I never noticed that. That's rather interesting and I have confirmed on multiple servers.
This "bug" does make the search for blank passwords much easier
April 6, 2004 at 10:41 am
Haven't seen this. I assume you just copied from a "good" server to fix it.
April 6, 2004 at 10:26 am
All the left joins will kill you because you have to hit EVERY single row in these tables, i.e. table scans.
If you can and there is not a lot of...
April 5, 2004 at 10:56 am
VAX !!?!?!!! Nightmares are returning ![]()
The suggestions above are great. I'd use DTS to script out the moves using one of the techniques above.
April 5, 2004 at 10:45 am
This runs on the server, so be sure the path/file is valid ON THE SERVER not your workstation.
April 5, 2004 at 10:36 am
Viewing 15 posts - 35,086 through 35,100 (of 39,793 total)