Can you show us your script?

One thing to note: This "set dateformat dmy (to make them european)" is NOT a true statement.

SET DATEFORMAT does not make the date any format....

My understanding is that you can't do that. Once you put the database in 'normal mode', that recovers it and no more transaction logs can be applied. It is...

Abhijeet,

Please do not 'hijack' other people's posts.

Proper practice:

1. start your own thread.

2. do not 'hijack' other threads.

3. pay attention to when a thread was started...some you have posted this question...

Abhijeet,

Please do not 'hijack' other people's posts.

Proper practice:

1. start your own thread.

2. do not 'hijack' other threads.

3. pay attention to when a thread was started...some you have posted to were...

Abhijeet,

Abhijeet,

Please do not 'hijack' other people's posts.

Proper practice:

1. start your own thread.

2. do not 'hijack' other threads.

3. pay attention to when a thread was started...this one is over 3 years...

Abhijeet,

Please do not 'hijack' other people's posts.

Proper practice:

1. start your own thread.

2. do not 'hijack' other threads.

3. pay attention to when a thread was started...this one is over 3 years...

Please start a new thread....don't 'tag' your question onto someone else's thread. Especially one over a year old.

-SQLBill

This might give you a solution:

SELECT CAST(25/24 AS VARCHAR(2)) + ' Hours' + ' and ' + CAST(25%24 AS VARCHAR(2)) + ' Minutes'

Note: There is one space before Hours, one...

Have you tried 'fully qualifying' the name?

databasename.owner.table

northwind.dbo.customers

-SQLBill

You might have to make this a table alias....

LEFT JOIN

[SELECT description, id, type, call_req_id, last_mod_dt FROM act_log] A ON call_req.persid...

Okay, you know the antivirus won't be able to scan your database files. But it will try. So, do you really gain anything from seeing all the error messages that...

There are no hyphens in DATETIME datatype. Check the BOL. Quote: Values with the datetime data type are stored internally by Microsoft SQL Server as two 4-byte integers. The...

BTW-you don't say what problem you are having....so....

Remember, if you have a parameter then you must input SOMETHING.

EXEC @company_name = 'MyComp',

@employee_name = 'Smith',

...

If a parameter can be NULL, I make the parameter default to NULL and then use a WHERE clause like this:

WHERE (BeginDateTime >=

CASE WHEN @BDateTime...

You could change the name of the dev server database, move it to the production server, do a INSERT INTO and select all the data from the production database tables...