with cte as (

select ROW_NUMBER() over(partition by File_desc order by File_desc,rec_index desc) as Ranks ,* from MyTable

where is_modified = 0

)

select * from cte where ranks...

Moving databases servers to new domains is quite common. Usually part of consolidating servers , Virtualization or even a data centre move.

Common things that go wrong are Firewalls and ports...

http://msdn.microsoft.com/en-us/magazine/cc794278.aspx

In SQL Server 2008 you can now store data in hierarchies , the above link shows how.

Probably not in production. While there are secure ways of using xp_cmdshell. I can't/won't trust everybody to use it the way its meant to be. I could leave the company...

http://www.sqlserverclub.com/articles/how-to-deal-with-negative-spids-in-sql-server.aspx

Nice Read on the issue your trying to fix

Since your using sql 2008 , you could consider using Filestream

http://msdn.microsoft.com/en-us/library/bb933993.aspx

Please look up

http://msdn.microsoft.com/en-us/library/e970bs09.aspx

http://msdn.microsoft.com/en-us/library/bb934049.aspx

http://www.rsa.com/products/bsafe/whitepapers/DDES_WP_0702.pdf

http://en.wikipedia.org/wiki/HTTP_Secure

I repeat :- Please FULLY Qualify the object names

Create procedure Newdb_info

as

begin

create table Newdb_info.dbo.Teachers

( Emp_id int not null primary key, lastname varchar(20) not null ,firstname varchar(20)not null,

Assign_div nvarchar(20), sp_subject varchar(20),...

http://msdn.microsoft.com/en-us/library/ms186973.aspx

Assuming by key you mean primary and foreign keys the above link explains cascading.

You could also have a DMl trigger on the table which perform the same action but gives...

the fully qualified name should look like

databasename.schema.objectname

I doubt you have a database called dbo ? , replace dbo with the name of the database that you want the table...

Encryption can happen at many different levels.

E.g the database encryption can be enabled , TDE , disk level encryption , Firmware etc

the application can also encrypt data before sending...

you can create the table under the required database by fully qualifying it

e.g

create table adventureworks.dbo.abcde

( id int)

Since there is no time component maybe DATE is a better data type to use.

do you have the same index in both STG and test, if so are both enabled. Are the statistics up to date ?

Yes ,you can create a new table with a reference to the main table via a key column.