Do you have the directory path as is given above. Just to test try from Start Menu --> Run --> C:\Program Files\Microsoft SQL Server\MSSQL\

and see if this folder is...

Try attach option of the mdf file and it should prompt for creation of new ldf file on verify. Never tried though.

Thanks

Thank You, thats a good idea I would probably create a tool which would automate creation of the Insert, Update, Select and Delete Stored Procedures.

Thanks

It just generates the script as it is a generic script. You need to execute the script and it would create a stored procedure. I thought this is generic and...

Can you please post what errors you are getting?

Thanks

Where do you get error? I did not understand why you are adding one day to GETDATE() function for Active and Inactive Status records.

select

[EMPLOYEE_STATUS],

CASE WHEN [EMPLOYEE_STATUS]='Active'

THEN (SELECT DATEADD(day,...

select

* from hr

WHERE

terminate_date >=( CASE WHEN [EMPLOYEE_STATUS]='Terminate' THEN DATEADD(day,-30,GETDATE()) ELSE Terminate_date END)

You need to use dynamic sql...

In which case points should be alloted only for the posters who answer the questions before the answer is out, i.e. if a member answers the question correctly and within...

I am not sure if you can use CDW for copying database from SQL Server 2000 to SQL Server 2005. Instead why don't you just trying using a backup and...

You can as well modify your source stored procedure or query to return 0 for No and 1 for yes and that way you may not be required to CAST...

I don't think this feature is supported in SSRS.

Todd Sherman (11/7/2007)

---

Howdy, I expanded this a bit, and its now my favorite query for a new database 🙂

By adding the bit to the WHERE clause, it brings back information...

May not be practical in scenario's where you have features like advanced searched across say a combination 15 fields with AND, OR and braces. I would rather prefer building a...

I believe the way Delete Database currently works has adequate steps before it deletes the database interms of having security and also prompting the user for confirmation in a separate...