Try this:

[font="Courier New"]DECLARE @v-2 AS NVARCHAR(MAX)

SELECT TOP 10000 @v-2 = coalesce(@v + CAST(N', ' AS NVARCHAR(MAX)) + CAST(M1.Name AS NVARCHAR(MAX)), CAST(M1.Name AS NVARCHAR(MAX)) FROM master.Sys.Columns M1 CROSS JOIN master.Sys.Columns M2...

REad the article that bitbucket posted.

From your short description, you do not want application roles. You just want database roles - these can be associated with logins. Application...

Are you trying to set up application roles, or just roles? If you create a new role in a database, you can then go to the logins (at the...

You can create one job that calls msdb.sp_start_job 8 times. This procedure returns control when the job starts, so all 8 jobs will run at the same time and...

Verify that no data types are different between the two tables.

Figure out the size of your records (the sum of the space each field takes up based on it's data...

If they are the job owner, they do not need sysadmin permissions.

Make the user db_datareader, db_dtsadmin, SQLAgentReaderRole, and SQLAgentUserRole in MSDB and set them as the owner of the jobs.

I don't know of any tools that allow you to set an expiration date on MSSQL role membership, but it would seem more logical to do all of this at...

You cannot use dynamic SQL in a function.

Compare the execution plan from your query with the one from this query. It eliminates the join and uses a query in the case statement. I think the...

You are joining on:

tbl_BPMStockDelays.bCutOffDate = dtbl_BPMCutOffDate.bCutOffDate

dtbl_BPMCutOffDate.bCutOffDate is in your sub query as: "SELECT 1 AS bCutOffDate"

So why wouldn't you just use a simple WHERE tbl_BPMStockDelays.bCutOffDate =...

You still did a pretty poor job of posting usable sample data.

Here is a pretty simple way using a tally table.

[font="Courier New"]CREATE TABLE #MyTest

(

MyID VARCHAR(15)

)

INSERT #MyTest VALUES ('082011000000001')

INSERT #MyTest VALUES...

By definition, a table in unordered.

If you post the table structure, some test data, and some information about what you are trying to do, it may be possible to help...

What are the differences in the indexes? Is the clustered index on the subscriber fragmented?

I would first suspect a network traffic problem. Remember that when you run SSIS through BIDS, it pulls data from the server to your workstation and then back to...

I have been using SSIS with Oracle for awhile now.

If you are running on a 64 bit platform, you pretty much have no options, you need to use the native...