Create a DBA Repository , populate it with SSIS and you can build your reports using SSRS from your DBA Repository

check link

http://sql-ution.com/dba-repository-gather-database-size-info/

try this , u can change it and use sp_msForEachDB to loop around all databases

SELECT sc.name +'.'+ ta.name TableName

,SUM(pa.rows) RowCnt

FROM sys.tables ta

INNER JOIN sys.partitions pa

ON...

check out this link

http://stackoverflow.com/questions/4758992/how-to-insert-xml-data-into-table-in-sql-server-2005

Use Top (250,000) in your report query, have a count of records and expression to display text showing maximum records reached

Have a look at Windows Event Viewer, you will have a pretty good Idea what is causing the error

you should never backup tlogs of databases in simple recovery mode.

if you are using a T-sql script to do the backup , I suggest you exclude db's with simple recovery...

Use TRY and CATCH

BEGIN TRY

-- Table does not exist; object name resolution

-- error not caught.

SELECT * FROM...

The APPLY operator allows you to join two table expressions; the right table expression is processed every time for each row from the left table expression. the left table expression...

SQL Server will not kill or drop any connection/process unless the service is initiated for a restart or referred from the client process

A sleeping session is waiting for its next...

check the summary.txt file on directory C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

it will give you more details about the errors.

This issue is occurring because you are having a 64 bit OS and Office Excel (including most of the office products) does not have 64bit provider and hence the error...

Try something like this

SELECT *

FROM dbo.KNB_ItemCultures

WHERE CONTAINS(MyColumnName, '"*How*" OR "*to*" OR "*migrate*" OR "*reports*" OR "*between*" OR "*different*" OR "*versions*"');

DECLARE @t TABLE(city VARCHAR(1))

INSERT INTO @t(city)

VALUES ('A'),( 'B'),( 'C'),( 'A'),( 'B'),( 'C'),( 'A');

-- do a select and not the results for comparison purposes

SELECT city FROM @t

UPDATE @t

SET city =...

create a temp table and openrowset your stored procedure data into it

INSERT INTO #tmp_table

SELECT *

FROM

OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off EXEC [ServerName].dbo.[StoredProcedureName] 1,2,3')

ChrisM@Work Sergily , 🙂 Thank you guys very much, I used both your suggestions and got Desired results 😉