Hi

Think you need a third party software to do this,...

But if want to know by using some steps you can find the SQL server and its edition.

execute flowing.

select @@version...

I am also agreed with SQLRNNR and Mahesh:-)

Hi

File Indicants Log and data file, can you publish full script for more detail.;-)

Kim,

Can you enable and test with PCPIP. Why you are not using TCP IP?

Can you post full defination of Both table?

😉

Hi,

you can down load Express version free of coast as Ninja's_RGR'us said

and aditioonaly you can down load SSMS and If you don implementing any automation job AGENT is not needed.

Thanks

Hi

You can visit for interview Q&A:

http://mumbaisqldba.wordpress.com/2010/12/25/sql-server-dba-interview-questions/[/url]

🙂

Hi;

See my blog post.

http://mumbaisqldba.wordpress.com/2011/10/11/finding-out-how-much-memory-sql-server-is-utilizing/[/url]

hi gail;

I'm totaly confuse on this topics 'Physical or Logical' Please see the following link of MSDN:

http://msdn.microsoft.com/en-us/library/aa933131(v=sql.80).aspx

Can you...

Hi

olaf.dedig And niravbhat

You both should Install and check on stand by box and be sure youe application is working fine.

That solved

Fabrizio Faleni (10/10/2011)

---

Yes, sure Clustered indexes store data rows in a sorted way based on the key values, this is their main characteristic.

The consequence is that there can only be...

Hi;

Is this backup is OK?

From which version of SQL it was taken and Are sure you are storing on SQL 2k8 r2 sp1? is any other Version's Instase on Box?

Aaron Ingold (10/3/2007)

---

Boy, that's a question that could start forum wars... 😉

First thing you have to understand is the difference between a clustered and nonclustered index. Clustered indexes...

You may run this also

exec Sp_helplinkedserver

exec sp_helplinkedsrvlogin

Hi,

As per my knowledge Rebuild is Offline operation, use reconfigure instead of rebuild.