Viewing 15 posts - 8,236 through 8,250 (of 14,953 total)
Jason-476226 (8/1/2009)
October 2, 2009 at 1:34 pm
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...
October 2, 2009 at 1:12 pm
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...
October 2, 2009 at 1:10 pm
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...
October 2, 2009 at 1:08 pm
Michael Valentine Jones (10/2/2009)
October 2, 2009 at 1:06 pm
Jeff Moden (10/2/2009)
... would fix a part of that but understood on the no return even if it...
October 2, 2009 at 12:57 pm
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...
October 2, 2009 at 10:56 am
Please don't double-post.
October 2, 2009 at 9:11 am
SQL 2005/2008 use SQL Server Management Studio instead of Enterprise Manager.
October 2, 2009 at 9:10 am
I would need to see your actual code to tell you what's going on.
October 2, 2009 at 9:09 am
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...
October 2, 2009 at 9:08 am
One index with all the columns in the query is best.
October 2, 2009 at 9:00 am
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...
October 2, 2009 at 8:56 am
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...
October 2, 2009 at 7:59 am
Viewing 15 posts - 8,236 through 8,250 (of 14,953 total)