Rob,

If you do not want the current date range to exceed the current date then change the curEOM to

SET @CurEOM = GETDATE()

E.g. If you run this query on 1/3/2008...

Gail,

We are using different methods but achieving the same goal. You are talking about using a UDF and I am using a simple declaration of variables to house the...

Thanks Grant. I had no idea you could script multiple objects from Object Explorer details window. 😀

Yes.

If you look at...

Looks like Gail beat me too the punch 😉

You should not use the month function becuase you will always run into anomalies that will break your code. Use the datetime fields as they are intended to be...

Right Click the database --> tasks --> generate scripts --> you can choose to drop create any/all objects and set a bunch of options including drop existing and check for...

EXEC master..sp_MSForeachdb '

USE [?]

IF ''?'' <> ''master'' AND ''?'' <> ''model'' AND ''?'' <> ''msdb'' AND ''?'' <> ''tempdb''

BEGIN

SELECT ''?''

EXEC sp_Reindexing

END

'

Like this:

backup log [database] with truncate_only

go

DBCC SHRINKFILE (N'LogicalName' , 0, TRUNCATEONLY)

go

Use the Log file's logical name, not the path

What is the exact error message?

It sounds like a permissions issue. Try executing the procedure from a sysadmin account that has rights to that directory.

You cant create a column at run time and use it in the next case statement. You have to reference the below code or house the data in a...

Your SQL Server service account may not have permissions to the folder, where the backup was created. Try giving SQL Server service account permissions to the folder "c:/domains/something.com/wwwroot/"

Have you confirmed that you have the correct permissions to view the tables that are missing? Make sure that the login you are using, in ODBC, has the proper...