It will be good for you to start through Analysis Services step by step Tutorials. These are installed with your analysis services.

The main point is to create some system stored procedures in all new created databases at database creation time. Currently these system stored procedures are created at the time whenever...

It works for other owners but does not work for sys.

I require to create system stored procedures like that of sp_creatediagram and sp_helpdiagramdefinition. These are created later when you start working on diagram of any database for first time. I...

I want few stored procedures to be created in every new database. I created these procedures in model database. But as i create new database the said procedures are not...

I want to define some objects in model database, so that each new database may contain them. Creating the objects as user object in model database is not working. How...

thanks for the help, the reason to get me confuse was that function db_name(dbid) was not providing me name of any db. So now i have got it.

I am trying to get cache objects as we get through syscacheobjects in SS2000. There we have dbid for databases to which the cache object belongs.

Are you facing problem for writing a trigger or for implementing logic in it?

I think you may use trigger to easily implement this logic. Any ready made method is not available.

As long as SQL Server is running you can not delete the database. Simply set it to single user mode and restore it with over write option enabled. You will...

For changing fro example adventureworks in to single user mode

ALTER DATABASE adventureworks SET SINGLE_USER

and for again to multi user mode

ALTER DATABASE adventureworks SET MULTI_USER

Please check these one by one for space

sp_msforeachdb 'dbcc showfilestats'

GO

sp_msforeachdb 'sp_spaceused'

GO

sp_databases

GO

You can restore a database by just using .bak file / (backup file). To attach a database you need .mdf - .ldf files.

usually a graphical execution plan is read from right to left and top to bottom. Scans are bad and seeks are good. there are two types of execution plans

Estimated (generated...