Using SSMS, right click on the database you are going to use as a template, click Tasks, Generate Scripts, and use the the Script Wizard to generate everything you need.

Let me point you toward Books Online (BOL). Take a look at the definitions of sys.tables, sys.columns, sys.types.

Can you provide...

Pretty broad request, what are you actually try to get back from the sql query?

Here is another way to accomplish this, based again an Sergiy's original code:

declare @pDate datetime;

set @pDate = getdate();

select

dateadd(wk, datediff(wk, 0, @pDate - 1), 0) as BeginDate,

...

Not quite. If the date is 3 March 2009, the end date should be 3 March 2009 not 6 March 2009. Based on the OP's requirements.

But, I must...

Based on Sergiy's code, I think this is what you are looking for:

DECLARE @Date datetime

SET @Date = GETDATE()

select

@Date as [Date],

DATEADD(wk, DATEDIFF(wk,...

Look in his signature block. He defines RBAR there.

Not a problem. Having another set of eyes makes you look at things you might not have otherwise.

You made sense, and I have no problems. Didn't matter if the database was created from my desktop system or when logged in (rdp) to the server under the...

What has been asked can be done without a cursor or while loop. What we are looking for is why this needs to be done in the database. ...

Looking at BOL, NULL is returned on error or if a caller does not have permission to view the object.

That makes permissions another area to consider, depending on what user...

I ran your code on my development server, and it worked fine. I have to ask the question, are you sure all the databases were started? That is...

Satisfaction brought him back...

I've been fighting that fight here. How about:

1) Off-site storage costs too...