Chris Harshman (12/5/2008)Using Merge Replication would allow changes at the head office to get to the remote sites and changes at the remote sites to get back to the head...

Does anybody have any ideas about this?

Hi Chris,

thanks for jumping in!

The application is a Windows Forms app and I can't guarantee an always on connection, or even a broadband internet connection at all sites.

So if they...

Thanks Noel and MohammedU

Hi,

I've never used it but I've heard good things about Toad: http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm

Thanks Duane!

I ended up uninstalling SQL Server completely and re-installing it.

Hi Geneva,

it turns out that I needed to set up the person as a System User, under the Site Wide settings.

I found this reference in Books Online which seems to...

Hi Mike,

Thanks for that. I don't understand the logic, but, adding the user to the admin group made the button appear. So what browser setting should be changed?

Thanks David, you've been very helpful, I'll try that.

Now, onto my Report Builder access problem

Hi David,

I got it solved! The installation was on a laptop and the admin user was logging on to the laptop, however the standard user was logging on to...

Well, it looks like I stumped everybody (or maybe my question wasn't clear enough).

Anyhow, I found a tool called RS Scripter which generates a script to deploy Reporting Services stuff....

Hi Jason,

thanks for responding. I've been considering the book you mentioned and Professional SQL Server 2005 Reporting Services by Paul Turley and one or two others I found...

Thanks.

It turns out the .DAT file was actually a backup so restoring it worked. I n=guess older versions of SQL Server created .DAT files instead of .BAK files.