How about the InteractiveMode variable?

Indicates whether the package is run in interactive mode. If a package is running in SSIS Designer, this property is set to True. If a package...

Presumably you run the debugger on a PC during development, but the package will run on a server in production? If that's the case, you can test the value...

You can't. Any primary key or unique constraint is enforced by an index. You can choose a non clustered index for the primary key if you prefer.

John

Not that I'm aware of, but you can use xp_logininfo to list the members of the group.

John

Rajnidas

Since you didn't post the code, I can only guess. I should think that your stored procedure is attempting a UNION or JOIN operation between a table in the...

What is the recovery mode of your database? Do you have transaction log backups set up?

John

Ah yes, that works. I was thinking you need the same columns in the SELECT list as in the GROUP BY clause, but of course you don't. Thanks...

The reason for the CTE is because he wants SubName instead of SubID. Also, if SubName isn't unique, that would mess up...

Put what you've already got in a Common Table Expression, then join to the Subject table to get SubName.

John

I think the timeout is in trying to connect, not in running any command. Maybe the MySQL server is down, or there's a problem on the network?

John

No, I haven't. But you could run a trace to see what SQL is being fired when you bring up the Properties page, and hence why it isn't showing...

That's your answer. There's a problem with the share, nothing to do with SQL Server. Maybe there's a firewall in front of the server? Perhaps the share...

This...

where p.DivisionCode in ('$','1','2','{','#','L','6','t','[')

and p.PSIKey in ('1','2','3','4' ,'5','6','7','8','12','13','14','15','16','17','18','19','20','21')

... is turning your outer join into an inner join. Try putting those two conditions in the join predicate instead.

John

Don't use the administrative share. Can you map a drive to \\BRANCHSERVER2\Backup?

John

Same error message?

Can you map a drive to that folder from your desktop? The (original) error message was that the network path isn't found, so I would start by...