Viewing 15 posts - 37,096 through 37,110 (of 39,461 total)
Haven't seen it, but you might try posting this with another description in the T-SQL forum.
Steve Jones
July 18, 2002 at 5:54 pm
Pls don't cross post. All forums are checked by many people (using Active Threads at the top). We see all these posts.
Steve Jones
July 18, 2002 at 10:14 am
It's a gredy human issue. E Coli outbreaks in Colorado meat packers and USDA is somewhat either in bed or influenced by them.
Enron (need we say more), Worldcom, etc.
Greed in...
July 18, 2002 at 10:13 am
It really does look like a Data Mart issue, but that is more of a batch process, not real time.
I guess you could use replication to move relevant data (duplicated)...
July 18, 2002 at 10:06 am
That's a strange one. My guess is that it is rewriting the file for some reason before the backup.
Don't use INIT, try to ensure that each backup file has it's...
July 18, 2002 at 10:01 am
That's a tough one. IT's late and I don't have a good answer for you, but off the top of my head, I'd say aggregate on the client code. More...
July 17, 2002 at 10:07 pm
You will get an additional security check. However this is small overhead. The separate db should generate a separate thread for I/O, so it may make up for this.
Steve Jones
July 17, 2002 at 10:05 pm
Run profiler. Connect to your server and specify that you want the T-SQL events and the filter based on the database.
Steve Jones
July 17, 2002 at 10:04 pm
You'd need a self join and a subquery.
Join one looks for logins. This joins back to the same table for logouts, but with the same ID. Also, the logout time...
July 17, 2002 at 10:02 pm
There is not, but you can fake it (somewhat) with this:
http://www.sqlservercentral.com/columnists/sjones/tamestrings6.asp
Steve Jones
July 17, 2002 at 10:00 pm
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
Viewing 15 posts - 37,096 through 37,110 (of 39,461 total)