Recent content by dddenney

You can add them to the SQLAgentReaderRole database role in the MSDB database. HTH, Dan

SQL Server 2008 Developer Edition does come with SSIS (although, its possible it wasn't selected during the install). It also sounds like Visual Studio Business Intelligence Development Studio (BIDS) wasn't install either. As long as you have the install files you can still install the...

Is there a way to deploy a custom web page created in SharePoint designer on a development SharePoint server to our production SharePoint server? We are using WSS 3.0 and Sql 2005. Thanks in advance, Dan

I need to figure out a way to pull a random sample of 5 calls per day per user. TableA (ID INT, UserID INT, CallDate DATETIME, CallDesc VARCHAR(100)) So far: select userid, callDesc from TableA where callDate between yesterday and today order by NEWID() But how can I pull just 5 recs per...

Thanks Jay. Most of our reporting services reports are actually hitting an Oracle database on the backend. One of our report developers thought that Reporting Services would only allow so many active reports to run at the same, before reports started getting queued pending completion of...

I was wondering if anyone knew if there was a limit on the number of reports run through Reporting Services (both scheduled and user run), before it either starts queueing reports or something else. Or is there even a limit (other than resources)? This is for Sql Server Standard 2005 SP2...

A little background: I am not in the habit of modifying system stored procedures, but this particular Sql 2005 server is used by a third party tool. The problem is that the client app for this tool uses the sp_addlogin system SP to create logins on the server. However, the password it is...

I am trying to modify the system stored procedure sp_addlogin, but getting the following error: "Msg 208, Level 16, State 6, Procedure sp_addlogin, Line 73 Invalid object name 'sys.sp_addlogin'." I can obviously see and open the stored procedure in Management Studio but not alter it using the...

Thank you! I'm not sure why I didn't think of that in the first place.

Is it possible to execute a store procedure from with in a query? Example of what I would like to do: select emp_id, last_name, first_name, (exec sp_Get_Overall_Incentive_Score @emp_id = em.emp_id) as score from employee_master as em where term = 0 Thanks in advance for the help, Dan

Thanks SQLBill, that did the trick.

I have the following SP I am trying to create... create Proc procDirectoryFilter ( @Filter nvarchar(1) ) AS ( SELECT * FROM Users WHERE SUBSTRING(LOWER(LName), 1, 1)=@Filter ORDER BY LName ) Everytime I try to compile it in Query Analyzer, it...

Thanks again gradley. This will be a huge help. I'll make sure to read up on the Information_Schema info. Thanks!

Any way to print out a list of all the stored procedures (and there parameters if possible)? I'm taking over for someone who didn't leave any documentation.

Thanks gradley! Exactly what I needed.