I'm using a matrix report that has 3 group colums (category, productgroup, manuf) and 4 group rows (yr, qtr, mo, sales$$). Is there anyway to...
What is the best way to load an image (jpg) into the database? Thanks, ekl
Hello all, My first SSRS Matrix report and I want to show both row and column $ subtotals. Online I found info that said right click the column...
Hi all, I have a query that joins data from multiple databases. How do I setup the datasource(s) in BI for this? I setup multiple datasource, one...
SSRS running on XP with SQL 2005. I have been using SQL Report Manager for weeks and now it prompts for my login each time I try to access it. I'm...
Hi all, I modified and saved a stored procedure via EM. When I execute it from QA, it runs but without the changes, i.e. the old sproc. I...
How does SQL Server 2000 manage a situation where the "Next Run Time" overlaps the currently running job? Does it queue them up? Last night, I...
Hi all, We suspect that our production system may have been updated from outside the application -- ie. by a query. The same permissions applying...
Hi all. Does a trigger rollback if the query that caused it to trigger is cancelled? That may be a little vague so here is some additional detail:...
When I choose the import/export option on a table in Enterprise manager, the DTS Import/Export Wizard automatically fills in the option for Use SQL...
Hi, currently we set the database user permission on the objects in the database by going into Enterprise Manager -> database -> users and then for...
<br />Hi, <br /><br />we lost one of our servers and a number of sql jobs include the path to that server \oldserver. Is there a global way to...
A Job step calls a package DTSRUN /~Z0x5D.....(long number) How can I find out the name of the Local package that's being run (i.e. interpret the...
Hi all, I get an error when I try to create a Schedule to Export data to an xls file. The error says ServerProperty is not a registered function...
How can we collect user activity logs to the SQL Server? Thanks
Using sp_changedbowner to change the login user for dbo fails on a user database. The current login is no longer a valid NT login. When trying...
Seems odd but sometimes my queries return the datetime in Numeric format such as mm/dd/yy and other times in an alphanumeric format like Feb 10,...
<br />Hi all,<br /><br />I would like to create a couple of variables startdate (08/08/04 00:00) and an enddate (08/08/04 23:59) to then use in a...
<br />Hi. I am trying to capture the error code after a SELECT/INSERT/UPDATE statement but it always PRINTs 0. Here's the code snippet...<br /><br...
Is there a fast and easy way (ie one sql stmt, dbcc or system table lookup ) that will return in the number of rows in each table in a given...
Separate names with a comma.
