thanks.

not sure...but maybe it could be a dynamic proc being created somewhere just for the process\job?

Or maybe it could be a temp stored proc.

Hmm.....Database Mirroring is already available. Earlier (still talking about 2k5 Beta) it was a notion that it is an option that could be taken from Microsoft, but it is already...

Wonder how so many people got it incorrect.

Reading the question one would see that the obvious answer would be one, but then, why would someone ask such a simple...

I do suppose that you have the domain accounts set up? What about the security settings for the SQL Service and Agent service (here i dont think the agent would...

Normally i would have found it in BOL if it existed but my BOL does not show these sp_MSForEachDB and sp_ForEachTable.

thanx. Found them in Undocumented procs.

I did not get you. I did not even find the  SP_MSFOREACHDB.

My problem is i have a very complex procedure which i need to install and run from every database...

The question was put in such a way that the table already existed, anywayz if table existed then both A and B are correct,

if conditions such as IF TABLE...

Would it matter, performance wise using

var1 IS NULL

instead of

var1 = NULL

?

One would expect to see some help/advice on 70-229, which would guide a person in a proper direction and not trying to buy/sell some stuff. 

Thank you 

Try this......this may also help as a base metadata view for generating other code.

SELECT

 so.[name] AS 'TableName',

 sc.[name] AS 'ColumnName',

 st.[name] AS 'ColumnType',

 sc.length AS 'ColumnSize',

 CASE sc.isnullable

  WHEN 0 THEN 'No' ELSE 'Yes' END...

Just a question. Woudn't  (Select 1 From GenNum where So = @Seroff) would be more efficient?