Viewing 15 posts - 676 through 690 (of 1,790 total)
I can try to take a look again today. Can you provide the data scripts as insert statements? Thanks. I'm a wee bit busy and really can't take too much...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 8, 2009 at 7:20 am
Tsk Tsk, at shortly after 5 PM EST I thought it was going to be a day without "The Thread" being posted to one time. I almost posted myself but...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 31, 2009 at 10:24 pm
I would drop the user from the database then re-add that user based on the login you just created. My guess is that the database you are working with was...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 31, 2009 at 7:43 am
Again, what you are viewing is not what options are available for connecting to a database. That is controlled at the server / instance level only. What you are viewing...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 31, 2009 at 6:41 am
The properties view that you are referring to only shows how you are connected to that server so, that is not changeable. If you set the server to mixed mode...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 31, 2009 at 6:33 am
That would be true. However, I would highly recommend that you use sp_send_dbmail since you are in 2005. You can find great resources on configuring Database Mail HERE.
Hope this...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 27, 2009 at 7:30 am
I was able to take a quick look at this and the thing that quickly jumps out at me is that the index, _dta_index_ContactNumber_7_948198428__K2_K9_K10_K1_6, is missing idnumber as part of...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 27, 2009 at 6:53 am
Follow standard restore process and the conversion will take place at completion of the restore. Post with any problems that you have.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 19, 2009 at 1:58 am
Glad to hear this helped! It definitely helps you grab those ugly ones pretty quickly. Might be worthwhile to do some tracing as well and start to grab those queries...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 17, 2009 at 8:30 am
sp_msforeachdb @command1 = 'use ? select ''?'', name, size*8/1024 as SizeInMB from sysfiles'
You would have to insert this into a temp table and select out of that - or -...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 16, 2009 at 8:49 am
If it is "shared" disk then it could be something external of the server / instance that you are looking at for sure. You should be able to get with...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 13, 2009 at 12:28 pm
I'm not certain about the cross domain question but I would assume that if you have a domain trust in place you would probably be successful.
However, I'm still a...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 13, 2009 at 7:57 am
Duplicate post - refer to this link
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 13, 2009 at 6:44 am
Duplicate post - refer to this link to answer this. http://www.sqlservercentral.com/Forums/Topic675086-338-1.aspx?Update=1
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 13, 2009 at 6:39 am
When you are running the 2008 tools against a 2008 instance you can.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 13, 2009 at 6:38 am
Viewing 15 posts - 676 through 690 (of 1,790 total)