Viewing 15 posts - 37,726 through 37,740 (of 39,501 total)
is the top 100 ordered? If so, then add a where clause that is > than the value in row 100.
Steve Jones
March 27, 2002 at 11:10 am
Glad I could help. Be interested to hear how it goes. You can post or email me (sjones@sqlservercentral.com)
Steve Jones
March 26, 2002 at 5:06 pm
March 26, 2002 at 5:05 pm
March 26, 2002 at 5:05 pm
The backup runs under the context of the server account. So only drives that are mapped for that account, not your acccount, will appear.
You should be able to use a...
March 26, 2002 at 3:31 pm
This is really hard to answer unless you can give us some idea of what type of cleansing you need to do.
I normally import things into SQL and then spend...
March 26, 2002 at 3:26 pm
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
Viewing 15 posts - 37,726 through 37,740 (of 39,501 total)