Viewing 15 posts - 1,036 through 1,050 (of 1,157 total)
GSquared (3/21/2011)
What you're looking at is multi-step authentication. Wince, grit your teeth, and do an online search for "kerberos".
:-D:-D totally agree :-D:-D
March 21, 2011 at 2:52 pm
Merge replication wont solve your conflict issue for you but it will offer you a method of resolving them.
I'm interested in your peer to peer replication setup, as when this...
March 21, 2011 at 1:58 pm
FYI - I dont think its been previously mentioned, a mirrored database can be queried by creating a database snapshot.
March 17, 2011 at 7:24 am
GilaMonster (3/15/2011)
In clustering the two nodes should be identical. That's hardware, OS, drivers, etc. Clustering a physical box with a virtual is definitely not having two identical nodes.
The key here...
March 15, 2011 at 6:46 am
David Benoit (3/11/2011)
TheLazyWriter (3/11/2011)
March 14, 2011 at 1:01 am
David Benoit (3/11/2011)[hr
Correct me if I am wrong but I thought that this was ONLY true when immediate_sync was not set on and if it was it would generate a...
March 11, 2011 at 9:13 am
Altering a replicated tables structure DOES NOT require a full reinitialisation of all subscribers. Imagine doing this when a publication contained many gigabytes.
Ensure you do this in TSQL. ...
March 11, 2011 at 8:40 am
Is that still true if you restore with no recovery? I recently migrated from SQL 2000 and 2005 to 2008. I was able to log ship as long...
March 9, 2011 at 9:47 am
Notice you mentioned alternative methods. Just searching my scripts now. 😀
March 6, 2011 at 10:20 am
Hopefully, this will help. It gets the information from msdb on job schedules. You will need to edit it to your purposes.
IF OBJECT_ID('tempdb..#xp_results') IS NOT NULL
BEGIN
...
March 6, 2011 at 10:17 am
I've found it depends on the servers subsystems. On some server the benefit of using a table variable over the IO required to create a temporary table is quite...
March 6, 2011 at 10:10 am
The trigger would have to fire for every update on the table
It would contain an IF UPDATE(column1) BEGIN END. It's pretty lightweight so you wouldnt even notice it existed...
March 6, 2011 at 10:05 am
I would do it like this. I've done it in the past for DW slowly changing dimension generation and it performed quite well.
declare @table Table (name nvarchar (10), StartTime...
March 6, 2011 at 6:10 am
JeremyE (2/4/2011)
Faster/smaller backups, copies and restores. I suppose there is slight CPU...
March 5, 2011 at 11:15 am
I would set up logshipping the Microsoft way. Point it at your exisiting transaction logs when asked where the secondary server can copy them from. Once complete disable...
March 5, 2011 at 11:13 am
Viewing 15 posts - 1,036 through 1,050 (of 1,157 total)