If the login is not linked to a user in the database then they will not be able to connect to that database.

To find the database user name for the...

I think what you need is to aggregate over a partition based on the 15 minute interval. See if something along these lines works for you:

WITH cte

...

Nevermind...memory failed me there...

Yes, Google for "SQL Agent Tokens".

Please provide runnable DDL to create your tables, some DML to create test data and your expected output. Also posting the queries you are working with now will help start...

What is the value of the MaxMemoryUsage property on the Cache Transform?

You posted into a SQL 2008 forum....you may have better luck posting this in the DTS forum: http://www.sqlservercentral.com/Forums/Forum19-1.aspx

BCP is very fast and should do fine for this task. BCP will handle exports with a very...

OPENQUERY is your friend. It guarantees the query will be executed on the remote server.

With 11 tables, most of which are on the remote server, you have your hands...

How about something along these lines:

IF OBJECT_ID(N'tempdb..##missing_index_info') > 0

DROP TABLE ##missing_index_info

GO

CREATE TABLE ##missing_index_info

(

[index_handle] INT,

[column_id] INT,

[column_name] NVARCHAR(4000),

[column_usage] NVARCHAR(4000),

[audit_date] DATETIME

) ;

go

INSERT...

Invalid meaning you don't like it?

The schema generator generates a valid schema per the XML provided...but it takes a least-common-denominator approach. If you have constraints you need in your schema...

Please do not double-post. Direct comments here: http://www.sqlservercentral.com/Forums/Topic1082871-21-1.aspx

1. In an SSMS query window run this while in Grid Results mode (Ctrl+G):

SELECT CONVERT(XML,'<?xml version="1.0" encoding="UTF-8" ?>

<File>

<Row>

<Column Name="JobID">2010-1022</Column>

<Column Name="Folder">Closed (Filled)</Column>

<Column Name="NumberofOpenings">1</Column>

<Column Name="NumberofOpeningsRemaining">0</Column>

<Column Name="BusinessCardTitle">Director of...

Not that you won't receive help here but you may want to post this question in one of the Reporting Services forums: http://www.sqlservercentral.com/Forums/Group416.aspx

SQL Server supports casting strings containing exponential notations to approximate data types:

SELECT CAST('5.01217e+006' AS REAL) AS string_to_real,

CAST('5.01217e+006' AS FLOAT) AS string_to_float

edit:...