Make use of Un Documented

sp_MSForEachDB

and

sp_MSForEachTable

EXEC sp_MSForeachdb 'SELECT * FROM ?.INFORMATION_SCHEMA.TABLES'

The ? is a way to represent the name of the database. This returns multiple result sets, but...

Hope you know that there is one More system database called Resource Db

http://technet.microsoft.com/en-us/library/ms190940.aspx%5B/url%5D

that is required in the Path

d:\Program Files\Microsoft SQL Server\MSSQL.19\MSSQL\DATA\mssqlsystemresource.mdf

you just need to copy...

this link is more than enough...

http://www.sqlservercentral.com/scripts/TSQL/62866/

I am curious to know that are u working for some call center....

you know where you will get then again asking questions....

you know to google it ........

History

This site was founded in March of 2001 by six DBAs that were all interested in writing about their work and helping others work with SQL Server. After a year...

hi karthik,

you are currently working In SQL Server/ In Development Programming.....

I Read your Posts all are good and Fundamental..... Nice One, But the Thing is that Is you are really...

In Excel There is one Option called Import External Data in the Data Tab In the Main Menu, Make use of One Data Source to Connect with the server.

This link will surely help you out.....:http://www.elsasoft.org/tabular/SUMMER.msdb/table_dbosysdtspackagelog.htm

You are Right.

Is There any posibility of flushing out the data from the table?

Is The Table is a Stable Table or a Transaction Table ie The table is Growing/ getting deleted as Time changes?????????

Both "not equal" operators can be used in SA 5.5 but only != works in ASE 11.5. [Top]

!= not SQL-92 standard

so You Mean to tell that certification is all waste.....

Its Quite Interesting to Answer this

well you see

you are not interested to do certification

you have very good experience

but doing certified

You surely still learn more and will get more...

Day by Day is a learning day for a DBA