Try this.

ALTER   VIEW dbo.vwEmp

AS

SELECT DISTINCT

   isnull(E.Attempt,'A') AS Attempt

 FROM  tblEmp E WITH (NOLOCK)

Thanks for your response,

There are 200 tables, when i generate script i chose include primary and forien keys. Is there any way to find which one has create first by...

I don't remember the source of this code, i found some wehre and modified accroding to my requirments.

SET NOCOUNT ON

DECLARE @hr int

DECLARE @fsObject int

DECLARE @tfObject int

DECLARE @fname VARCHAR(30)

<--Declare to hold...

I was exactly looking for how to use (real world examples) sp_OA procedures.

Hi Brian ,

Would you please share the code.

Thank you very much. Which one is the best to take backups (logs, data)

Maintenance plan or t-sql

What are the advantages and disadvantges?.

Thanks for your response. Our database is active 6:00 AM to 6:00 PM Monday to Friday some times on Saturday. My manager accepted to lose 15 min data. Our database...

Thanks for your quick response.

I did like this

SELECT * FROM MyTemp 

WHERE (USERID = 'MANAGER' OR ITEM <> 'BIKE')

Thanks again.

Thanks for your quick reply. I heard that, Point in time recovery is possible, how that works.

And what type of failures can we expect?.

Thanks for your response.

I want to read a table on page and store into table. Where can i get vb script and xml examples?.

Thanks again.

Thanks for your reply, i need just today count minus 10 days back count,

i did how you suggested it worked for me. Again thanks for your help on this.

Thanks Steve,

Is this works

SELECT A.DATE,A.CAR,A.TYPE,A.CNT,A.CNT - B.CNT

FROM

(SELECT MAX(DATE),CAR,TYPE,CNT FROM TABLEA GORUP BY CAR,TYPE,CNT) AS A

(SELECT CAR,TYPE,CNT FROM TABLEA WHERE DATE = CURRENT_TIMESTAMP -10)  AS B

WHERE A.CAR = B.CAR AND A.TYPE...

Okay, I got SRVR_A and SRVR_B, DB_A1, DB_A2 on SRVR_A and DB_B2 on SRVR_B.

With in DB_A1 some objects pointing to DB_A2 (Ex: SELECT * FROM DB_A2.DBO.TABLE1), Now i am planning...

Go to registry -> under HKEY_CLASS_ROOT

you will see ADODB.Connection 2.5

ADODB.Connection 2.6

ADODB.Connection 2.7

If you see last 2.7 that means you got MDAC 2.7. I think there is a better way find...

Dave,

It is a cool script, how can i generate script for jobs ,dts pacakges, uers, and also when we generate script for an object how can i include the...