Viewing 15 posts - 37,891 through 37,905 (of 39,757 total)
you can run in simple more, which will truncate the log and essentially work without one, but some things will still be logged.
Steve Jones
April 12, 2002 at 11:10 am
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
Viewing 15 posts - 37,891 through 37,905 (of 39,757 total)