No. Not without upgrading to SQL Server 2005.

Mansoor (5/8/2009)

---

Dear All,

Thanks for giving response.

I am sure that i m using SQL SERVER 2005, and i tryed to executed the scripts also in SQL SERVER 2005.

Ref: You can...

select [name], is_read_committed_snapshot_on,

snapshot_isolation_state, snapshot_isolation_state_desc

from sys.databases;

Jack Corbett (4/15/2009)

---

I think it is unlikely that the shutdown was caused by SQL Server and then SQL Server restarted without issues. Did you check the SQL Server error...

Thanks Rudy

I am thankful to all you for your valueable suggestions.

The original code that I posted is just a simplied sample.

The actual code could be some thing like this:

declare @query nvarchar(4000)

select @query = 'SELECT ColumnName FROM tbl_TableName WHERE ' +...

Is this enough to take care of HEX...

Ping with server name.

See whether it returns same IP address.

if try to connect database using ip adress of that server it wont get connected but if i put the name of the server i.e abcd it gets connected but...

Run ALTER INDEX command with SET (ALLOW_PAGE_LOCK = ON)

It is recommended to run same version on...

I think you are confusing the SQL Server 2005 UI...

The advantage of SQL Express is scaleability.

Later you can upgrade it easily to standard/enterprise edition and take advantage of features like Replication, Mirroring, Log Shipping, Clustering, Database Partioning, SSIS, SSRS,...

Query...