Browse by Tags

All Tags » SQL (RSS)

StreamInsight Error - AuthorizationManager Check Failed by rachitp

In order to learn the complex event processing , I have started looking into Microsoft StreamInsight lately. My first impressions of the StreamInsight is so far good and it looks promising. To the point of this post, I downloaded the StreamInsight example...

Unable to open the physical file - Access is denied by rachitp

I’m an using Admin account on Windows 7 and try to attach umbraco database to my local SQL 2008 R2 instance. I’m getting the following error: Unable to open the physical file "D:\Tech\umbraco\build\App_Data\umbraco.mdf". Operating system error...

Missing Microsoft.SqlServer.SmoEnum Dll by rachitp

I like this SSB (Sql Server Broker) Admin tool but every time I refer this to somebody they come back to me with the questions that some of the DLLs are missing and they can’t launch the application. You should be able to find all the missing Dlls on...

SQL Server Power Tools by rachitp

The SSMS Tools Pack is a “must have” for any developer who works with the SQL Server 2005 and above. I thank a lot Mladen for making this tool available. Go give it a try! http://www.ssmstoolspack.com

Better error message please...SQL Error '...is not a recognized table hints option' by rachitp

I was getting the following error in a stored procedure that I had written. Nothing fancy in it as far as concern with using any new features of SQL 2005. Msg 321, Level 15, State 1, Line 5 "sql_handle" is not a recognized table hints option . If it is...
Filed under:

Change Server Url in Email for Reporting Services by rachitp

When you schedule something to run in the Reporting Services and when the report gets emailed to the requestors, by default, in the email, you'll see http://servername/reportserver/report.... So what happens that if you are on the network (which is most...
Filed under: ,

Learning SQL Server Broker by rachitp

Working on some project, I have started delving a lot with Microsoft SQL Server Broker for 2005. I can see that the initial learning curve is very very steep and it's very easy to give up on SSB initially. But if you are like myself, learning SSB, be...
Filed under: , ,

Search in All Stored Procedures Views by rachitp

For me, the following SQL syntax turned out very handy when I wanted to see where either a table or a view or a stored procedure is being referenced. I've so many stored procedures in one of the database(used/created by other users) and it became hard...
Filed under:
More Posts