Your problem is happening because you are not specifying the length when you are casting your results. The default length is 30 - the first "|" just happens to...

I would be surprised if you could run a SSIS 2008 package using SQL 2005 tools. A SSIS package is an XML document that, amongst other things, includes information...

OK - I am now guessing...

Some software give you an option when you are installing it to make it available only to the user doing the installation or to all...

Try something along the lines of....

CREATE TRIGGER [TRIGDelete] ON [dbo].[tempEmp]

FOR DELETE

AS

INSERT INTO TextData(Column1, Column2, ...) SELECT Column1, Column2, ... FROM Inserted

You may also want to consider whether you...

You should be able to restore a SQL 2000 backup to another SQL 2000 instance regardless of the service pack.

The error message you are getting seems to suggest (to me)...

In Management Studio you are viewing the list of providers installed on the server. In BIDS, you are seeing the providers installed on the workstation that you are using...

From Books Online...SQL Server Brower listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer.

Have a look in Books Online...

A differential backup only contains the pages that have changed since the last full backup. This is why it is so much smaller than your full backup.

You will not...

With SQL 2005, it is quite easy to have schema changes replicated. When you create the publication (using stored procedure sp_addpublication), use "@replicate_ddl = 1" to enable replication of...

Column SourceID contains the GUID that identifies each package. If you know the GUID for your packages, then a simple lookup table can be used to join to sysdtslog90....

Reporting Services does its own sorting and is not aware of the sort order you defined in the dimension. You will need to expose the column you are using...

You could do something like...

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[Add_TagName]

--@fiscalYear int

as

CREATE TABLE #Sites

(SitesIDINT IDENTITY (1, 1)

, AlertNameVARCHAR (30) -- or whatever is the correct datatype

,AlertPriorityVARCHAR (30)) --...

Reporting Services does its own sorting and is not aware of the sort order you defined in the dimension. You will need to expose the column you are using...

You could do something like...

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[Add_TagName]

--@fiscalYear int

as

CREATE TABLE #Sites

(SitesIDINT IDENTITY (1, 1)

, AlertNameVARCHAR (30) -- or whatever is the correct datatype

,AlertPriorityVARCHAR (30)) --...

Since the valueof the column(s) that are defined in the clustered index are stored at the leaf level of the index, SQL Server will not do a bookmark for your...