Viewing 15 posts - 61 through 75 (of 100 total)
Cheers Martin, I have already read this funnily enough, there truely is lack of information. However when it gets to the nitty gritty the author simply puts:
"
May 20, 2005 at 5:31 am
Chris, before looking in to this I had only managed to find third party articles that specify the licensing difference with instance installation on Standard and Enterprise, however I have...
May 20, 2005 at 3:25 am
Again cheers for the advice. However I am slightly concerned that article #3 explicitly states that it is not for SQL Server 2000 and only for SQL Server 7, however...
May 20, 2005 at 2:26 am
sswords,
Thanks for the words of advice, I am proficient with both DTS and scripting so ultimately have now problem with this, also I am far too familiar with xp_change_users_login and orphaned...
May 19, 2005 at 9:26 am
Tim,
Thanks for the suggestion, I have updated our migration plan to include applying sp3a to the NT4.0 server and testing before performing any subsequent upgrades, helps to cut down the...
May 19, 2005 at 7:35 am
All,
Sorry for the misleading Subject. I had a silly 5 minutes and was going to ask how to acquire older SQL Service packs, (i.e. SP2) then remembered about 2003 Servers SQL SP3 requirements.
ll
May 18, 2005 at 9:16 am
Danster,
Sorry can't shed any light on the DTS creation utilities, however the cheapest way is probably to buy a licensed version of SQL Server 2000 Developer edition which obviously includes...
May 12, 2005 at 6:28 am
Jules,
Actually thinking about it, ignore my second suggested solution i.e. "- Make an identical copy of the account (easy with Windows logins and scriptable with SQL logins) and set the...
May 11, 2005 at 7:39 am
Jules,
First of all are you talking about a Windows Login or a SQL Server Login? Simply changing the password of either of these wouldn't stop existing SQL Server Agent jobs...
May 11, 2005 at 7:23 am
Following up from what hendrix mentioned above, I believe this would be your most scalable solution. I to have had quite a lot of experience with this but have used...
May 11, 2005 at 6:37 am
Chris,
I got exactly the same error when I removed the guest user from the master database (as I stated in my earlier posts) and tried to create it again with...
May 5, 2005 at 4:51 pm
Just to follow up on my last comment, I know that EM stops you from accidentaly removing the guest user from master (and tempdb) but it is possible through query analyser. ...
May 5, 2005 at 9:59 am
Chris,
Could you check that the 'guest' user exists in your master database on the server and if so that the 'guest' user is part of the 'public' role within the...
May 5, 2005 at 9:44 am
As mentioned above, this is deffinately a date representation issue, I have tested the same here and it is purely a case of transposing the dd and mm items.
Try...
April 15, 2005 at 10:10 am
If you're still getting problems can you provide a data sample from your XML file.
Cheers,
ll
April 15, 2005 at 6:32 am
Viewing 15 posts - 61 through 75 (of 100 total)