Viewing 15 posts - 37,951 through 37,965 (of 39,720 total)
March 26, 2002 at 3:00 pm
Removing the domain admins from the local admins will most likely cause more issues. ou'd be better off implementing some auditing to catch changing of the ownership of folders.
I'd...
March 26, 2002 at 2:52 pm
Sounds like you might have corrupted the master database in some way with the restore. Try a rebuild, see if it starts, then try your restore again.
Steve Jones
March 26, 2002 at 1:42 pm
March 26, 2002 at 11:55 am
March 26, 2002 at 9:14 am
5 Million isn't huge. Big, but not huge. Can you follow Antares suggestions and give us some more info? We then might be able to help.
Steve Jones
March 26, 2002 at 8:46 am
Interesting. Almost like a test connection before the other one sends the query. I'll try to take a look and see if this also happens in SQL.
Steve Jones
March 26, 2002 at 8:37 am
Had a similar problem. Solved it like this:
create table OrderItem
(PO_Number char(7)
, Part_Number char(2)
, PO_Line_Description char( 20)
, Line_Number int
)
go
insert OrderItem select '1010101', 'AA' , 'Capital Expenditure', 1
insert OrderItem select '100124', 'BB',...
March 26, 2002 at 8:33 am
I keep the security with the object scripts. It makes it simpler and less mistakes.
If the sproc isn't written, why do you need the permissions? You should apply permissions after...
March 26, 2002 at 8:15 am
Don't really use alerts here. I have messed iwth them in the past, but haven't seen the need. I have a number of checks in place with either jobs or...
March 26, 2002 at 8:13 am
Do you need to? There were some issues in v6.5 that caused triggers set on system tables to sometimes not fire. In v7, I think these either carried over or...
March 26, 2002 at 8:12 am
March 26, 2002 at 8:12 am
I tend to prefer backup/restore, but I've been doing this since v4.2 and attach wasn't an option then. I've done both and no great difference that I can see. The...
March 25, 2002 at 9:51 am
Karen,
I'd try to change the owner of the packages to be safe. DTS can be a little flaky at times. Try sp_reassign_dtspackageowner.
Steve Jones
March 25, 2002 at 9:47 am
Ming has a good explanation above. I also often find there is no good natural key, especially as business rules are constantly changing. Often I need a name for something...
March 25, 2002 at 9:38 am
Viewing 15 posts - 37,951 through 37,965 (of 39,720 total)