Viewing 15 posts - 1,546 through 1,560 (of 2,840 total)
As soon as you mark an article for replication, all transactions for that article is flagged as for replication. So even if you do a transaction log back up, the...
-Roy
October 23, 2009 at 5:56 am
Not unless you can recover or repair the drive.... At least you have two week old back up..I have seen cases where they dont have a back up and their...
-Roy
October 22, 2009 at 12:52 pm
Only thing I can think about is permission. Does the SQL Server service user have sufficient rights?
-Roy
October 22, 2009 at 12:47 pm
Once you have done your basic research to see if that will work, you are free to come back and ask questions if you have any doubts..:-)
-Roy
October 22, 2009 at 12:44 pm
October 22, 2009 at 12:41 pm
Transactional replication is your answer here. Non update transactional replication. The publisher once it gets the change will send the changes to your subscriber. Depending on your DB activity and...
-Roy
October 22, 2009 at 6:58 am
I am glad you were able to figure out. The foreign key constraint errors question keeps popping up all the time here in SSC.
-Roy
October 22, 2009 at 6:44 am
Same with me here. I can only do things as an anonymous user. At least there is someone else also who has the same problem like me.
-Roy
October 20, 2009 at 1:26 pm
SSMS SQL Server Management studio. Or you can do it using T-SQL. ALTER LOGIN
-Roy
October 20, 2009 at 1:04 pm
Unfortunately not. All external emails and its authentications are blocked at the firewall. 🙁
-Roy
October 20, 2009 at 1:02 pm
Remove the Enforce password policy. You can use the GUI to do that.
-Roy
October 20, 2009 at 12:35 pm
Has everyone here started using ask.sqlservercentral.com ? I still cannot login since our works firewall will not allow yahoo authentication that is used for OpenID
Too bad the site does not...
-Roy
October 20, 2009 at 12:28 pm
If I were you, I would go with the advice gus and jack gave you. That is to have it in as part of the stored proc that updates the...
-Roy
October 20, 2009 at 12:22 pm
CREATE TRIGGER [dbo].[trupdatePassword] ON [dbo].[tbUserInfo]
FOR UPDATE
AS
IF NOT UPDATE(passwd)
RETURN
INSERT INTO Yourtable
that is the basic syntax.
-Roy
October 20, 2009 at 11:57 am
WayneS (10/20/2009)
bitbucket-25253 (10/20/2009)
WayneS
Just had a "developer" send me some code.
Wayne I submit that your problem is NOT with the developer but with either the hiring/current Manager who think that the...
-Roy
October 20, 2009 at 11:49 am
Viewing 15 posts - 1,546 through 1,560 (of 2,840 total)