You said you could not use a stored procedure, how about an inline table valued function? Then you could pass in a value to a variable and use like...

acfe.casa (7/29/2010)

---

SQL Server 2008 stores the vertex coordinates using a double precision IEEE format with 8 bytes (64 bits). That’s correct and similar as other spatial databases vendors do (Oracle,...

Works for me also.

You'll get much better answers if you read and follow the instructions in the first article I reference below in my signature block regarding asking for help. In addition...

Jeff Moden (8/18/2010)

---

I just got done with a long run of interviews for a Sr. Systems DBA and an SQL Server T-SQL Developer. There were about 8 candidates for...

Mohit K. Gupta (8/18/2010)

---

Rohit Chitre-274613 (8/18/2010)

---

I am trying to configure mirroring using script.Everything went fine until I tried to configure the partner on the Principle using following command

Alter database AdventureWorks...

How did you setup the database mirroring endpoints? can you postthe SQL code you used?

Evenings would be better, I can't access non-work related sites from work. A weekend draft would be better, imo, as it would make it easier to coordinate across time...

So, when, where, how is all this going to start?

IIRC, RC versions have an expiration date. Since SQL Server 2008 has been out for about 2 years, what you probably need to do is either install the Express...

Born and raised Colorado Native and Bronco fan.

Wish I could be there to watch the Broncos play the 49er's in England, win or lose it would be a trip!

I'll have to checkout the site again. Haven't been there in a while, hopefully I'll remember my password.

Two things. First, would you please post the SQL for your restore. Second, could you script the SQL to create your database and post that as well.

scott.pletcher (8/13/2010)

---

No, not in SQL Server.

SQL does not allow db names, table names, column names or keywords to...

Would help if you also provided the code you have already tried as well as expected results based on the sample data.

By the way, it looks like you should look...