This was very nice. A point to keep in mind though is the "dreaded" TEXT columns, these "animals" are hard to handle at least with the current scripting capabilities. and...

Ahhhh..... remanesing ... My first job was a re-write of one AccessDB created by "smart" Doc...

Answer: Because pigs can fly!

usman.tanveer (1/16/2009)

---

Thanks for the reply, Yes i have Personal Edition.

But what is this limitation all about? and why is this error occuring? and what will be happening (with sql server,...

sunny Brook (1/16/2009)

---

Sorry for the incorrect answer above.

Yes, noeld is correct. It can be done to logshipping SQL 2005 DB to a SQL 2008 Server.

Connect to the SQL2005 instance...

That information is actually not correct.

You CAN do LogShipping from 2005 to 2008 (without STANDBY mode)

You are requiered to use SQL 2008 UI tools ... if You want...

Bryan Whitaker (1/16/2009)

---

I'm familiar with using sp_addmessage to generate user-defined error messages and triggering them with RAISERROR from my sp's.

Can a CHECK CONSTRAINT be created that, when triggered,...

Use Unc Path for the T: drive instead.

\\ServerName\ShareName\File.txt

How about?

IF OBJECT_ID('Store') IS NOT NULL

DROP TABLE Store

go

CREATE TABLE Store

(Id Int,

Metadata XML)

Go

Insert Into Store Values (1, '<store>

...

Good Luck

usman.tanveer (1/16/2009)

---

Hi,

I have sql server 2000 server. My log file is full of following error,

"This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded...

If it is not obvious you are posting SQL Server 2000 on a SQL Server 2005 forum ... The links and opinion above may or may not be valid for...

I have to admit that the SAN I have worked with in the past were managed by people really trained for it and they were TOP Vendors (HP, HITACHI).

Now that's FUNNY :D:D:D:D

For some reason the PO is not understanding...

You don't need the "DISTINCT" keyword on that query!