Viewing 15 posts - 7,171 through 7,185 (of 7,429 total)
I never found myself with a major issue, just the occasional failing job as noted in previous post. Currently I have everything scripted and it has so far done quite...
February 20, 2002 at 4:03 am
Try applying a Service Pack, eval will not allow this and will bark about it. If it takes then the upgrade was fine.
February 19, 2002 at 5:56 pm
Check here for details for 7 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q237303 and for 2000 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281574
February 19, 2002 at 3:42 pm
I would try installing the latest MDAC first. If the problem seems to happen often and requires a reboot it is generally a sign of a possible memory leak in...
February 19, 2002 at 3:29 pm
Actually you have to be carefull with doing that against ASP sources as you can halt IIS if connection pooling is occurring and even sometimes when not. The object is...
February 19, 2002 at 3:23 pm
Numeric for number, and varchar or char with a lenght of no more than 255 for the text.
Nermic has a precision and scale in the for NUMERIC(p,s), p = to...
February 19, 2002 at 3:14 pm
Try sp_removedbreplication 'yourdatabasenamehere'
February 19, 2002 at 3:08 pm
Sorry, I am not at work so I am having to think about these without testing.
Try each and see if any will return your data, if all do then the...
February 19, 2002 at 3:04 pm
I will try to get a snapshot or two tomorrow at work I can forward to show you what all I do.
February 19, 2002 at 1:45 pm
Ok I think I almost have a clue. If you do not have the client installed on the same machine as the SQL Server you are trying to connect from...
February 19, 2002 at 1:15 pm
If you are not storing as money datatype then try changing the datatype of the field or
CAST(fldName AS money)
Or use smallmoney based on your maximum amount. See datatypes in...
February 19, 2002 at 1:11 pm
From SQL Books Online when using sp_password:
Execute permissions default to the public role for a user changing the password for his or her own login. Only members of the sysadmin...
February 19, 2002 at 1:03 pm
You have installed the oracle client with the data connectivity drivers, right? If yes I will need to run setup when I am at work tomorrow to give you the...
February 19, 2002 at 12:52 pm
There is another thread with this same need for an Oracle linked server but I have found in the past 6 version some major differences and issues to deal with...
February 19, 2002 at 12:50 pm
What are you exactly trying to do and what method are you trying to use?
February 19, 2002 at 11:40 am
Viewing 15 posts - 7,171 through 7,185 (of 7,429 total)