MSSQLTips

We are having problem with ASPState database, which have one ASPState_Startup proc which suppose to create 2 temp table in tempdb whenever SQL server start. Somehow this proc does not create those tables. I checked "scan for startup" and it is configured 1, also make sure that "ASPState_Startup"...

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

How to write stored procedures in SQL Server? Please Send the Description with examples of stored procedures. How many types of stored procedures are there in SQL Server for INSERT,UPDATE,DELETE? How to call procedures?