Could it be that you are mixing between file groups and schemas? File groups have no owner.

Adi

You can use the function fn_trace_gettable in order to insert the data from the trace’s files into table. You can look in BOL (Books On Line the help...

No you can’t. You have to use an instance of SQL Server in order to work with the databases.

Adi

Loose the first per of parentheses that surround the whole view definition (the one that starts after vDimBooks and ends the view definition. If this won’t fix...

Yes it is done only once. The fact that you ask this question shows that you didn’t understand my explanation, so I’ll try to explain in another way....

There is a contradiction between the explanation and the example. I fallowed the explanation. In my code check for difference that is above 60 seconds. I...

What about an explanation about how to know which values should be discarded and which values should be on the same records?

Adi

EDIT - Posted the question before I saw Hal's...

Can you be more specific and explain how you decide which values to show and which values not to show? How do you decide which records should be grouped...

I hope you've taken a backup of Service Master Key also and restored the same on the Prodn. along with the certificate?

If not, kindly restore the Service Master key on...

It isn't accurate because I didn't convert the numbers to a data type that supports fractions, so I might be off by a little bit. If this is...

Maybe something like this will do the trick for you:

select file_id, name, physical_name, size * 8 / 1024 as SizeInMB,

fileproperty(name, 'SpaceUsed') * 8 / 1024 as UsedInMB

from sys.database_files

where type...

I’m sorry, but I’m not a good source when it comes to SSIS. I suggest that you’ll post a new question about how replace characters in a file before...

Bellow is an SQL code that shows you how to use the replace function. The first select shows you how the XML looks (you will see the escape characters)...

You can have a step that opens it as text file and replaces all ampersands with the escape characters that is used for ampersand (& a m p 😉 -...

Pleas don't double post the questions. This question was already answered here:

http://www.sqlservercentral.com/Forums/Topic829664-149-1.aspx

Adi