select top 1 * from table1 inner join table2 on table1.po# = table2.po#

Hi

do you mean that after changing to unrestricted file growth

it still shows restricted file growth to "2,097,152" MB ?

maximum log file size is 2 TB i.e "2,097,152" MB.

You need not reindex all the tables in the database. In your database there may be tables holding very small amount of data and these tables will have very little...

You could call the stock sp from inside the report sp.

You still will need a temp table to hold data returned by the stock sp.

I agree with steve . You can also backup to a tape. Its better to backup to a local drive and copy to a remote location.

thats the reason

take a full backup and log backup

truncate the log file

check out BOL for more details on this

2 things that come to my mind now...

you can either use a temp table, insert rows into it and then update the sum.

otherwise you can use a union query

select Category,...

How old is your db and from when are you taking log backups.

Are you sure that no huge transactions are going on.

Have any triggers or jobs that modify data...

nice one sergiy

Hi

Just my thoughts here and apologies in advance if iam wrong.

Cant we divide the number of rows in a table with the page count to get the page splits

Qouting from...

Iam sure many have already told u this but once again just to reinfore the point. Remove the cursor and use SET based logic.

I have done this earlier and...

UQ means Unique constraint. these make sure that there are no duplicate values in the specified columns.

Check out BOL for more info.

not really... your problem is that you are not able to login to SQL instance. Probelm lies else where. check once again .

Hi

Since you are using a domain account to login to SQL sever this domain account must have the database owner (dbo) rights in the database.

Generally "sa" or any other...

Hi

dont think a global temp table will work here . How ever you can take data from SQL and put it in text file and from the text file put...