Viewing 15 posts - 2,236 through 2,250 (of 6,216 total)
As in new client tools? Attaching SQL 7 mdf to SQL2K works fine.
Andy
April 19, 2003 at 7:37 am
Interesting. Users and roles you can pull from sysusers. Then you can pull permissions from sysprotects. Harder part is the user may be either an NT login or an NT...
April 19, 2003 at 5:48 am
I suppose that might be it. Seems just as likely someone realized you might need a circular reference someday. Proc A calls Proc B. Proc B calls Proc A.
Then...
April 19, 2003 at 5:42 am
Running in compatability mode? If you script a proc out manually using QA, do you get the permissions (assuming you have the option checked in options in QA)?
Andy
April 18, 2003 at 7:25 pm
April 18, 2003 at 7:24 pm
I don't think so. SQL2K supports instead of triggers which do you let you reference text columns.
Andy
April 18, 2003 at 2:13 pm
Not really. Backup/restore is a valid reason, but remember that the trade off is there is no way to do a restore that will maintain transactional consistency across dbs.
Andy
April 18, 2003 at 1:35 pm
Thats a lot of transactions, I thinked you're getting nibbled into slowness. Log and dist readers are running continuously? Can you determine if its's the log reader falling behind or...
April 18, 2003 at 12:53 pm
One of many ways. I put together a checklist a while back, here:
http://www.sqlservercentral.com/columnists/awarren/20010425205439_1.asp
Andy
April 18, 2003 at 12:48 pm
Good question, sent a note to Brian K to check. Either not searching or index is not complete.
I think this is the one you're looking for:
Andy
April 18, 2003 at 10:17 am
Doesnt seem too horrible. Have you run Perfmon, see if you're bottlenecked?
Andy
April 18, 2003 at 10:09 am
We use Dell, haven't had any problems. Make sure you max out on the on chip cache, though it drives the price up.
Andy
April 18, 2003 at 10:07 am
If you use the ADO stream object, it handles all the chunking for you. Or plenty of examples on MSDN showing how to do the chunks manually (use the stream).
Andy
April 18, 2003 at 10:05 am
Rajesh,
Great post. Whether it will solve the problem or not remains to be seen, but adding the parameter as you noted will give you quite a boost. One query plan...
April 18, 2003 at 7:24 am
I appreciate the comments. So which part did you disagree with? As far as the rare power user, you went with sql login over NT?
Andy
April 17, 2003 at 4:46 pm
Viewing 15 posts - 2,236 through 2,250 (of 6,216 total)