Viewing 15 posts - 5,041 through 5,055 (of 6,216 total)
Hotek gave a decent talk at PASS about using merge replication for disaster recovery. Basically if the publisher/master crashes, you can force the subscriber to push all changes from it...
February 2, 2002 at 6:09 pm
Agree with Steves recommendations, except I'd raise the bar far higher on RAM - given the cost these days, I'd recommend a min of 2g and buy a machine that...
February 2, 2002 at 6:03 pm
Latest thing I picked up at Pass was that in Yukon you'll be able to declare an object on the server and use it as a user defined data type....
February 2, 2002 at 5:59 pm
I would be surprised to find that it wont be supported, more likely a matter of figuring out what to call it. An obvious guess would be Excel.10. Should you...
February 2, 2002 at 5:57 pm
Good article! How does exec() work compared to sp_executesql? Lately I've been trying to develop the habit of dbo qualifying all my sql...not there yet! And as far as dynamic...
February 2, 2002 at 5:53 pm
We're just getting started, but just the changes in the development environment almost justify the move. We use VB6 and Interdev right now. VB is good but starting to get...
January 26, 2002 at 10:06 am
The getdate() function will return the current date and time.
Andy
January 26, 2002 at 10:02 am
I've had no problems with MDAC 2.6. Using ADO you can set both the connection timeout and/or the command timeout. Before you spend much time there you need to explore...
January 26, 2002 at 5:35 am
Its one of those things I want to like, just hasn't clicked yet. Seems I remember a good article in SQL Mag about it, will have to dig around for...
January 25, 2002 at 5:47 pm
I sometimes use the ones for deadlocks, thats about it though. Agree with Steve that they must add some overhead.
Andy
January 25, 2002 at 2:20 pm
Have spent no time with .Net - but I think you're wanting to create a text file each time a value is inserted? You can do this in a trigger...
January 25, 2002 at 12:44 pm
App roles are a solution looking for a problem I think. The key feature and/or bug is that once you activate the app role, any permissions the user would have...
January 25, 2002 at 12:40 pm
Dont remember seeing this behavior..but maybe just never ran into it! You could pause the service which of course stops everybody from everything. Maybe try DBO only for the db.
Andy
January 25, 2002 at 12:38 pm
I always just make a mirror of each table I want to audit, add a new pkey and a dateadded col that defaults to getdate(), remove all other constraints. Then...
January 25, 2002 at 5:08 am
Not sure if this is exactly what you're asking for - any DDL can be sent to SQL from ADO using the execute method.
Andy
January 25, 2002 at 5:05 am
Viewing 15 posts - 5,041 through 5,055 (of 6,216 total)