Jonnie Pettersson (3/19/2008)

---

Ian and PSA

I think you are missing the point here...or am I 🙂

If your database and temDB collation differ you have to either rebuild the masterDB or create...

If you just want to make the code work, then you can use the COLLATE function to get them in sync like so:

select * from TableA A

join TableB B on...

GermanDBA (12/18/2007)

---

Hi Homebrew,

Sorry, I think you misunderstood.... sarcasm is not an easy thing to display when writing on a message board.

I only meant that I made the mistake of not...

I get permission denied on 'sp_add_job'

Edit: My Bad ........ The user was also a member of TargetServersrole, which must have lower permissions than SQLAgentUserRole, so it was being...

I'm in the same position of wanting to convert from 80 to 90 ..... Good posts here !

In a production environment, it might be safer to back up the t-logs more frequently. We back ours up every 15 minutes.

How are your current backups running ?? Are your production backups in FULL recovery mode ? Are you taking transaction log backups regularly throughout the day ? ...

We have Idera's Compliance Manager, Diagnostic Manager & SQLSafe. Been happy with all 3. They seem to discount off "list price" so consider that when comparing.

I think all companies will...

We use Idera tools & like them. Also, the new version of WhatsUpGold can monitor all types of things on your server. We're using it quite extensively now. http://www.whatsupgold.com/

In the properties of the SQL Server Agent, what is the "Alert System" setting for Mail Session ? Enable Mail Profile should be checked. This was my problem a...

Yes, you can select the tables for all types of replication. As you set it up, you'll get a screen to check off the tables you want (tables are called...

Jim Russell (1/3/2008)

---

What is recommended in the case where multiple independent dbs owned by unrelated individuals/groups/organizations are sharing the same server, and providing local DBA functions themselves, and wish their...

http://technet.microsoft.com/en-us/library/ms142547.aspx

Consider 3rd party backup compression software such as idera's SQLSafe (we use it) or others by Redgate or Quest. Our 280 GB backup only takes 30 minutes and uses 45...

I don't think that's a bug. One job...