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...
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...
October 22, 2009 at 12:52 pm
Only thing I can think about is permission. Does the SQL Server service user have sufficient rights?
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..:-)
October 22, 2009 at 12:44 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...
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.
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.
October 20, 2009 at 1:26 pm
SSMS SQL Server Management studio. Or you can do it using T-SQL. ALTER LOGIN
October 20, 2009 at 1:04 pm
Unfortunately not. All external emails and its authentications are blocked at the firewall. 🙁
October 20, 2009 at 1:02 pm
Remove the Enforce password policy. You can use the GUI to do that.
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...
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...
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.
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...
October 20, 2009 at 11:49 am
Viewing 15 posts - 1,546 through 1,560 (of 2,840 total)