Viewing 15 posts - 35,011 through 35,025 (of 39,723 total)
Have him open them and save as .dts files. (structured storage). Then open them back up with the new user.
OR reassign to sa and do the same thing.
April 8, 2004 at 5:24 pm
Sorry, are they a volume set or a striped set? In a volume set, I believe things are written one drive at a time until it is full. However, if...
April 8, 2004 at 5:23 pm
I'd check out Ken Henderson's book on Extended Stored Procedures.
or email him. He's done a few of them.
April 8, 2004 at 4:40 pm
How are they combined? Windows can do it either way.
April 8, 2004 at 4:37 pm
Never seen this. Is is SQL 2000, SP3a?
April 8, 2004 at 11:41 am
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
Viewing 15 posts - 35,011 through 35,025 (of 39,723 total)