Can you view the properties of the folder “'c:\Program Files\Microsoft SQL Server 2008 Express\MSRS10.P4SCREAMER\Reporting Services\ReportManager\” via Windows Explorer?

If so, check which users and groups have access to the folder, and...

Hello,

The requirements are detailed here:-

http://msdn.microsoft.com/en-us/library/ms143506.aspx

You will notice that it depends on the version of SQL Server that you are installing.

Regards,

John Marsh

Hello,

Restarting the SQL Instance should help.

Then afterwards you can investigate the root cause of the issue e.g. if you need to re-size your tempdb’s log file.

May be take a...

Hello,

One possible option to try would be to not use the normal Snapshot Initialisation of the Transactional Replication. Instead manually copy across the table with all the columns that you...

Hello,

I am guessing that it is only a particular piece of T-SQL that you want to prevent from running on your Production Server e.g. a Stored Procedure; or do you...

Hello again,

XML Should be visible if you surround it with the "Code" tags. Which are selectable from the IFCode option. For example:-

VisibleXML

Just to check, did you restart the Services after...

Hello,

Does the workaround mentioned in the following thread resolve your issue:-

http://social.msdn.microsoft.com/Forums/de-DE/sqlreportingservices/thread/8699009d-dd56-4a21-b2a3-440b49acab06

Regards,

John Marsh

Hello,

You are correct in thinking that the Trigger will only fire one time when inserting multiple records at once.

There is an “Inserted” table available within the Trigger that you can...

Hello,

May be take a look at the following article, especially to see if one of the comments relates to your particular scenario:-

http://blogs.msdn.com/sql_protocols/archive/2006/07/26/678596.aspx

Regards,

John Marsh

Hello again,

From the sample that you originally provided it seemed that all the columns could be calculated from the “base columns”, but may be that was just because you had...

Hello,

Does sp_databases return the data that you need?

If so it can be executed via a Linked Server e.g.

Exec MyServer1.master.dbo.sp_databases

Exec MyServer2.master.dbo.sp_databases

Regards,

John Marsh

Hello,

Could you consider using Computed Columns in this table, or are the values not always dependant?

Regards,

John Marsh

Hello Buz,

I was hoping to show that SSMS is a good friend. You can generate all sorts of useful scripts from it, which you can then cut and paste into...

Hello,

You can use SSMS to generate a conditional Drop Table Script.

Right Click on the Table in the Object Explorer window and select “Script Table as …”, “Drop to …”

SSMS...

Hello,

A few things to check:-

1) Can you Ping the Server from the Client?

2) Can you Login locally to the SQL Server using the User/Password combination?

3) Are there any relevant login...