Thanks for your input! Appreciate it

Thanks!

When I tried to import from the 6.5 I get the following error."

"The catalog storeprocs are 6.5 and it needs to be 7.0. to support IDBschemarowset. Please run instcat.sql"

I have...

Hi Antares686,

Could you please elaborate what is an upgrade server? and how can I do this to an get it to be a an upgrade server?

Thanks

Well , as long as I put the table names within

then I should be fine right? Thats good news. Now will this affect any performance degradation somehow though?

Thanks

...

Hi Brian/Steve,

Thanks! I am doing as per your suggestion and it seems fine so far.

Thanks guys.

Hi Steve/Brian;

Or how about this? Say I store it in the sysprocess in the hostname throguh the dbparm from PB and then in my trigger code

"SELECT hostname...

Hi Brain,

Is there a session variable concept in SQl server which I can access later. like here is my plan.

I can set a SQl server session...

Well I know this is not the best way but this is how it is configured.

1) Each user has a certain rights to the app. Now this information is all...

Hi Brian,

I am sure you proably had a need or done this in the past and decided I am goin to ask you a design question.

You might...

Hi Brian,

Thanks for the link. I did it wihtout the text column. But that was a very interesting article. Also was wondering after reading your article...

Thanks Brian!! That was a good article for some one like me who hasnt worked with Inforamtion_schemas a whole lot. Very educating.

Thanks

Hi Kelly,

That works great no doubt about it and thats what I am using. I am little curious to know wont the pkeys information be stored somewhere...

That works great. Thanks Brian!

Hi Steve,

I found out something from syscolumns. There is a column called typestat. when I read in BOL all it says that it is used for internal use only.

But...