Thank you freinds for your valuable suggestions.

Hi Grant Fritchey,

I have multiple table one for magazine, one for books, one for cdvd and so on. Each table have a flag of availabilit. to write in every table...

See my tables are,

Book table

=========

book_id int

book_name varchar(20)

author varchar(20)

Availability table

==========

book_id int

avl bit

Transaction Table

=========

book_id int

Sale Price mony

date datetime

In table B i want to maintain avlability of the books. Not only I...

its my producation server i restored my database. Now its working fine.

Thank you very much Gail and Carlton.

Thank you all.

i sovle my problem after run

Restore database dbname with recovery;

Thank you Gil. I google it but i was not get the relevent answer of this. It may possible my search was not proper. Thanks once again now i got...

ya offcourse steve we required daily check for this.

Ok thanks for your feedbacks and suggestions. It was a pleasure knowing ur way of thinking.

if i use this query so i can find out how many rows does our largest SQL Server table contains?

USE AdventureWorks

SELECT o.name as [Name], i.rowcnt as [Row Count]

FROM sysindexes i

INNER...

you right steve, from our school we...

Hi freinds,

Me not that much strong like u guys, u my seniors but i want to share something my small research with u. If u feel any mistake in my...

harsha_you (2/18/2010)

When i am running sql 200 job scripts in sql 2005, i am getting the following error.

Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137

Cannot insert the...

Hi SC,

I researched alot on ur query but not getting a satisfied solution from sql online book also.

Let me try once if i will get then i will reply u....

ya i was created still i am not getting any error messages in that...

M.I.

hi, pls try my query in that message coloumn wil give you warning message also. or adjest in ur message column in ur query.

Regards,

M.I.

Try this query, you can also modified in this...

select * from msdb..sysjobhistory

order by run_date, run_time desc

for know more abt this, you can also refer onlinebook link...

http://msdn.microsoft.com/en-us/library/ms174997.aspx

Regards,

M.I.