how does the user kick off the dts? do they have access to enterprise manager?

you should be able to accomplish that easily with database and table permissions using enterprise manager. only grant the user database and select permission on the tables he needs...

According to Brian Larson in 'Microsoft SQL Server 2005 Reporting Services':

the system user role has the ability to 1) Execute report definitions 2) View report server properties and 3) veiw...

JuanBob (1/31/2008)

---

I originally posted this in 2000 forum, but thought I should put it here since we'll be upgrading to 2005 later in the year.

I have acquired a new server...

if you are asking me about this article

http://www.sqlservercentral.com/articles/Monitoring/61373/

you stop the dts packages in the sql agent scheduler....the data it's pulling is always there in sql in the...

I've just been working with DTS today on a very similar problem. Instead of prompting for input, i've been hard coding the column that I want added to the...

check your date format. I you run the code

select

CAST(DATEADD(hh, -3, GETDATE()) AS VARCHAR)

you get

Jan 30 2008 9:42AM

When you manually run it above you are using...

In general you want to make sure you use bulk logging during any data loads and optionally drop the indexes just before the load then readd them after the load.....another...

I'm not well versed in vm, but it seems to me you lose the ability to control the physical location of important database components like log files and the ability...

I have not used that one, but I have just implemented this

http://www.sqlservercentral.com/articles/Monitoring/61373/

and am loving it. My oltp database is showing basically no performance degradation from running...

yes, but with limited functionality

Here's the list of things you can't do with reporting services in sql server express:

Scheduled report processing, caching, snapshots, subscriptions, and delivery are not supported.

Analysis Services,...

http://weblogs.sqlteam.com/billg/archive/2007/10/31/Login-Events-include-Pooled-Connections.aspx

Even without pooled connections, finding the true number of real logins for a database is very confusing. @@connections reportedly shows connections by users and applications and I...

anyone using a raw file system with sql 2005? We used this with Informix with good success, but it was a recommended by the informix folks to do this......

1)...

Here's a nice intro article on synonyms

http://www.developer.com/db/article.php/3613301

Nice article. I just implemented the server stats portion of this today. It's working fine. I've been looking for a good historical performance monitor for my databases....