Check the security settings within the Report Server site and add the credentials you use with Visual Studio. Assign "System Administrator" rights to the account.

If you don't have the rights...

If you create a new AUDIT from SSMS the first window gives you the option to select the destination. The available options are "File", "Security Log" or "Application Log". When...

You can add a CASE statement and use this to assign a specific value to the row, depending on the condition. By sorting on this value in combination with a...

Hi,

I'm sorry I misunderstood your problem. I tried it by doing some testing and I was able to reproduce the error.

I created a SQL account and granted all but sysadmin...

Hi,

On the printscreen with the error message you don't have a filename entered by "Destination on disk". You do have specified a folder, but if you don't add a filename...

When clicking to the backup folder the filename for the backup is not specified and should be entered manually. You can only click to a file when this (backup-)file allready...

Easy one 😉

Allthough I got it wrong because I didn't read the whole query :blink: I forgot the " WHERE (SELECT MAX(C1) FROM dbo.T1) > C1" part.

sorry, a problem with my browser generated a double post

I guess you have a typo of some kind in the connection string. Can you access and load from the Excel file using the import/export wizard?

When you save the import/export...

And you can do this by using T-SQL:

USE [msdb]

GO

EXEC msdb.dbo.sp_detach_schedule @job_name=N'name of the job', @schedule_name='name of schedule', @delete_unused_schedule=1

GO

Unfortunate I was one of the 45% answering...

small typo in the code from Jeff Moden...

SELECT * FROM dbo.mytable WHERE CHARINDEX(@FirstName,FirstName) + 0

should be

SELECT * FROM dbo.mytable WHERE CHARINDEX(@FirstName,FirstName) > 0

:hehe:

Thanks Lowel and Chris,

Your ideas point me to some new thoughts. I think it must be possible to transfer DDL from system tabels to a central location. By joining these...

Thanks Grant,

I will look into scripting Redgate SQL Compare. I was hoping someone knew a tool that has this function built-in. That would save me quite some work.

But this will...

The most important thing is to ship a product that is working 100% correct. If not all functionality is available, swah, it can be added later. But it is very...