Viewing 15 posts - 37,546 through 37,560 (of 39,901 total)
select top 50
will get the first 50. For me, I do an order by and pass in the 50th result for the where clause to get the next 50
select top...
July 17, 2002 at 12:56 pm
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
Viewing 15 posts - 37,546 through 37,560 (of 39,901 total)