Yes of course 🙂

Can you compare your project with a dbschema file ?

If so, just create the dbschema file by building your first project, open your other solution and then try to compare...

http://msdn.microsoft.com/en-us/library/ms180843(v=SQL.100).aspx

Sorry.

What about this :

declare @cmd varchar(max)

SET @cmd = ''

SELECT @cmd = @Cmd + 'select Avg(Price) from [' + s.name + '].[' + o.name + ']

go

'

from sys.objects o

inner join...

Matthew

I don't have any Visual Studio 2010 available right now so I cqn't check but if I remember it well, it is possible to schema compare everything (db or project)...

Here it is :

declare @cmd varchar(max)

SET @cmd = ''

SELECT @cmd = @Cmd + 'select Avg(Price) from ' + name + '

go

'

from sys.objects where type = 'U'

select @cmd

exec (@cmd)

What is it for ?

You can do it in a SSIS package as well.

Can you give us the result you have when executing :

SELECT * FROM test.dbo.sysfiles

PLease have a look at this :

http://blog.jitbit.com/2010/04/moving-sql-table-textimage-to-new.html

Duplicated post :

http://www.sqlservercentral.com/Forums/Topic1232922-392-1.aspx

Hi

It's not that easy.

You have to install Integration Services on your Production server (that must be done on your dev server);

It will install the required DTExec and the engine that...

- Can't you just get your 2 revisions as if they were separated projects and then use the GUI ?

- What do you mean by 'STill no joy ?'

It doesn't...

What is your policy about password expiration ?

Maybe the password just expired.

Sorry guys, I will create my post.

Default trace is enabled :

name minimummaximumconfig_valuerun_value

default trace enabled0...