Viewing 15 posts - 5,341 through 5,355 (of 7,168 total)
Upgrade Advisor is a good place to start. Are you doing an in-place upgrade? Will you have new servers? Make sure you have good backups whatever you do. Here is...
July 27, 2011 at 12:40 pm
Ninja's_RGR'us (7/27/2011)
opc.three (7/27/2011)
Ninja's_RGR'us (7/27/2011)
Sqlsavy (7/27/2011)
Microsoft is looking into the issue now
Ok, keep us posted. I'd love to hear a happy ending on this one, even if there's little hope...
July 27, 2011 at 12:29 pm
Gianluca Sartori (7/27/2011)
Model is the template for a new database, so, if you don't like it in full recovery, change it to simple recovery.No harm: it's your choice.
+1
I do...
July 27, 2011 at 12:22 pm
Ninja's_RGR'us (7/27/2011)
Sqlsavy (7/27/2011)
Microsoft is looking into the issue nowOk, keep us posted. I'd love to hear a happy ending on this one, even if there's little hope left ;-).
Me...
July 27, 2011 at 12:19 pm
dan.forest (7/27/2011)
July 27, 2011 at 12:02 pm
Elliott Whitlow (7/27/2011)
opc.three (7/27/2011)
Even if clients were using different server...
July 27, 2011 at 11:53 am
David Benoit (7/12/2011)
Let me know if you have any problems with the article drop....
July 27, 2011 at 11:37 am
dan.forest (7/27/2011)
I did set up an Alias that specified the individual IP address on port 1433, turned off named pipes on the...
July 27, 2011 at 10:51 am
Elliott Whitlow (7/27/2011)
If you mean, how am I connecting, for the oSQL test here's my connection string:
osql -S dbserver\dbinstance -U sql_user -P xxxxxxxxx
Given your config I really can't see...
July 27, 2011 at 10:49 am
That said regarding aliases...it would be a heck of a lot of work to do all this resolution on the client. You may be able to push aliases to clients...
July 27, 2011 at 10:22 am
dan.forest (7/26/2011)
Yes, but using aliases doesn't resolve the issue with all instances needing to listen on the...
July 27, 2011 at 10:14 am
Have a look at the attachment. It contains two packages.
capture_float_as_double.dtsx:
Shows how to do the type conversion in SQL on the way out. I am stumped as to why this...
July 27, 2011 at 10:04 am
Another option is to capture the result into a string in SSIS and then setup User::dUserVariable as an expression that will convert your string variable to a double.
July 27, 2011 at 9:45 am
Understood. What is the base type of the T-SQL UDT?
July 27, 2011 at 9:44 am
ringovski (7/26/2011)
Maybe I have to convert them all to strings?
NULL is the universal marker for "undefined" for all data types. Empty string is only valid for character types so the...
July 27, 2011 at 9:40 am
Viewing 15 posts - 5,341 through 5,355 (of 7,168 total)