shnex (11/18/2008)

---

I want an advice

When I compare two tables or two sp's should I create a local database and put the result there?

The number of comparison is quite big and...

I'm neither for nor against open source. I personally do not use linux because I really don't have the time to learn how to administer it, I have enough...

The backup job is backing up to a Backup Device, basically a pointer to a file's disk location. You can see the devices in SSMS under Server Object ->...

To my knowledge there is not another security level, if the user has permissions to browse and as content manager they should be able to view the reports themselves.

What browser...

Perry Whittle (11/15/2008)

---

although you ran a log backup there could be an active transaction occupying the end of the log file

run

dbcc opentran to check for open transactions

then

dbcc loginfo

a status...

What is the error you are getting?

Are you running the windows application on the reporting services server? My guess is no, so you can't use http://localhost since the reportserver...

This usually means the network connection to the SQL Server was lost.

I think Tim has the solution. If you do not want the 0's you could use the Null transform for numeric.

NULL(DT_NUMERIC, 14,2)

I agree with Lowell, sounds like a Unique Contraint to me.

Yeah, the SSIS errors are basically useless which is why I wrote the article. I was getting the generic errors and needed to know what data was causing...

No you can't take a snapshot of anything besides a SQL Server database.

1. You would probably be better off posting this on a .NET site, not a SQL Server site

2. What does this have to do with Disaster Recovery (the...

I think this thread has what you need.

aftabsatti (11/14/2008)

---

the connection string you are using is not correct. There is nothing like 'Database name' in connection string. Use 'Initial catalog' instead of this, or for more information about...

It would be easier to give you an answer if you gave some details like source, destintation, and if possible, some sample data.

You could also check out this article[/url] to...