sorry for not being precise the first time.

i have a datetime column which would be required to be displayed in the result in a particular format. Now the format is...

We have a web service set up in a machine(database server) and no citrix is used. there are no entries in Event logs also. when the web service tries to...

but the problem is the table might have lot of columns and i want to create the table on the fly.

depending on the parameter passed, the temp table need to...

Its because, we follow our own coding standards and we want that to be customized in a tool. The BPA covers most of the aspects but we would want to...

The second option is the better one and works out faster when the data you need to dump...

Lets say, it was altered either that very day or the previous day. cant we find anything from the logs??

Obviously, When the situation deals with a lot of records, it is always best to use the set based logic rather persisting with CURSORS. Using Set based logic would give...

Thanks everybody..

Is there any release from Microsoft Press which covers the entire SQL 2005??

Thanks a lot John!!

Yes I am using SQL 2000 and i had tried in Sysreferences already and i could not get the column name. i was able to fetch the table name only....

Hi,

    If it is the case where the table is being replicated, change the size of the column in the table in the replicated(child) table and then change the length...

Hi Ramakrishnan,

           The script you had provided was quite a bit useful but i have some reservations on this method. Actually i had drawn up a similar script but found...