1. Use dd MMM yyyy format when saving data.

2. After creating the connection, run

SET DateFormat dmy

1.  it is poosible to have a dynamic sql statement to execute. 

2.  remember to use 3 part name for tables  (DBNAME+'.'+SCHEMA+'.'TABLENAME)

3.  try to...

I am not personally against Reagan, as I see him as a President of USA.  (I was not the President of Sri Lanka - at least officially)

let me share my experiance. I came across a situation a couple of years ago where 2 applications use "identitical set of tables".  In that system we had the middle layer which connects to the...

Good Article. We use the same method here. Only difference is we use @@spid instead of UserName() because all connections use the same user name. (because our middle tier connects...

In addition to the modifications mensioned,

@ServerName is a variable declared in the procedure and not in your dynamic statements

You want to include the value of @servername there. SO...

I too faced your situation and finally wrote the scripts myself.

I'll be happy if my scripts are usefull

Please check

http://www.sqlservercentral.com/scripts/listscriptsbyauthor.asp?author=1771

There are many wonderfull tools available in the market. But for...

Thank you or the valuable information on c2 level auditing.

How to read the log files. It seems to be not in human readable form.

Is there any certified software to...

According to your analyis, currently the fields DID,origination, servicetype, serviceloc, servicecon, servicename, host are duplicated and you want to normalize the table. DID will be the primary key for the...

C2 Level audit writes into seperate log files in the LOG folder

G.R. Preethiviraj Kulasingham

Chief Technology Officer.

Softlogic Information Systems Limited,

14 De Fonseka Place,

Colombo 05.

Sri Lanka.

Correct me f I am wrong.

As far as I know the dynamic statement fails before execution (due to syntax error).

So you can't find anything in the profiler.

Why don't you...

Try

http://www.sqlservercentral.com/scripts/contributions/458.asp

G.R. Preethiviraj Kulasingham

Chief Technology Officer.

Softlogic Information Systems Limited,

14 De Fonseka Place,

Colombo 05.

Sri Lanka.

The Only problem I can see could be locks. Users, when they have access to a table they may write complecated queries, using cursors and table locks so that...

1. instead of "SUM(Fieldname)" try "SUM(ISNULL(FieldName, 0))"

Caution:

IF you are using avg function your result will be different. Without ISNULL system considers only the NOT NULL entries.

2. If you want...

Correct me if I am wrong. I am not a SQL Server Guru

1. It seems to be your index is being defragmented quickly. Try to change the order...