Viewing 15 posts - 3,991 through 4,005 (of 9,722 total)
Just a warning, Christina, if your data is set up the way I think it is, t.brown's solution will not immediately give you the answer you're looking for. You will...
September 11, 2012 at 8:16 am
As it is a side-by-side migration, what you need to do is start testing your data to make sure the collation is compatable and translatable before the migration starts.
You could...
September 11, 2012 at 8:13 am
Eugene Elutin (9/11/2012)
September 11, 2012 at 8:09 am
Did you create a Linked Server object for which to pass through credentials?
Are the credentials you are using for one server valid on another, or can those credentials at least...
September 11, 2012 at 8:07 am
Celko,
Cute joke.
Now do you actually have advice that is any different from that which was already offered?
September 11, 2012 at 7:49 am
The first thing I advise is taking a look at what you actually want mapped. It doesn't make sense to me.
You want app3 stuff mapped to app4?
The second thing I...
September 11, 2012 at 6:55 am
Stefan Krzywicki (9/11/2012)
September 11, 2012 at 6:50 am
It's nice to know that every once in a blue moon, I actually do have a clue and can answer some SQL Server questions here without making a total idiot...
September 11, 2012 at 5:18 am
The biggest issue with third party backup tools is that if the company suddenly goes out of business, or you lose your license, you could loose the ability to restore...
September 11, 2012 at 5:13 am
SSIS is your best friend for this type of thing. You can actually run a Data Flow task and do a Derived Column Transformation (use a REPLACE()) to get rid...
September 11, 2012 at 5:11 am
Ville Lucander (9/11/2012)
Sorry, I've never heard of "servername@dbname" being a connection string for the native SQL Server connections. So I'm still blank on this.==> this works anyway
Not saying it doesn't....
September 11, 2012 at 5:09 am
Eugene Elutin (9/11/2012)
Brandie Tarvin (9/11/2012)
They are both incorrect syntax. You will get an error if you try to use either of them..
Until
in case #1: Select * from table.col
...
September 11, 2012 at 5:03 am
It is not possible to do a file level partition at this time.
September 11, 2012 at 4:58 am
They are both incorrect syntax. You will get an error if you try to use either of them.
On the other hand, if you're talking about SELECT * FROM TABLE and...
September 11, 2012 at 4:55 am
Viewing 15 posts - 3,991 through 4,005 (of 9,722 total)