Viewing 15 posts - 1 through 15 (of 22 total)
Basic situation is this....
Database held on our server, detached, and then shipped to a customer. Customer attaches to their server. Doing a full reindex would be overkill, as would Update Statistics...
September 23, 2004 at 12:48 pm
I'm nowhere near a SQL box to try this, but you can't use it that way can you?
Syntactically, your CASE statement looks wrong. Shouldn't it be...
CASE WHEN MonthsOfStock < 10...
July 14, 2004 at 5:22 pm
I'm primarily a developer, but also have the DBA responsibilities.
A former colleague of mine (brought up on VB ) actually wrote SQL procedures like VB code. His SPs would...
July 9, 2004 at 1:59 pm
I assumed it was library related, so didn't look into the problem in depth.
November 25, 2003 at 2:38 am
I've never had a problem restoring SQL7 to 2000 - just make sure you do un Update Stats. I can't think of any good reason to stick to 7...
November 17, 2003 at 4:06 pm
I wrote some SQL-DMO code and found a similar situation.
SQLServer.Start... on 9x/ME I had to use .\instancename and on NT/2K/XP I had to use (local)\instancename
With SQLServer.Connect, (local)\instancename...
November 12, 2003 at 9:17 am
Hi,
As far as I know the filter applies to updates. deletes and inserts. One thing I would caution against is transactional rep with records that change qualification status....
November 4, 2003 at 9:04 am
Hmmm...I have to admit that I rarely use the SPs directly. However, if setting replication up through EM, then you cannot actually set pre/post scripts unless going to SQLServer...
October 3, 2003 at 5:13 am
Interesting suggestion , and one that I did not consider as a possibility. That is an exceptional suggestion!
As I'm replicating to non-SQLServer destinations, I'll have to manually insert steps...
October 1, 2003 at 6:38 am
All the latest, greatest.....I can work around it, but it seems a horrible kludge to me...
September 30, 2003 at 5:53 am
I'd be tempted to wait until Report Services comes out....although find details about it is hard at best. Other than the small snippet on MS website, I've found nothing...
September 16, 2003 at 6:02 am
Nice to see all your feedback.
Whilst I can see there may be a little extra overhead in returning results where there is one row, I would consider it...
September 16, 2003 at 5:47 am
I'm battling with this myself....
There are several issues that may arise, and to some extent 'it depends'. Personally, I'd lock them with select and SP execute permissions where it...
September 11, 2003 at 10:08 am
The way I'm reading this suggests you might want to secure the database to prevent access through other software (e.g. Access, any ODBC/OLEDB consumer) as well?
April 3, 2003 at 4:07 am
I setup a full test, and its failed.
The Distributor agent spewed out...
The row was not found at the Subscriber when applying the replicated command.
This suggests to me that a...
January 16, 2003 at 5:50 am
Viewing 15 posts - 1 through 15 (of 22 total)