Viewing 15 posts - 37,591 through 37,605 (of 39,456 total)
April 12, 2002 at 11:10 am
Backup and restore. This will not move logins, but you can move these by extracting them from master..syslogins and adding them to the new server.
A better idea is to install...
April 12, 2002 at 10:13 am
It is possible. I think you will find the consensus among most experienced DBAs is to backup to disk, then get these to tape.
If you experienced this crash, you would:
...
April 12, 2002 at 10:10 am
April 12, 2002 at 10:07 am
April 11, 2002 at 3:47 pm
You can use a data driven query (I believe ) to do this, but it's too complex in my opinion.
I usually do this with a tempload table that is strictly...
April 11, 2002 at 3:34 pm
Use a varbinary or image datatype and then store the document like you would an image using ADO.
Steve Jones
April 11, 2002 at 12:27 pm
Have to write some code. Could use isql/osql and pipe to a file, but even DTS doesn't handle this well. ADO is the best method.
Steve Jones
April 11, 2002 at 11:48 am
April 10, 2002 at 11:52 am
Can you give some more information about versions, sps, etc. How you are setup?
I use it and it works great.
Steve Jones
April 10, 2002 at 11:47 am
You can use SQL logins and everyone will have to log into SQL.
If you want integrated logins, then the Novell server will have to synch with the NT domain, or...
April 10, 2002 at 11:46 am
I'm not sure if this is the same error, but I used to get these on appends periodically. I deleted the file and it recreated it and it worked the...
April 10, 2002 at 11:26 am
I believe the total is 256 per select. So I thnk this is the max you can use.
Steve Jones
April 9, 2002 at 4:16 pm
Shouldn't, but that is interesting. I believe that sp_sqlagent_refresh_job is just getting the latest status of a job. At least that's what it looks like.
I have some jobs which have...
April 9, 2002 at 4:08 pm
hopefully you have some other pk that you can use. Match up on the dup field and pick the min or max of hte pk.
If you do not have this,...
April 9, 2002 at 4:04 pm
Viewing 15 posts - 37,591 through 37,605 (of 39,456 total)