Hi

"Select * into" does not create the indexes from the source table. Ex:- Select * into table1 from table2 . table1 will be created with the same columns as...

Nisha (3/24/2008)

---

Yes, Chirag... that's precisely what I've been considering. I'm going to look into this option right away as its a lot more convenient. I have a couple of SPs...

Hi

Jeff - we are still in the development phase of the project. What i meant was that daily there are some modifications to the procedures. This does not mean...

Hi

Not in SSMS, but u can use sys.dm_tran_locks or system monitor.

Hi

RbarryYoung - RTM version does not have a option where we can generate alter script for all the procs that have been modified. Rightclick on the database\Tasks\ Generatescripts has pptions...

Hi

If u know how to use SSIS then you can import your data with that. You can make the name of the server,db configurable such that they are taken while...

Hi

Thanks everyone...:) .

My procedures get changed daily and i cant generate the alter script as iam using SQL 2005 RTM ( i cant change it).

Hi

What i really wanted to know was about execution plans.

I believe that dropping and recreating the stored procedures

will drop the existing executions plans of the stored procedures and create...

In a cluster of say 3 servers would'nt the resources of the 3 servers be used. So cant clustering be used for sacling out?

Well you cant have multiple columns with null values and a unique index on them. If this situation cant be changed you can take away the unique index and do...

Collation certainly is.

Hi

"45" , "70" will appear in all the records that are returned. The display part as how you want it will have to be done in the Front-End/UI level.

You...

Hi

Default collation is "SQL_Latin1_General_CP1_CI_AS". The date format would probably be the date format of the server.

Hi

Are you sure its the right "select" statement that you have put nolock on. Better check things once again.

Hi

In SQL Server configuration Manager\Network protocols

check whether Shared Memory protocol is enabled. This is enabled by default.