Hi

Use syscolumns or Information_Schema.columns. I have a script which compares two databases and generates the differences. Let me know if you need it.

Whats the error?

As pointed out you cant create a Differential backup of the master database.

Other the checks mentioned in the previous mail you need check for network issues. Are there any Jobs that are runing?

You are better off doing a comparison of the source and destination tables and check the differences. Then plan your data transfer.

Hi

check this link for free tools

http://www.sqlservercentral.com/articles/Tools/64908/.

You will also find T-SQL code for the same if your search this site.

The best way of doing this is to generate the alter script...

Hi

This CTE will give you the root parent claim number of a given claim number.

; WITH ClaimCTE (ClaimNumber)

AS

(

SELECT ClaimNumber FROM ClaimTable WHERE ClaimNumber = @Claimnumber

UNION ALL

SELECT C.ClaimNumber FROM ClaimTable C,ClaimCTE...

You can do it inside a proc . take a look at this..

create table #t (col1 int,col2 int)

insert into #t values (1111,2)

declare @r int

declare @t int

set @r = 1111

set...

Hi

Cant understand your question clearly.

But here goes.....

Is the report using lot of temp tables or table data types. Is there any other activity going on like index rebuilds or...

Declare @sql Nvarchar(MAX)

Set @sql = N''

Select @sql = @sql + N'

EXEC UPDATE STATISTICS ''['+s.[name]+N'].['+o.[name]+N']'';'

From sys.objects o join sys.schemas s

on o.schema_id=s.schema_id

...

If very little activity is going in the db number of reads can go down. If you are reading the data for a particular file did u give the correct...

Not that obvious. 😉

Although iam not 100% sure it seems like the data is shown from the last server reboot. Our dev servers are shutdown for the weekend and when i checked the...

Do you need all the text columns.

Some other things...

Are you shrinking your database between index rebuilds?

If your tables fragments very fast is it possible to look for another column(s) that can server as a better clustered...