Viewing 15 posts - 46 through 60 (of 73 total)
Are the 2 servers running the same version of SQL Server? Same service pack version? If you haven't already, try connecting to the package you created on the new server...
January 6, 2005 at 8:33 am
I think the above posts already explained how to move them to a new server. The method I have used is to open each package in the DTS designer in...
January 6, 2005 at 7:07 am
The function is returning the correct week number as 53 due to its use of a standard Sunday to Saturday week. In this case Jan 1 - Jan 3 2004 is...
January 5, 2005 at 1:31 pm
This thread might shed some more light on the issue:
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=110996#bm111144
September 3, 2004 at 8:18 am
I learned DTS by using the wizards initially as well.. I learned on SQL 7 and found the packages created using the wizards could be buggy, especially if you try...
May 14, 2004 at 6:48 am
I think the answer really depends on which direction you want to take in your career and what your goal is ... dba, developer, management? If you figure that out the...
May 14, 2004 at 6:38 am
If the job runs when you run it from local packages but not when scheduled it's probably a security issue.. check that the account the SQL agent runs under has...
May 7, 2004 at 6:34 am
That's interesting.. I didn't realize SQL Server would interpret things that way either..
If you try:
select * from employee where emp_id in (select authors.emp_id from authors)
you get the expected error.. (invalid column...
April 14, 2004 at 8:23 am
If the problem occurs when you schedule the job, then you are correct that it's probably due to the account that the SQL Agent runs under. You need to make sure...
April 14, 2004 at 7:51 am
That darn table owner will get you every time! Makes you wonder if it's outlived it's usefulness and should be eliminated in a future SQL server version?
April 8, 2004 at 6:32 am
We have a similar situation at our workplace that includes various scattered development teams throughout the organization. It has evolved this way because the individual business units wanted their own...
March 10, 2004 at 7:45 am
Just found another thread that might help us out:
http://qa.sqlservercentral.com/forums/shwmessage.aspx?messageid=99401
February 11, 2004 at 7:17 am
I'm interested in doing the same thing. Can you provide more details on how to set this up noeld? Thanks
February 11, 2004 at 7:01 am
Couldn't you change the password to the SQL database and make sure that the end user's don't get it? That way they won't be able to re-link the tables in a...
February 11, 2004 at 6:47 am
Have you tried checking to see if the constraint is actually missing? Just because the relationship isn't showing on the diagram doesn't always mean that the constraint has been removed. ...
February 6, 2004 at 7:42 am
Viewing 15 posts - 46 through 60 (of 73 total)