The following script will provide you with a list months.

declare @dtlist table

(dt datetime)

declare @x int

set @x = 0

while @x < 12

begin

insert into @dtlist select dateadd(mm,@x,'01/01/10')

set @x=@x+1

end

select datename(month,dt) from @dtlist

The Ford reference reminded me of this old e-mail chain.

If Microsoft Built Cars

Every time they repainted the lines on the road, you'd have to buy a new car.

Occasionally your car...

I think that would largely depend on the parameters the report may use. Just to state the obvious if the report sometimes runs for 20 sec and is being...

I needed to do something similiar and based on my research you can not access information_schema context in a linked server. every forum I visited ended in the same...

Have you already setup the linked Server in the primary server?

That is on Server AA did you go into SSMS and add a linked server under Server objects? If...

The following is a Link to article with a pretty good description as to how and why this error can occur. there are also many other various blogs and...

If you converted these using some auto process it is possible some extra code was added.

Try selecting report properties in the menu. then select report properties. in the...

If another company is asking for a table layout that it is likely they not only want to know what the fields are in the table but what the table...

I apologize if there is a question there I am not getting it. Is the result of the reverse egineer wizard not what you expected? If that is the...

Start a new Database Model Diagram in Visio. Then from the database menu select Reverse Engineer.

A wizard will lauch and you can follow the steps.

Chris the link to the help page is very useful thank you for the reference.

Lowell, You clarify for me again why I love the DBA community. Thank you for going above and beyond with your script examples. I think I am...

what version of Excel do you use? If you use anything less then 2007 then you can not export that many rows. also what version of SQL do...

I am going to ask a dumb question here but I am just trying to understand it. What are the elements in this that make it find mondays date.

select...

I apologize from the description I am a little confused on what your are expecting to be returned. Can you clarify with an example what you are expecting to...