How do u relate master and detail table. What is the parameter other than session id?

Query Analyzer

Use datename function

For Example if you want to get current month

select datename(mm,getdate())

Refer Following Link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=285649&SiteID=1

Refer BOL for Log Shipping and Clustering

Following are the DBA Role:

Daily Tasks

The following tasks should be completed on a daily basis:

Check to make sure the SQL Server is still online and that you still have connectivity.

Check...

It is problem with set. The subquery returing more than on value. While updating in stored procedure add one more conditional check so that your update statement not...

Right click on the job and do a Generate SQL Script. CLick the Preview button and look at the line for:

--Add the job

and take a look at the variable @description....

alter table your table name alter column dd varchar(10)

update your table name set dd= convert(char(10),getdate(),102)

From Eneterprise Manager you can alter the table column as identity.

What is the error you are getting?

INSERT INTO Table1 (CustID, CustName) SELECT DISTINCT CustID, CustName FROM ##TThird T1 WHERE NOT EXISTS(SELECT top 1 CustID FROM ##TThird T2 WHERE T1.custid=T2.custid)

Shortcut for Display Estimated Execution Plan : CTRL + L

Shortcut for Include Actual Execution Plan : CTRL + M

do u want to have current date minus 6hrs data?

If you have index on myStartdate then between is faster.