Oh, this is interesting. Every time i start the services.... it starts then stops! Anyone experienced this before?

No. I've tried from my machine and a colleagues machine but still can't access the instance.

TCP/IP is enables also

Thanks.

I have and they are - Which is really weird!

The story goes... I allocated only 4 MB to this instance. Realising my mistake I...

Hi - Me again! After updating the memory, I am now being hit with the following error;

A network-related or instance-specific error occurred while establishing a connection to SQL Server....

Brillant! Thanks Lynn.

I have just connected through SQLCMD and updated the memory.

Thanks again all. Bacon saved!

Hi all - Thanks for your feedback.

I'm still struggling to rectify this issue.

I have multiple named instances on one server. $ out of the 5...

Thanks Lynn. I know that developer edition has the same features but it was installed in error and databases have already been created on the instance. I just wnted...

OK. I think that clears it up! Thanks.

Thanks for your response Jim!

Its defiantly not stored procedures as we don''t use them here. I can't work out why the transaction can't be viewed when being managed by...

Thats great. Thanks!

Thanks for your response Gail.

I guess my question is if I have a ROWLOCK on a table would I be able to run a reindex, or in other...

Thanks.

Thanks for your response Grant!!

Grant Fritchey (2/17/2014)

Also, using table locking hints is pretty severe in terms of blocking off access to the system. Are you sure you need that level...

Thanks Steve. The process is managed by a sql job so a powershell approach would be good. I'll have a gander at what you sent over! Thanks...

Thats simple enough! Thanks!