Viewing 15 posts - 3,436 through 3,450 (of 6,216 total)
Shouldnt need to set the length dynamically, the reason you set the length in the parameter object is so that you can't call the proc with a string larger than...
August 20, 2002 at 10:58 am
Only thing I can think of...wild guess...is that because you're copying the data in it's arrange differently? Shouldnt matter, but maybe?
Andy
August 20, 2002 at 10:51 am
Same # of processors? Memory? Might want to actually copy the mdf over and attach it, see if that affects the query plan.
Andy
August 20, 2002 at 10:03 am
August 20, 2002 at 8:59 am
Job should get created when you set up replication, runs this:
EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72
Andy
August 20, 2002 at 8:58 am
Shrink db or shrinkfile should do it. If the data is still there (not cleaned out!) then shrinking isnt going to help. If more likely the data has been posted...
August 20, 2002 at 6:47 am
August 19, 2002 at 5:04 pm
Fair point Bozo. Assuming some sort of diligence forcing someone to log in to the network does present a degree of security. If you use the keymaster concept, no one...
August 19, 2002 at 3:40 pm
I've got a couple articles that discuss sql logins and authentication, one went live today if you're interested. If you're using a sql login you have to manage getting the...
August 19, 2002 at 3:33 pm
Interesting. Could you post the code you're using so I can follow along?
Andy
August 19, 2002 at 2:18 pm
I think it varies. Both will work, assigning the recordset to the listbox is definitely easy though may not be powerful/flexible enough. Figure out how you want to handle the...
August 19, 2002 at 2:16 pm
Its ok to leave it there for the upgrade. Typically I like to do a clean install of everything - move the data (or rename the folder), format/reinstall all, then...
August 19, 2002 at 10:23 am
Mine shows 280k memory used with 7.5g allocated to sql.
Andy
August 19, 2002 at 9:31 am
August 19, 2002 at 4:52 am
One way...not the best, is to use a top 100 percent in the query, that will allow an order by.
Andy
August 18, 2002 at 8:44 pm
Viewing 15 posts - 3,436 through 3,450 (of 6,216 total)