do you have to use a ## table, could you not just use a # table?

you would want to build a query up which looks at sys.dm_exec_requests and cross applies it to sys.dm_exec_sql_text where the sys.dm_exec_requests.total_elapsed_time is greater than the number of seconds what you...

take a look at this link http://msdn.microsoft.com/en-us/library/ms188902.aspx, should give you what you need

maybe this url will help here

duplicate posts, please post replies here

Probably work out cheaper to go CPU then if your installing SQL Standard SSRS, if Enterprise SSRS CAL will probably work out cheaper in the short term, but as more...

So you have no licences what so ever? Or only CPU licences?

Question 1

In your instance, are the reports...

Your welcome, if you can answer the questions in my post, we will be able to tell you which is the best way to licence SSRS for you.

take a look at the offical 70-432 book here

this is the book i used to pass 70-432, it has a range of things in which you can try out on...

is there a trust in place between the two domains?

have users from bb.cba.com been granted access in SSRS to see the folders and reports that they need to?

you would have to build into the query a where statement for run_requested_date in the activity table which brings back the top row when ordered desc to ensure its the...

i'm working on just that

this should help you get off on the right foot

CREATE TABLE DB.DatabaseFileUsage

(

ID BIGINT IDENTITY(1,1),

DatabaseName SYSNAME,

FileID INT,

FileSizeMB DECIMAL(18,2),

SpaceUsedMB DECIMAL(18,2),

FreeSpaceMB DECIMAL(18,2),

LogicalName SYSNAME,

FileLocation SYSNAME,

DateCollected DATE DEFAULT GETDATE(),

CONSTRAINT PK_DB_DatabaseFileUsage PRIMARY...

has the SQL Agent account been granted access to the profile you have created?

granted it should do this itself when you configure SQL Alert System profile but I have seen...

If you install SSRS on your web server then yes you will need a licence for this.

For example I have 5 servers in my data warehouse environment, one which is...

do these mobile phone/electronic swipe cards login to the database themselves?

or do they need to be swiped through a machine and that one machine connects to the database?