Viewing 15 posts - 1,771 through 1,785 (of 1,790 total)
Balaji,
You may want to check out Q267953 to see if this meets your conditions as well. This is an apparent bug in 2000 under certain conditions. Worth a look anyway....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 31, 2001 at 2:25 pm
Besides running SQLServer 2000 can you give more specific information like amount of memory on box, is SQL running on dedicated memory or dynamic memory allocation. You wouldn't by chance...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 31, 2001 at 2:20 pm
That proc is undocumented but, if you just run it as is i.e. xp_fixeddrives it will return something like as follows;
drive MB free
C410
D1271
E10356.
Don't know if there are any...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 30, 2001 at 9:12 am
Bill,
Your boss is right and what a perfect opportunity to get control of what is going on in the databases. Normally you as the DBA have to force this issues...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 30, 2001 at 6:50 am
I'm assuming you would be passing in @tabName so, you will need to change this some however, a working variation is below.
declare @qry nvarchar(500)
declare @qry1 nvarchar(500)
declare @tabName nvarchar(50)
declare @x int
set...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 28, 2001 at 11:01 am
Just thought I would finally close this post out! We found that the issue is with the MDAC version that was used in the ODBC connection to the database. We...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 27, 2001 at 12:39 pm
PattiKay,
Check out article Q255097 from Microsoft. This is apparently a known issue however they do suggest a workaround. Hope this helps and have a great day!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 7, 2001 at 12:19 pm
Wes - Long time since you have posted. This is something that can't be answered specifically as there are too many variables to include such as processor, memory, server activity,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 2, 2001 at 1:35 pm
Jay,
After reading your post and struggling with this on several occasions in the past I did some further reading in BOL and found this in the Checkpoint Topic. I thought...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 1, 2001 at 9:53 am
I too was going to offer the same deal but, if I had my choice between me and Steve, I know I wouldn't choose me. Hope this works out well...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 30, 2001 at 3:51 pm
Joe,
Does the account that is logged on to the Server you are installing SQL 2K on have Local Admin or Domain Admin privileges? This may sound like a dumb question...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 30, 2001 at 12:15 pm
Joe,
We have done numerous upgrades from WinNT 4.0 to Windows 2K and subsequent SQL Server installs following that with no problems. So, I don't believe that to be the issue....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 30, 2001 at 10:59 am
...and now that we have all the technical aspects of this job title defined, a DBA must be the type of person that is approachable above all things to be...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 30, 2001 at 8:58 am
Having the users workstation in AD would only be necessary if you are going to manage that computer with Active Directory so, no the user workstation would not have to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 25, 2001 at 11:58 am
Kevin,
There is an article on this site http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp that covers the options here rather well. One question and excuse my ignorance but does 6.5 run on Windows 2000 and even...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 23, 2001 at 9:23 am
Viewing 15 posts - 1,771 through 1,785 (of 1,790 total)