Below is my explanation,

While creating any DB , there is an option for fixing the default data file size of DB. Here in my case what happens means, the DB...

Hi Experts,

Thanks a lot for your valuable suggestions. I got the information what i needed from your responses. Very glad to u all.

Hi Thanks for your advice, But while restorina a 32Bit DB with 64Bit DB Backup , it is throwing an error like follwing:

The media family on device 'C:\Documents and Settings\xyz\Desktop\CICMT...

Hi All,

Here i am having a doubt regarding the Dynamic Query. My requirement is How to store the Dynamic Query resultset into a TempTable? Could it possibel?

Because i...

Sorry!!

Views, While loops are not to be used in our environment.

Thanks,

i Friends,

I am facing a problem in writing a stored procedure for searching entire database(All tables) when a word is given as input.

Please provide me your valuable suggestions. and the...

Hi Paul,Lutz and All,

Please help me in below:

I wrote a stored procedure ad passing Executing the SP as follows, please correct me in this becuase i am not able to...

Hi Paul,Lutz and All,

Please help me in below:

I wrote a stored procedure ad passing Executing the SP as follows, please correct me in this becuase i am not able to...

Hi Friends,

The advice which you given are very helpful.

Here is one more query, Please help me in this

There is a table named Workers as below

WorkerID----- WorkerName-----workerAge------WorkerGroup

----1------------abc-------------21---------------dep1

----2------------sds-------------25---------------dep2

----3------------asd-------------27---------------dep3

----4------------hgf-------------23---------------dep4

while selecting the column in...

Thank you Lutz,

Thanks a lot.

PLease help me in this, I am getting an error like while executing the following query

"XQuery [value()]: No more tokens expected at the end of the XQuery expression. Found 'AdminDetails'."

CREATE...

Yes ,

Its working ,

Thank you Pauland Lutz

Yes i did the same , but no luck :crying:

I am sorry to say this, When i execute the above code which you sent, no rows are getting effected: Showing that the table is empty

I also tried a code,...

Hi Friends,

The following XML data is getting from frontend (from application). I need to store the data in the table (Not in xml format). How to achieve the...