Viewing 15 posts - 211 through 225 (of 252 total)
Good advice. I'm wondering if there is a way to do this that will maintain the indexes? Maybe DTS?
spring, summer, fall now
dawn breaks on cold, white magic
Winter's chill...
June 17, 2003 at 10:22 pm
That website is extremely helpful. Thanks.
spring, summer, fall now
dawn breaks on cold, white magic
Winter's chill is nigh
June 6, 2003 at 10:27 am
Found the Problem! My SYSADMIN rights were bundled in a group on the sp3 server and listed separately based on my network logon on the sp2 server. When...
June 5, 2003 at 3:02 pm
I would be happy to try your solution, but I don't understand it. Guess I'm not advanced enough. Would you resubmit it in layman's terms.
"I hope you enjoy...
June 4, 2003 at 10:29 am
Here is an easier procedure I found in technet:
Step 5: How to Move DTS Packages
Step 5 is optional. If DTS packages are stored on the source server in the SQL...
June 3, 2003 at 5:36 pm
Thanks Darren. That query will list all of the tables that contain the column. The final step is to query the listed tables and limit the result to...
May 8, 2003 at 10:19 am
That was the problem. The proxy acct was not linked to the 2nd server. I do map my users to a single account. Once I set that...
April 11, 2003 at 2:57 pm
Thanks. The article is exactly what I needed.
"I hope you enjoy your retirement as much as I will."
April 3, 2003 at 10:27 am
Final solution to this from Micro$oft.
In the NT environment, when permitting developers without sysadmin rights to schedule DTS jobs, the only way to determine which files on the server the...
January 15, 2003 at 10:44 am
That did not work. The Microsoft Article says The Proxy Account must have read and write access to the temp folder of the Account the SQl Server Agent is...
January 8, 2003 at 11:28 am
I did this early on in the process. Drive access is the issue. Today I will use C:\WINNT\temp and see what happens.
"I hope you enjoy your retirement...
January 8, 2003 at 9:28 am
The startup is a domain account with local admin rights on the server.
BTW, I just gave the proxy acct local admin rights and ran the job successfully as my user....
January 7, 2003 at 5:12 pm
The problem was caused by several linked processes "stuck" in the system. I rebooted the server to clear them and the problem was solved.
"I hope you enjoy your retirement...
January 2, 2003 at 10:56 am
You folks are too helpful. I honestly had no clue.
"I hope you enjoy your retirement as much as I will."
December 10, 2002 at 12:39 pm
Viewing 15 posts - 211 through 225 (of 252 total)