Is there any way to set order for triggers if teh same is more than 3-4 . coz i have a table which fires more than 12 triggers.

Hi,

Run teh Following commands

BACKUP LOG <DBNAME> WITH TRUNCATE_ONLY

DBCC SHRINKFILE (<DB_LOG FILE NAME>, 2)

This Should reduce the file to 2 MB The Normal Log backup wont Truncate the File. else you...

Wish List

1) Need t Generate the Diagram for the result set of the Objects which are returned by an input .

2) Printing

3) Would like to see the report in Pages....

Wish List

1) Need t Generate the Diagram for the result set of the Objects which are returned by an input .

2) Printing

3) Would like to see the report in Pages....

Hi,

Thanks. Its working now i used the windows Synchrinisation manager.

But When i used the exex SvrNetCn.EXE i am Getting a Message Box Operation Complteted Successfull and closing. Any Idea...

Hi,

Hi to Give a Password install the MSDE from Command Prompt like the following

setup sapwd "sapwd"

once this is done . you need to go to windows registry

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\

change the value of...

I am not sure when this was posted or wether this got solved. happend to see one thread while browsing. But I havent found any one suggesting having clause. I always use...

Hi,

Was just curious that how parsename will work if the number of '.' are more than 3.  

I feel this is being used to represent some sort of tree data.

Jeswanth

Happend to see this while browsing . thought it might be relevant here. have a look

http://www.sqlteam.com/item.asp?ItemID=2368

Jeswanth

I feel the discussion is leading to a wrong way. Instead of discussing the ways to retrieve the db to a proper shape it’s ridiculous to post such allegations against his own...

HI,

Do restore an old copy as a new database and Get the Key information from the System Tables and run in the Db where its missing. Thats all i see...

Try this code. you might save remaining 12 Minutes also..

UPDATE

 B

SET

 b.id = A.id

FROM

 dbo.many_tbl A inner join dbo.OutpUt_tbl B

 ON A.id = B.ID

Jeswanth

Thank you all for the replies. Again this time also I learned some thing from your replies..

Then I got this problem solved by doing a cold boot.. the server was...

its coming quick.. thats how now every one getting the database list now.

Hi,

If the problem is still existing ,

do the following.

As you might have got that its coming because of duplicate records. so you need to correct the same by removing...