Viewing 15 posts - 481 through 495 (of 1,158 total)
steve smith-401573 (3/21/2012)
MysteryJimbo (3/21/2012)
Are you accessing the server through a dns alias?
Make a connection to the server...
March 21, 2012 at 1:13 pm
How automatic is automatic?
We have a tool which applies releases, but I get to press the button after QA and staging (pre-prod) testing, manager authorisation.
March 21, 2012 at 11:15 am
Its also possible to duplicate this error if the server has previously been renamed.
Are you accessing the server through a dns alias?
Make a connection to the server and SELECT @@SERVERNAME...
March 21, 2012 at 11:01 am
Is this server its own distributor? That confirms that the distributor no longer knows about any subscriptions.
Run these statements on the published database. I'd expect nothing from the...
March 21, 2012 at 10:55 am
No set rules. There are hidden performance problems in poorly written queries around partitioned tables so I tend to look at them as more of a data management tool.
If...
March 21, 2012 at 9:41 am
The way SSMS works in many situations is to create a temporary table and import the data, recreate the actual table and import the data back in.
For precise control you...
March 21, 2012 at 8:32 am
You do need to rollback any currently running queries.
The KILLED/ROLLBACK state is an "it depends" moment. It could be like that for a while and succeed or it might...
March 20, 2012 at 3:39 pm
Jonathan Marshall (3/20/2012)
When running sp_droppublication
have you removed all of the subscriptions first?
Try these to dynamically generate drops at the article level. Generate all of the statements first or...
March 20, 2012 at 1:38 pm
Mirroring or clustering would be your best option for minimal downtime. Both should allow for less than 5 minutes of downtime provided you're prepared.
Mirroring has an administrative overhead of...
March 20, 2012 at 12:38 pm
vrayanapati (3/20/2012)
.....[font="Verdana"]
Only members of the sysadmin fixed server role or
Db_owner fixed database role can perform this operation. Contact an administrator with sufficient
Permissions to perform this operation... [/font]
....
Does this...
March 20, 2012 at 11:07 am
Its not possible to answer this question with the information give?
What thought have you put into it and do you have any idea what you need to achieve to provide...
March 20, 2012 at 11:05 am
Depending on how you did it, its quite possible there is another process blocking the drop subscription. Have you checked for a blocking spid?
Otherwise you are completely able to...
March 20, 2012 at 11:02 am
The same applies to articles, the source table name can differ to the destination.
March 20, 2012 at 10:57 am
Ryan007 (3/20/2012)
March 20, 2012 at 9:53 am
This setting is for the buffer pool only. It does not include all memory usage for additional activities such as CLR and backup buffers. These can add up...
March 20, 2012 at 9:42 am
Viewing 15 posts - 481 through 495 (of 1,158 total)