Thanx Antares686. Now I am looking at the ways how to make useful exactly as I want.

Regards

Kashif.

Thanx, but I want the format with respect to Locale Settings. The problem is we have different clients who uses different Long Date formats according to their Locale Settings. e.g....

The same type of delete statement caused one of tables in our database empty i.e. deleted all rows.

I got (8 row(s) affected).

Edited by - kashif on 07/16/2002 02:08:16 AM

I agree with u that everyone who works with SQL Server should know how it works. I myself have told many people in my team this ANSI NULLS thing. This...

A good article to show how identity property works.

I think thats how it should work. In case of concurrent INSERT(s) it will always generate a unique value and yes IDENTITY...

I think its better that a DBA is also a Developer because the way the logic is implemented (u should have heard about dbdebunk.com). I myself is responsible for Database...

Hunt'n'Pecker but use 2 to 3 fingers. I like the way some of my friends type who learned typing (u know, without looking at the keyboard). I too tried to...

hmmm... But in this case can't I use just another field referencing the PK?

Regards,

Thanx. It worked.

My Guru (a class fellow and Oracle Teacher) asked me to learn database programming. Then he taught me Oracle 7. Why? because what I see here is more than 80%...

I get times(CPU, Duration) from SQL Profiler. The thing is happening in an SP and it is the 1st statement after the local declarations and assignments. I also checked it...

Well I use a Changes Script. Every change that is made to the Database is scripted in this file and Yes always checking with 'if exists'. only 1 or 2...

Hi,

Good work, b/c I have done something like storing IDENTITY values in a table in the good old days of FOXPro but Access, SQLServer and even other DBMS products support...

I agree to your points that Its not an easy (especially not for hit and try) thing to do and to stop Sys Admin using data from the DB. In...

Thanks Andy. I have just used its latest version. The only thing bothers me is that it is capable of tracking NTHostName and UserName but by adding a table name...