Viewing 15 posts - 7,156 through 7,170 (of 7,187 total)
Dan
That's the bit I'm not sure of. I'd say as a minimum you'd have to restart the LogReader Agent after adding the article. Please try it out - I'd be...
March 20, 2006 at 9:06 am
David
The only way you can connect to an instance of SQL Server on a cluster is by using that instance's IP Address or Network Name. If you try to connect...
March 20, 2006 at 8:30 am
Dan
sp_addarticle should be what you are looking for. The syntax looks daunting, but once you've figured it out, it should be fairly easy to generate a script to add an...
March 20, 2006 at 8:22 am
Tony
For constraints, if you know the name of the constraint:
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'constraint_name')...
For indexes:
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'index_name')...
John
March 20, 2006 at 6:42 am
In Enterprise Manager, right-click on the database and choose Properties. Click on the Options tab and you will see the Recovery Model - it will be Full, Bulk-Logged or Simple.
By...
March 20, 2006 at 3:40 am
Fintan
Back up your transaction log (assuming you are in Full Recovery mode). Then restore from your last full backup with no recovery. Restore all transaction log backups since the last...
March 20, 2006 at 3:12 am
It's a cluster server so I imagine it must be Advanced Server.
John
March 17, 2006 at 6:35 am
KR
If you're thinking of creating a trigger to roll back transactions, I should think you'd be better off not allowing those transactions to take place in the first place. And...
March 17, 2006 at 6:27 am
Happy to help.
March 16, 2006 at 9:57 am
Ian
It's certainly possible to move system database files, and in many instances it's also wise. For example, you may want your system databases to be on different disks from your...
March 16, 2006 at 9:46 am
Ian
Do you have a database called TPM250? If you do, detach it, move the log file, and then re-attach the database. Search for "attaching and detaching a database" in Books...
March 16, 2006 at 7:28 am
Scott
Also, if they're domain admins, they'll be able to see the SQL error logs (errorlog, errorlog.1 etc) as text files, without using Enterprise Manager.
John
March 16, 2006 at 7:05 am
KR
Do you have any filters defined in your publication that may cause certain rows not to be copied? I suppose this is unlikely to be the reason if one subscriber...
March 16, 2006 at 4:59 am
OK, I see from your thread on SQL-Server-Performance that your problem is that only the first row of the result set is displayed in your app. If you say what...
March 15, 2006 at 10:38 am
Carol
Check out this recent thread:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=263625
It seems to suggest that you're right.
John
March 15, 2006 at 10:23 am
Viewing 15 posts - 7,156 through 7,170 (of 7,187 total)