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):-...
Satya, 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...
Guys, I have simple question, Can we create a tranactional (or any sort of) replication on SSRS databases. i.e. ReportServer, ReportServerTempDB....
Mohammad, Here is the output of xp_msver stored procedure:- 1ProductNameNULLMicrosoft SQL Server 2ProductVersion5898249.00.3042.00...
Mohammed, Thanks for your efforts. I have used xp_msver stored procedure and got the same result (ProductVersion). Thanks Ehsan
Dinakar, I got it. Thanks. Ehsan
Hi, 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...
Satya, 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. Thanks...
Thanks Mohammad. Ehsan
Guys, 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.
