Other reasons not to allow users to RDP on to the server:

(1) If users don't have access to log directly on to the server, you have a more secure environment...

This isn't the recommended way, but if it's only the query you want to modify, and you have no other way of doing it, you could edit the package file...

I'm sure if you type "find largest index in database" into your favourite search engine, you'll get a wealth of results. Or you could right-click on your database, choose...

Your transaction log size is a product of the activity in your database. You're in simple recovery mode, so as long as there's nothing preventing the log from being...

Just cast RegistrationDateTime as time and write your WHERE clause so it returns rows where it's less than '02:00' or greater than '15:00'.

John

Please supply table DDL for tableA, including indexes. How many rows are in the table? Are your statistics up to date? What happens if you add SELECT...

Perhaps the owner no longer exists on the server. Try joining sys.databases to sys.server_principals on owner_id = sid.

John

I think it's those double single quotes either side of @COLLEAGUE_ID. Try removing them and see whether you get the correct result.

John

Steve

Yes, you were right to do so. I just made the...

Steve

I see. I assumed that because you posted INSERT statements, you were actually using them in your package. I don't know how SSIS data flows handle default values....

Steve

Try this:INSERT dbo.Product ( ProductName) VALUES ('Product A', DEFAULT)

Presumably you know at design time which columns have default values? In that case, use a Derived Column transformation to change...

What is the connection string for the data source you're using? Does it include the name of the (correct) database?

John

Once you normalise your EAV-structured data, it's easy. The best way is to change your database design so that your tables are normalised. If that's not an option...

Have you tried typing the location into the Backup file location box? Better still, write an actual RESTORE statement. You'll be able to know exactly what it's going...

Yes, although since you're working on day IDs rather than actual dates, you only need a Numbers table. You also need to cross join to your main table to...