george sibbald (5/14/2010)

---

What I take from this is if all your databases have the same owner,and a requirement for database chaining comes up, enable it at the database level, not...

George,

I can see how that might be an issue - if that is option is enabled. However, if you have enabled that option - then you obviously need to...

mbrey (5/14/2010)

---

I tend to agree with you. The problem is that yes, our data source only has a 32 bit driver and linked servers is the only way to connect...

mbrey (5/14/2010)

---

We are in the middle of creating a datawarehouse for a BI project. We are using linked servers and openquery to gather data from the data sources. Our datawarehouse...

george sibbald (5/14/2010)

---

Some third party apps require a particular ID be the dbo, so watch out for that.

Having the db owned by an ID that restored it is not in...

Just for clarity sake - SSRS also has a mode where you can develop reports that are called by your application and run on the client system. This mode...

You really should not be shrinking your database at all - because, as you are aware - it just grows again. The additional growth is expensive and will cause...

lmu92 (5/12/2010)

---

I second Brandie and Elliot regarding the sandbox db.

Once that person "designed" a query he/she wants to run in production, that person should send the query to one of...

I know this is for 2000 - but schema qualifying all objects is a recommended practice on SQL Server 2005/2008. There is an issue with not schema qualifying the...

If you are just looking for a way to be safe, and not actually trying...

I have seen this in both 2005/2008 when you try and deploy a new report over an existing report. If the report has a different signature (GUID - I...

No need to even loop through all objects in the database. You can grant view definition to all objects in a schema in a single command:

GRANT VIEW DEFINITION ON...

Okay, each login to SQL Server has to be defined. Windows logins can be added individually or through group membership. When you run SSIS packages from SQL Server...

Jeff Moden (5/9/2010)

---

Keeps the locking localized to just a...

I think you're over thinking this a bit - if I am understanding the relationship correctly. Since the ID's in both tables match, you really don't need to track...