Not through the GUI, no. But there are various T-SQL statements for interrogating permissions too, e.g.

select *

from sys.database_permissions dp

inner join sys.database_principals p on p.principal_id = dp.grantee_principal_id

where class_desc =...

Hi,

database user properties > securables tab > Search... > All Object of the types... > Databases > Voila!

Although I'd look at using the db_datareader database role instead if possible, it's...

Not 100%, but some sys views only refresh on a SQL restart - could be that the extraneous counter will vanish then.

Hi,

Sounds like more a problem with the insert into Match_Reports table than replication per se.

Have a look at the definition of dbo.p_MatchMaker_PrepHistReports (it looks truncated in the error message/your post)...

Well, if you can get the information out of the file, registered servers are stored in

C:\Users\username\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml

But I'd be much more tempted to set up my own text file...

Dropping NC indexes can obviously reduce space used, and rebuilds of clustered indexes or heaps can also reclaim space.

Are either of these likely to have happened?

Also I notice the query...

Thanks Grant, looking forward to reading this.

No problem!

If you've got SQL Express with Advanced Services it's included.

To check you have this version - your install file should be called SQLEXPRADV_x64_ENU.exe or SQLEXPRADV_x86_ENU.exe

In the SQL installer, it's listed...

Not a bad question, but I might have answered S,S,F if it had been an option - no mention of default schema or rights on dbo schema.

No, it's a standalone product. If it's installed it will be in the SQL Server 2008 (or 2008 R2 if you're using that) folder on your start menu as "SQL...

Hi, for report development you need BIDS (Business Intelligence Development Studio) which is based on Visual Studio Shell.

It can be installed as part of the SQL Server installation if you...

No worries! 🙂

Hi,

Multi-valued parameters can't be NULL as far as I know, no value supplied gives a parameter value of blank rather than NULL.

Try this expression:

=iif(Join(Parameters!uidIncidentTypeId.Value) = "", Fields!vchParentIncidentType.Value, Fields!vchIncidentType.Value)

Cheers

Gaz

Hi Markus,

Does SQL Agent have the Mail profile enabled & the correct profile selected (Alert System page)?

Think you need to restart SQL Agent service for any changes to take too.

Cheers

Gaz