You could control this via Active Directory Group Policy Objects, by not allowing users access to the ODBC Data Source Administrator.

You could achieve this by only granting permission to execute the "private" sps to a certain user and then have the "public" sps call the "private" sps with EXECUTE AS...

You can run some traces from the client machines through the ODBC Data Source Administrator.

You might also want to check the connection time out setting on the SQL...

Mark,

I use SSIS to import Spreadsheets into tables and to export tables to spreadsheets, with quite a bit of success, even with large files.

The basic how to would be:

Open...

Have you configured the SQL Server via the SQL Server Surface Area Configuration Tool to allow remote connections?

If you can get 15 minutes you could: (Probably more like 10)

Get everyone off of the SQL Server.

Set the SQL Server into single user mode

sp_dbcmptlevel , 90

Set the...

That seems like a fairly weird problem, I'd try stopping the SQL Server Agent and starting it again.

Looks like you used an invalid email address, maybe an Active Directory user name? Ensure that you are providing the profile a valid email address. ie. bobjones@mydomain.com

Check...

Wow, I need to read the question and answer the question. Have you re-indexed? What do the SQL Server logs have to say?

Check to see how much your Destination table is growing during the inserts for the problem table. It's probably growing quite rapidly when you are inserting the data.

You should be able to do both full and transactional backups with the database still remaining online and available. If you move to SQL Server 2005 Enterprise, you can...

I have had really good luck using the sp_send_dbmail when I need to send query results via email. You can use T-SQL in SSIS, just make sure you grab...

Since you are using SQL Server 2005 Express, you face quite a few limitations on how to distribute the data. How much data are we talking about?

I...

From my experience you have to run instcat.sql script on the SQL 2000 machine if you want to create a linked server for it from a 64-bit SQL Server 2005....

I'm pretty sure I had it working, but maybe with a two part name ie.

LinkedServerName..TableName

However, when I went to look yesterday afternoon I had removed all of the mysql...