Recent content by GoodDay

Sorry - attachment in my previous post not readable ...

thanks jmeckley!! Sorry I forgot uncommented this code I did it catch (Exception ex) { //write in log LogWriter.Write(msgPrefix + ex.Message); messages = null; return false; } Earlier I looked this...

Hello I have some problem with reading message in some email (inbox) I see this message in inbox (Outlook client), but it is not found by method FindItem. It happens after some experiments with this message, but what I do not understand. Other messages was founded good. There is a simple code...

George , thank you !

George, thank you. I try do it at monday. But some stored procedures r working with another openrowset MDAC (now i forgot the version of MDAC) And i feel, that MDAC is another problem.....

Sorry - I so quick press button Post. My question is : And how I can register (install) this provider (dll) on server (that also has 64-bit Windows version)?

Thank you, gmmastros, but in result set of xp_enum_oledb_providers there is NOT "Microsoft.Jet.OLEDB.4.0".And how I can register (install) this provider (dll) on server (also 64 bit version)?

Hello & sorry for poor english! I migrate from SQL 2000 on 32 bit platform to SQL 2005 (Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) One of the...

MrDenny - thank you 2!!!!!!

Hi gradley! Thank you very much for help and understanding !!!!!!!

Denny , my log file data size (or more correctly logical size) is 5.24 MB , physical size is 1727.44 MB I made shrink from EM (Compress pages and truncate free space from the file). After that logical size decreased. But DBCC SHRINKFILE ( logFileName,1536) execution failed. I don't understand...

Thanks, gradley!

Thank you Denny (especially for a good words about my English):-)! I try to execute your code and then DBCC SHRINKFILE Error ("Cannot shrink log file......") appears again. Thank you

I have a Database (MS SQL 2000 Simple Recovery Mode) then execute thats operations: 1 - DBCC SQLPERF(LOGSPACE) - log size for my db is 1727 MB 2 - BACKUP LOG <myDbName> WITH TRUNCATE_ONLY 3 - DBCC SHRINKFILE ( logFileName,1536) ---less then current size - 1727 and get error message: Cannot...

Good day! I have some questions: 1 - What is better - use application roles or database user defining role? In my mind - application roles are easier in implementetion and have a higher security mechanism 2 - What is better in generation PRIMARY KEY (for example &quot;int&quot; datatype) -...