Viewing 15 posts - 946 through 960 (of 1,157 total)
I use the Apex one fairly regularly. Works quite well most of the time, but historically, some of older versions were a little buggy. Seems to have stablised...
May 26, 2011 at 5:07 pm
^^^^^^^^^
Old Skool 😀
SELECT *
FROM INFORMATION_SCHEMA.VIEW_COLUMN_USAGE
WHERE COLUMN_NAME = ''
admittedly, it doesnt cover sp's
These may be useful
SELECT *
FROM INFORMATION_SCHEMA.ROUTINE_COLUMNS
SELECT *
FROM INFORMATION_SCHEMA.PARAMETERS
May 26, 2011 at 5:05 pm
I'm on call right now!
Nothing can replace experience and documentation of the environment you are working in. Its also essential to have an escalation protocol and list of "points...
May 26, 2011 at 4:58 pm
Several factors here. Is the subscriber a complete, replicated copy? Is this merge replication with changes occuring on both sides? Either way the following generally applies.
Obviously you...
May 26, 2011 at 4:55 pm
Its also a good idea to disable the login at the source (if possible) to prevent accidental access there
May 26, 2011 at 4:49 pm
george sibbald (5/26/2011)
if you added the user in the primary database and have restored a log backup post that action on the secondary, it will be there.
What he said. ...
May 26, 2011 at 4:48 pm
Run this on the Publisher and Subscriber and post the output.
DBCC SQLPERF(logspace)
Where are you seeing the error message? SQL Error log? Windows Event log?
May 26, 2011 at 4:33 pm
FYI, I would generate the scripts for the publication using management studio to get a "template" proc execution with you local publication settings. Use one of these as the...
May 26, 2011 at 7:21 am
suri.yalamanchili (5/24/2011)
I am using transactional replication. When I add articles and then click on generate snapshot now, it adds the new articles to the subscriber. The problem is it...
May 26, 2011 at 7:19 am
I suggest you havent read the full post. Logfiles dont contain objects.
The DBCC command will empty the log and the ALTER statement remove it.
May 26, 2011 at 5:21 am
Are you looking at the publisher or subscriber? Either can result in this error.
A subscriber db can have its log file in simple mode.
May 26, 2011 at 5:19 am
platzkarl (5/26/2011)
May 26, 2011 at 5:16 am
if you use the soon to be deprecated sp_repladdcolumn proc it will add the column and propogate this to all subscribers without the need to reinitialise or re-snapshot the table.
I...
May 26, 2011 at 5:15 am
yes, it will require a new snapshot (new articles only) but post initialisation publication changes get propogated as normal.
May 26, 2011 at 3:26 am
We have upgraded 50% of our production environment and expect to be 100% upgraded within a few months.
We're running R2 CU7 without issues. The only critical thing is to...
May 25, 2011 at 9:25 am
Viewing 15 posts - 946 through 960 (of 1,157 total)