It won't be in program files. This is a service that is installed with SQL Server. Right click My Computer, select Manage, pick services, look for SQL Server Browser Service.

I'd do the backup and restore thing. Be sure that you use WITH MOVE to move the files to new locations/names.

You install SQL Server, this create a master database. Then you overwrite this one with your backup.

This help?

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

It's often laziness, people just start writing things and don't discriminate. If we could have a CCIE/MCSE/A+ with 12 years .NET and 5 years SQL Server 2005, that would be...

One more, if the data is supposed to be the same, you could export using BCP to char format and "diff" the text files. DIFF would work, or a source...

I like Matt's solution, had forgotten the EXCEPT clause.

you can also get a tool, Red Gate, ApexSQL, a few others make "compare" tools that will compare the schema and/or data...

create table mytable (id int, firstname varchar(10), lastname varchar(10), tele varchar(10))

go

insert mytable select 1, 'John', 'Smith', ''

insert mytable select 2, 'John', 'Smith', '5553333333'

go

select * from mytable

go

update a

set a.tele =...

I think George has it right in his last post above here.

Great discussion!

http://blogs.conchango.com/jamiethomson/archive/2005/12/05/2462.aspx

DDL triggers are good for finding stored proc changes.

If you want data changes from a specific proc, Profiler or a server-side trace. You could log things into another database.

Do you mean the query files open again automatically? I don't think this is possible. You can open SSMS and have a file open, but not sure it automatically opens...

Not sure. This is a simple process that should work. I'd uninstall, reboot, reinstall. Might be something flaked.

Less is more, use few slides, don't read them, put information on them you will talk about, but other than a way to keep people organized, I wouldn't use Powerpoint.

If...

You never know who will win. I wouldn't think that anyone who posts a lot on the site has much more of an advantage than someone that posts little. It's...