Viewing 15 posts - 91 through 105 (of 110 total)
Possible problem with the version of odbc drivers or sql client tools on the laptop. Did you create the dts package on the laptop?? My gues is the package was...
March 9, 2005 at 10:28 pm
I suppose there may be different definitions but the one I would use is as follows:
An orphaned user is a user that is defined in a database, that is an...
July 20, 2004 at 7:41 pm
Hi, If you hav backed up MSDB prior then all DTS packages will exist after restore as this is where they are normally stored. A possibility is that you...
March 30, 2004 at 10:50 pm
Another simple way is scheduling it via a job and maint plan specifying destination of backup as UNC path
February 24, 2004 at 11:57 pm
This error can be caused bu many things, I am currently having the same problem where SQL Server crashes or server itself dies after 1 or more of these errors....
February 24, 2004 at 11:55 pm
Not totally clear what your after but EM DTS tool allows you to design a dts package which it appears you have already done. There is also an option...
February 24, 2004 at 11:39 pm
A quick test would be to restore to a new database using a backup of msdb, this then does not impact on current msdb. Perform your dbcc check on...
February 24, 2004 at 11:27 pm
Depends on what you really want to do as far as restoreability of them. Two methods are: 1. Backup msdb regularly, this allows restore of DTS plus other...
February 24, 2004 at 1:59 am
Many posibilities, but here are a few to try. Are both same version of sql server and EM? If you are using named instances in sql2000 then mdac 7...
February 24, 2004 at 1:45 am
Agreed , the possible cause of these may be from conversion of a V6.5 sql server environment to V7. The conversion process retains the users aliased to dbo under...
February 19, 2004 at 10:38 pm
you can also use the page option under notification properties for the job. This allows setting an email address as the pager address and this will allow you to...
February 19, 2004 at 10:32 pm
Try this, I think this answers the second part of your question. SELECT 'The current user is: '+ convert(char(30), CURRENT_USER)
February 17, 2004 at 11:22 pm
try this KB article http://support.microsoft.com/?kbid=834124
February 17, 2004 at 10:51 pm
Oh and another thought because I have been getting this problem occur randomly 'null user' is that I need to create an alias via the SQL network utility. This...
February 16, 2004 at 6:26 pm
Try this to allow winxp to win2k. From DOS cmd enter net use \\destinationserver\ipc$ password /user:destinationserver\ntaccount on destination server. Where destinationserver is the server hosting sql server and...
February 16, 2004 at 12:25 am
Viewing 15 posts - 91 through 105 (of 110 total)