Browse by Tags

All Tags » SQL (RSS)

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