As far as I know, you can't - RESTORE DATABASE will leave the database owned by the user who performed the restore. You'll need to add the change of...

Just change your connection string(s) so they have the new server name. That should be all - there's no need for an application to know whether its database is...

What have you tried? If you show us that, we can show you where you're going wrong. Here's a hint: use CHARINDEX to find the position of the...

The reason your script fails is that the [font="Courier New"]EXEC @Variable = ProcName[/font] syntax writes the return value, not the output parameter value, into the @Variable variable. Return values...

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...