You can use stored credentials to bypass the user credentials for access to the database. However, you will have to be careful to organize the reports in a way...

I did have to use a cursor to make it work like I wanted.

Thanks for the help!

I have not done this with a CLR, but the whole idea is to be able to go outside the realm of SQL Server and create logic and functionality that...

Thanks!

This does what I need it to do. However, I am having trouble putting it into a set-based statement that performs this on the XML data column in each...

Could also be:

UPDATE t1

SET t1.[field2] = t2.[field2]

FROM [table1] t1

INNER JOIN [table2] t2 NO t1.[field1] = t2[field1]

Eliminates the subquery. Should be more efficient on large datasets.

It really depends upon the type of behavior and your backup strategy.

If it is simply a power failure, the DB will rollback any uncommitted/unfinished transactions and you should be good...

I also need to do this.

My situation is that I have several production databases that I need to add new constraints and PKs to for an update/upgrade to the related...

Here are a few suggestions:

Check the disk space on the disk that stores the DB and log file.

Check the Files page of the database properties to see if the...

Not that I know of.

However, you should be able to use the Import or Export wizard to replicate the data on the 2005 server.

I'm pretty sure that you cannot connect to SQL Server 2008 with SSMS2005. The install requires you to uninstall it due to incompatibility.

However, you CAN connect to SS2005 from...

Two things come to mind. First, make sure you have sufficient disk space on the 2008 server. If you run out of disk space, you will get this...

Option 1 is the most direct way to do it.

However, you can use the SSIS option if you prefer. My understanding is that SSIS packages would need to be...

SSRS 2008 no longer requires IIS! A very good thing.

Go through the Reporting Services Configuration Manager following the steps in order from top to bottom. Pay special attention...

I got it with this:

SELECT TOP 1 EmpID, MAX(EmpWage) AS [Max Wage]

FROM EmpDetails

GROUP BY EmpID

HAVING MAX(EmpWage) < (SELECT TOP 1 MAX(EmpWage) FROM EmpDetails)

ORDER BY [Max Wage] DESC

By "reporting portal" do you mean SQL Server Reporting Services?