Jason-476226 (8/1/2009)

---

Has anyone solved this? I've got a simple execute SQL task (i.e. "exec spname") with no parmaters. The package runs fine in BIDS, but fails when run by the...

I'd probably have to use XQuery to turn it into a relational format, then use For XML to turn it into the new format. There may be a more...

Just keep in mind that, if you have anything you DON'T want to transfer, the script all objects method will need some editing after the fact. So either choose...

Are you trying to connect an application you're building, or are you trying to connect Management Studio?

I'd say the best place to start for either one would be to have...

Michael Valentine Jones (10/2/2009)

---

I think the way Microsoft has positioned SQL Server in the market place has a lot to do with this. The idea is to make a...

Jeff Moden (10/2/2009)

---

SELECT * FROM Table1 WHERE ID = @ID AND (@a> 0 OR @b-2>0)

... would fix a part of that but understood on the no return even if it...

I'd go with a separate table that stores the active domain value. That would also allow you to track the history of it if you wanted to include a...

That makes sense then.

Please don't double-post.

SQL 2005/2008 use SQL Server Management Studio instead of Enterprise Manager.

I would need to see your actual code to tell you what's going on.

I just tried this:

ID int identity primary key,

Col1 char(1));

insert into #T (Col1)

select 'a' union all

select 'b';

set @RowCount = @@rowcount;

select @RowCount;

delete from #T

where Col1 = 'b';

set @RowCount = @@rowcount;

select @rowcount;

select *

from...

One index with all the columns in the query is best.

I think what I'd do is create a separate database, with the collation you want, and import objects and data into it through SSIS. That way, you can test...

An interview question about the naming convention for their servers????

My immediate inclination would be to ask if they were joking. If not, my second inclination would be to tell...