I did failure intentially to catch the errors. To answer your question, I am trying to catch both the errors generated by RESTORE VERIFYONLY FROM...
I am getting the following error message from the following piece of code (ran code in SSMS 2005):-...
I am using SQL server 2005. I am using Visual Studio Team Foundation server for .rdl deployment.
We want to replicate the .rdls files and...
I had created transactional replication, but it was messging the configuration on the target server. Then I had restored ReportServer from the old...
I have simple question, Can we create a tranactional (or any sort of) replication on SSRS databases. i.e. ReportServer, ReportServerTempDB....
Here is the output of xp_msver stored procedure:-
1ProductNameNULLMicrosoft SQL Server
Thanks for your efforts. I have used xp_msver stored procedure and got the same result (ProductVersion).
I got it.
I have installed SQL Server 2005 SP2 on my production server. I am using enterprise version of SQL Server 2005.
When I am using commande...
I am using SQL Server 2005. I know it works if I set permissions on Schemas. I was looking for to set permission on database level.
I need your help. I have created a Role "DeveloperX" I have granted "Select" and "Execute" permission.
Now Some of the stored procedures are...
Separate names with a comma.