Hi,

You may use these two ways:

1) Build dynamic query:

SET NOCOUNT ON

DECLARE @db NVARCHAR (50), @sqlStr NVARCHAR(4000)

DECLARE @tbl_dbs TABLE (dbName NVARCHAR(50))

INSERT @tbl_dbs SELECT Name from master.sys.databases

WHILE EXISTS

(SELECT dbName FROM...

Verify that you enabled this Oracle provider for your SQL instance:

- go to the SQL Management Studio -> Server Objects -> Linked Servers -> Providers

- double click on...

Did you mean you need to access Report Manager? in this case you have to use this URL:

http://localhost/Reports

Click on the textbox properties in design view. Go to the "Navigation" tab. Under "Jump to URL" enter expression:

="http://www.hoopty.com/value="+Str(Fields!TexboxName.Value)

Can you see services in "SQL Server Configuration Manager" tool? Your installation can use named instance (in this case you will see instance name in brackets next to the service)....

Make sure that SQL Server Agent service account has permissions to the location of the Excel file.

Also, here are two links that could help:

http://support.microsoft.com/kb/918760

http://support.microsoft.com/kb/933835

Try this:

1) add another variable of type Int64 (named as IntVar in this example)

2) use expression to assign value to this variable (DT_I8) @[User::StartPeriod]

3) change your expression to (DT_WSTR,50)DATEADD("dd",...

Under Connection Managers modify Excel connection's properties. Use Expressions property - > add property expression for the ConnectionString - >

"C:\\Recuperados"+REPLACE(SUBSTRING((DT_STR, 30, 1252) DATEADD("dd",-7,GETDATE()) ,1,10) ,"-","")+"-"+ REPLACE(SUBSTRING((DT_STR, 30, 1252) GETDATE()...

I would recommend you to run sp_updatestats stored procedure after restoring the database. Also, if there were full-text indexes you will need to recreate them on the new server.

There are Webcasts series that you can find on the Microsoft web site. This was the best way to learn for me.

http://www.microsoft.com/events/series/sqlserverbi.aspx?tab=webcasts

Changing the master database collation is not easy. One of the steps is rebuilding the master database. All steps could be found here:

http://msdn2.microsoft.com/en-us/library/ms179254.aspx

When you use ALTER DATABASE...COLATE statement...

Hi Totti,

Here is the link from my Favorites:

http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.aspx

I have not tryed to do it myself, but I hope it will help you.

No, I want to live the columns and the rows as is. We just need to display columns names vertically (change text direction).

Is service account domain user or local Administrator? Do you have BUILTIN\Administrators as member of SQL Server sysadmins server role?

About differential backups. I just want to give example from my experience. We had database which had differential backup (daily) bigger than full backup.