Have a look at :

- "Moving Large Table to Different File Group" http://www.sqlservercentral.com/articles/Administration/64275/

- "Moving Tables and Indexes to Filegroups En Masse " http://www.sqlservercentral.com/articles/Files+and+Filegroups/65538/

- "Move a table between filegroups" http://www.sqlservercentral.com/scripts/Miscellaneous/31526/

Such operation will be noticeble for ongoing operations !

Can you afford downtime ?

If yes,

Can you move the whole db file, or do you want just to...

I think in this case it is worth the try.

Did you perform datapurity checks after you restored the db ?

http://support.microsoft.com/kb/923247

mikesigsworth (5/7/2009)

---

The @Value is coming from an ASP.NET business object. So should I be doing a search and replace for the _ character and using the ESCAPE thing? Seems like...

As shown in my previous reply a password encrypted master key can only be modified using the path of:

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'TestEncryption31' ; -- old...

So this proves you actually have NULL s in the designated date column !

Since you didn't order the first time, these rows will have been some where random in the...

Your variables content must match the predicates conventions.

In this case the conventions for Like.

Did you test this :

SET @Value = N'%My[_]Matching[_]Value%';

skjoldtc (5/7/2009)

---

I find the intellisense helpful in SS2008. But then, I haven't coded in T-SQL forever. I've gotten used to the intellisense in Visual Studio. Maybe that's helped me use...

[

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...