[

pp.pragnesh (5/7/2009)

---

Hi, Sylvia

I totally agree with you, many of the developers are using meaningless aliasing and that would be very tough to debug in future and waste of time. even...

I advise to use aliasses in all queries that involve more than one table, view, ...

This is really not a comparable issue for using leading commas, upper / lower case...

Please test this scenario (based on my previous post).

In my test it works on the second server.

edited this warning from BOL topic "ALTER MASTER KEY"

The REGENERATE option re-creates the database...

In your OP you state you are running SQL 2005.

Can you post the version info?

Select @@version

Can you also post the result of this ?

select MKP.*

, D.name as DbName

from sys.master_key_passwords...

psangeetha (5/6/2009)

---

Hi all,

We are facing this critical issue, I need some help from you experts. I ran the encryption and decryption procedures on prod db and created a new...

As MarkusB showed, dynamic sql is the solution if you want to do it using TSQL.

vbs or powershell using SQLSMO is an alternative.

FYI I use this script to add a...

It must be a bug.

I've tested in on SQL2008 SP1. (10.0.2531.0 (Intel X86) )

It gets even worse if you explicitly use the ID column in the filtered index definition.

(tested...

I wouldn't advise this kind of operation to a less optimal data type.

You lose all datatime functions and validations !!

Chose your level of detail !

declare @dt datetime

Select @dt =...

Adi Cohn (5/4/2009)

---

Timestamp has nothing to do with date. Timestamp is just a binary column...

great article.

Thank you for pointing the known issue and the ref to connect.

FreeHansje (4/30/2009)

---

Hi ALZDBA,

Have you ever benchmarked this MS_ForEachDB? I have, it's not good. And basically it's just another loop.

But as I mentioned before: it is not about a 'realistic' situation,...

also keep in mind when migrating an existing data system, you will have to deal with legacy short comings, data or data structures that doesn't make sense, but is those...

sam (4/29/2009)

---

Let me clarify - we have 8 processors and one instance right now. We will add an additional instance...

with ssis/dts you would have to check the packages connection data and queries. With each connection, you would also have to search for linked server queries,...

Same goes for .exe of...

we just use sqlagent to take scheduled backups.

Because dbs are implemented according to a prepared schedule, we just refresh the needed jobs and allerts (% log full for incremental log...