Viewing 15 posts - 1,441 through 1,455 (of 1,790 total)
Sure. You will have to run an update against the sysjobschedule table (I think that is the table name - at Oracle training and I don't have SQL Server in...
September 11, 2003 at 5:41 pm
Sorry - Brain dead. You are correct. The error I generated was from an insert. Phillcart is right on with his response. Curious to see the example you provide and...
September 10, 2003 at 6:21 pm
Interesting that you should start this discussion as I am working to eliminate this in my environments as I type. The big complaint is that they will not be able...
September 10, 2003 at 6:15 pm
Don't believe you can do that. However, if the upgrade is failing and time is somewhat important (and it is for me) I would burn a call to Microsoft. The...
September 10, 2003 at 6:08 pm
It still sounds like a security issue to the path. You say the account is a local admin on the DB server but does it have access to the file...
September 10, 2003 at 4:57 pm
You should be getting the following error:
"Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated."
Are you running your statement from...
September 10, 2003 at 4:54 pm
To change the sort order in 7.0 you have to reinstall and I don't believe that will update the current databases. Research this because I am not 100% on this....
September 10, 2003 at 4:44 pm
36 with 4 children (12, 5, 4, 2) and a beautiful wife! Very blessed!
David
September 8, 2003 at 9:37 am
Your plan sounds very reasonable. You could have SQL Server backup directly to the Network share to avoid the Tivoli piece of copying files but if the Tivoli solution is...
August 11, 2003 at 11:09 am
I would pump the file into a table that matches the format using Bulk Insert. The following step should be a T-SQL Task which would contain three insert statements like;
insert...
August 1, 2003 at 2:18 pm
Odd. Can you run through the Server Registration wizard again? That would be the only thing I could suggest trying.
Still, very odd.
David
August 1, 2003 at 2:09 pm
Charles,
What are you trying to accomplish? Is this for a load test scenario? Curious. Thanks.
David
July 30, 2003 at 10:57 am
Microsoft has a compatibility site. Don't know if this will help in this case but worth a look.
http://www.microsoft.com/whdc/hcl/search.mspx
David
July 10, 2003 at 6:55 am
In the index in SQL Server Books On Line type the following "DTS packages, logs" and that should get you started.
Hope this helps.
David
July 8, 2003 at 7:20 am
The only way that I can think of doing that is by setting a global variable WITHIN THE STEP with the status. That would mean that you would have to...
July 8, 2003 at 7:16 am
Viewing 15 posts - 1,441 through 1,455 (of 1,790 total)