Viewing 15 posts - 301 through 315 (of 1,473 total)
I just re-read it and I think you're right. *I'm* working with 2 way synchronization between a mobile device/server so I think I jumped to that conclusion a bit...
January 17, 2010 at 12:29 pm
This is true. It will depend on your actual situation as to which is the more efficient method. It might be that copying a few extra rows that...
January 16, 2010 at 12:06 pm
If you don't need to know the time the record changed, you just need to know *that* it changed, a timestamp column will serve the same purpose without the trigger.
January 16, 2010 at 11:00 am
If you decide to go the Dynamic SQL Route (which is the easiest to implement from where you are now), make sure you keep injection in mind and code accordingly.
January 10, 2010 at 12:15 pm
Check out the COLLATE keyword in BOL.
Also, you don't have any criteria linking these tables, so you're performaing a multi server cross join. Sounds dangerous.
January 10, 2010 at 12:01 pm
Looks like a permissions issue to me. Is the directory/user/etc you used when the script executed successfully the same as the ones you used when it failed?
January 10, 2010 at 11:49 am
This script will allow you to add a user to all the stored procedures that you choose at once:
USE YourDatabase
DECLARE @Namevarchar(150),
@sqlvarchar(500)
DECLARE Perm_Cursor CURSOR FOR
SELECT [Name]
FROM sysobjects
WHERE xtype ='P' AND...
January 10, 2010 at 11:27 am
I'm curious as to how you pulled up a 17 month old post. Doing a little housecleaning on the subscriptions?
December 24, 2009 at 3:46 pm
Did you ever figure this one out George?
December 18, 2009 at 9:52 am
Thousands... but not more than 2500 depending on versions and OS. (See my post above)
December 17, 2009 at 3:22 pm
In my standard comment headers I tend to add a specific phrase (like 'Not yet Optimized' or 'Needs Rewrite') when I'm not happy with how something works, or the method...
December 16, 2009 at 12:21 pm
Lowell (12/16/2009)
Seth you could give LINQPad a try
Awesome idea. I actually have LinqPad already, but I never considered using it for that. I mostly used it to try...
December 16, 2009 at 12:04 pm
I didn't even mention that the Object Explorer Details tab has another bug with multiple monitors where it puts your right click menu on your primary screen regardless of which...
December 16, 2009 at 10:34 am
george sibbald (12/16/2009)
persevere, you'll get used to it!
:crying:
December 16, 2009 at 10:09 am
This is one of the old ways of doing things:
DECLARE @Errorint
--YourCode
SET @Error = @@ERROR
IF @Error = 0
BEGIN
--Success Code
END
ELSE
BEGIN
--Fail Code
END
It is very important that you set @Error after every single statement...
December 16, 2009 at 10:06 am
Viewing 15 posts - 301 through 315 (of 1,473 total)