Brett Favre (10/5/2009)

---

Update:

The syntax is compatible. Other organizations have successfully used this same view in the vendor DB in a sql 2005 environment in 2000 compatibility mode.

Last night we rebuilt...

In case you want to change it programmatically, Can you use dynamic sql, something like this?

Declare @server as nvarchar(50)

Declare @db as nvarchar(50)

Declare @schema as nvarchar(20)

Declare @select as nvarchar(max)

set @server =...

john.knight-557608 (10/3/2009)

---

PP-564103 (8/31/2009)

---

Yes you can have...

These will compile fine if the entire table does not exist. They will not compile if the table exists but the column you're referencing does not. It will...

Thanks Jonathan.

Yeah it looks like I am not going to make it but I made some progress with that. I created a clr stored procedure which configures an assembly(...

No shortcuts 😛

Guessing by your lines, I think you know the basics of sqlserver otherwise I would have directed to some books to read as a starting material. If...

I think batch seperator is what is causing the problem and the USE statement, try this,

DECLARE @ChangeDatabase nvarchar(250)

Declare @database nvarchar(100)

SET @database = 'SQLSERVERCENTRAL'

SET @ChangeDatabase =...

Roust_m (10/1/2009)

---

bitbucket-25253 (10/1/2009)

---

Do not know why you would want to create an SP and not know if it would function, but yes it can be done for example:

CREATE PROCEDURE Dbo.Garbage

AS

SELECT...

I thought this is similar to the below requirement.

http://www.sqlservercentral.com/Forums/Topic794441-338-1.aspx

See if it helps and if not you can look at the format in which they have given the sample data...

Sorry if I am underestimating your requirement, (it was not clear though) but i think 'CASE' statement should be useful,

look at the syntax and usage here.

http://msdn.microsoft.com/en-us/library/ms181765.aspx

If this does not...

AS per BOL,

order_by_expression

Specifies a column on which to sort. A sort column can be specified as a name or column alias, or a nonnegative integer representing the position of...

You would typically use linked servers to access databases across 'servers'

The script in need I...

I am sure there are lot of other elegant ways to do this and people would suggest. But see if this helps. (BTW please give the test data like this)....

How did you link the database?

You need to script the entire database?

(the databases are updated to the lastest...

dubem1-878067 (9/23/2009)

---

Ok, here is my two queries. My app call the first one, and if it returns a value greater then 1 my app call the second one.

Then...