Forum Replies Created
Viewing 15 posts - 3,736 through 3,750 (of 7,168 total)
-
RE: Failed job incomplete error message
The messages logged by SQL Agent are limited, and formatting is removed making it difficult to read. Might I suggest piping the output of your job step to a file...
-
RE: How to exclude replication stored procedures from a script?
schleep (6/26/2012)
This will exclude all non-user objects. I assume they're probably not required anyway.Get-ChildItem | where {$_.IsSystemObject -eq $false}
That brings up a good point. I have replication enabled in my...
-
RE: BCP Export\Import question
Kwisatz78 (6/26/2012)
HiI am needing to export some data from a backup into our live DB due to some issues. Currently I am thinking the best thing would be...
-
RE: SSIS - File Watcher Task
It did not work out the way I had hoped:
-
RE: how to create a publisher for snapshot replication using C# and RMO namespace
Why setup, then tear down transactional replication just to get a snapshot made? Have you looked into Snapshot Replication?
Regarding your request about RMO, you're asking for help on an uncommon...
-
RE: How to exclude replication stored procedures from a script?
Roust_m (6/26/2012)
opc.three (6/25/2012)
Try it with -Name, like this:Get-ChildItem -Name -Exclude dbo.sp_MS*This one worked, because it has "dbo."
Thanks!
True, but I found it does not work in the rest of the pipeline....
-
RE: How to exclude replication stored procedures from a script?
Roust_m (6/26/2012)
opc.three (6/25/2012)
opc.three (6/25/2012)
Try it with -Name, like this:Get-ChildItem -Name -Exclude dbo.sp_MS*😛 and then I remembered the initial intent...
Try this one:
Get-ChildItem | Where-Object {$_.name -NotLike "sp_MS"} | %{$_.Script($so) + "... -
RE: How to exclude replication stored procedures from a script?
opc.three (6/25/2012)
Try it with -Name, like this:Get-ChildItem -Name -Exclude dbo.sp_MS*😛 and then I remembered the initial intent...
Try this one:
Get-ChildItem | Where-Object {$_.name -NotLike "sp_MS"} | %{$_.Script($so) + " GO "... -
RE: How to exclude replication stored procedures from a script?
Try it with -Name, like this:
Get-ChildItem -Name -Exclude dbo.sp_MS* -
RE: publisher should not try to transfer data to subscriber that is not connected
i ve tried merge replication..
i want to know how the log file will be
when subscriber is not connected, Publisher should not try to send the data to the subscriber
how to...
-
RE: How to determine when column stats are updated?
I thought I was in a SQL 2008 Forum when I posted, so I tested on SQL 2008. I noticed I was in a SQL 2005 Forum after I posted....
-
RE: How to determine when column stats are updated?
Mindy Hreczuck (6/25/2012)
I have index statistics taken care of by a scripted maintenance plan but I'm going to be setting up a separate plan to take care of updating the... -
RE: can you use SQL Server 2012 Management Studio Express for an sql2008 database?
Yes, you connect to a SQL Server 2008 instance using SQL Server Management Studio 2012.
Have you tried it in your environment and it did not work? Or are you just...
-
RE: How to exclude replication stored procedures from a script?
dir is an alias for Get-ChildItem
Get-Alias dirOne of the options for Get-ChildItem is -Exclude which accepts a pattern.
help Get-ChildItem -DetailedIf you devise the repl proc pattern and provide that...
Viewing 15 posts - 3,736 through 3,750 (of 7,168 total)