As a DBA, bugger all.

I am a developer, title Software Engineer (fancy or retro eh!). But when our full time DBA left I had to pick...

Someone else in another thread suggested something like this

use Client Network Utility to create an alias (eg LINK1) that points to one of the servers (eg DEV) using the real...

How is the data being deleted? If it is done by a single proc then you can add code in the proc to store the data to be deleted in...

Load the data (from Pervasive) into a staging table and then create another task to insert into the dest table info that is not present.

Nice to know someone is! My boss is reviewing our SQL strategy and looking to move to SQL2000. Don't know when. Can't see us moving 2003 for a while.

Yep Frank, thats it. It is the only MS page I could find that specifies this. Other web sites mention the use of registry change as stated in the article.

I...

If you check out this link

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B196909

it states thet the configure option is on 2000 EM.

For SQL7 you have to create the following key

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\NumErrorLogs

Since the question did not specify a version...

I am one of those who did not know what 228 & 229 meant (until I read the topic further). We have 4 servers (SQL7 SP4)...

Actually you can, as long as it is in the same session/proc, like this

declare @sql nvarchar(1000)

set @sql = 'DECLARE curs CURSOR FOR select col1,col2 from...

eily,

Do you mean like this

where @param = 'ALL' or (@param <> 'ALL' and charindex(cast(column as varchar),','+@param+',') > 0)

param could be 'ALL' or '1' or '1,2,3' etc

IsDate in MS VBA does allow strange dates, I belive it only does generalized checking and in your case would always work.

SQL seems to have trouble converting dates, try this

declare...

Brian,

Not to labour the point too much but if the intention of the question was to elicit an answer to 'why can't Enterprise Manager see the local drives' then I...

Good one Richard. However in my case if the year is less than 1900 (suspect date) then I don't want the date anyway (what would be the correct year?) that...

Do you mean

<% r.Open "SELECT LEDef_Cd, LEDef_Name, LEDef_Desc, LEDef_ActiveInd, LEDef_PublicInd FROM LEDef WHERE (LEDef_ActiveInd = 1) OR (LTRIM(LEDef_Cd) LIKE '10%')", "UID=aspen;PWD=aspen;DSN=aspen" %> 

 

Sorry had...

In .NET is use

Now().ToString("s").Replace("T", " ")

which gives me yyyy-mm-dd hh:mm:ss format, which sql has no problems.

If you do not want the time portion use

Now().ToString("s").Substring(0,10)