Viewing 15 posts - 37,366 through 37,380 (of 39,720 total)
create procedure test
as
declare @err int, @lasterr int
select @err = 0
begin transaction
statement 1
select @lasterr = @@Error
if @lasterr <> 0
select @err = 1
statement 2
select @lasterr = @@Error
if @lasterr <> 0
...
July 17, 2002 at 10:47 am
Is the SQL Account a local administrator? A local user?
Steve Jones
July 17, 2002 at 10:44 am
You can do it this way, but I'd make a separate file for each backup. The maintenance plan will do this as well a number of scripts in the library...
July 16, 2002 at 5:26 pm
No easy way. I'd use DTS and export the data and import it back. Or write a SQL statemeent that generates it for you
select 'insert customers select ''' + customername...
July 16, 2002 at 5:23 pm
Same here. I thought a short article might stick in people's minds and hopefully they won't have to research it themselves.
Thanks
Steve Jones
July 16, 2002 at 10:25 am
There is no way to prevent them as Anatares mentioned.
Steve Jones
July 16, 2002 at 10:23 am
Have you checked disk space? Any errors when the job hangs? It could be the file has grown and slowed the job and some other backup (tape) is interfering?
Can you...
July 16, 2002 at 10:21 am
Check the event log or the sql server agent log.
Steve Jones
July 15, 2002 at 3:04 pm
Tried reboots, client and server. Nothing seemed to work except changing the account back.
Researching the account now.
Steve Jones
July 15, 2002 at 2:58 pm
I'm not sure what you mean. Can you explain what the "report" is?
Steve Jones
July 15, 2002 at 2:57 pm
We do something similar to Andy. We keep between 1 and 4 backups on disk depending on the server (disk space and file size).
Makes it easy and quick to restore.
Steve...
July 15, 2002 at 1:01 pm
When you restore from a backup, you do not restore the log. If you create a new database with a smaller log, you can restore into this.
Steve Jones
July 15, 2002 at 12:58 pm
The biggest problem in this query is the functions in the subquery. They mean you won't be able to get indexes used for these columns. I'd bet you are getting...
July 15, 2002 at 12:55 pm
When you uninstalled and reinstalled, did you do this at the console or terminal session?
A few articles:
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q297064&
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q281460&
Was this an upgraded 2000 server? Haven't used this in application mode. Perhaps install...
July 12, 2002 at 11:51 am
Most authors implement a worst practice to make things easier. A disservice to reads IMHO.
The SQL box will accept Windows Auth. Set up IIS for Basic and Windows auth, it...
July 12, 2002 at 10:34 am
Viewing 15 posts - 37,366 through 37,380 (of 39,720 total)