Viewing 15 posts - 391 through 405 (of 1,365 total)
Excellent Alex.
Many thanks for sharing the same!!!!
MJ
July 31, 2009 at 7:13 pm
Try:
select * from sysobjects
where replinfo0
MJ
July 31, 2009 at 6:21 pm
Do it one by one for each file.
Manu
July 31, 2009 at 4:56 pm
Why don't you make use of dynamic sql and executing the sql statements in each database by using "USE".
MJ
July 31, 2009 at 4:51 pm
Tafarelo,
Can u please give me a brief where you went in the registry to do the change incase i run into this risk.
Manu
July 31, 2009 at 4:37 pm
All you need to do to change the package owner is set owner_sid and owner in msdb..sysdtspackages.
If you get all the package IDs into a table then you can join...
July 30, 2009 at 12:26 pm
Can you post the script that you created?
MJ
July 29, 2009 at 2:35 pm
Have you tried changing the category value for that database under sysdatabases to 0. It must be non-zero as you said you were getting errors related to "replication is enabled"...
July 29, 2009 at 2:03 pm
exec sp_MSforeachdb "select '?' As DatabaseName,name from ?.dbo.sysobjects where name in ('Tablename')"
MJ
July 24, 2009 at 9:27 pm
Moving a Cluster to a New SAN
http://russkaufmann.spaces.live.com/blog/cns!9628511B4C1D269C!303.entry
HTH!
MJ
July 24, 2009 at 8:57 pm
Use Performance Monitor Counter(User Connections) under General Statistics Peformance object.
MJ
July 24, 2009 at 8:45 pm
Take full backup of user and system databases.
One nice feature that you have probably become accustomed to is the ability to uninstall programs, hot fixes and service packs by using...
July 17, 2009 at 12:29 am
Under which account is your sql agent running right now?
MJ
July 16, 2009 at 11:23 pm
Viewing 15 posts - 391 through 405 (of 1,365 total)