Have you started the endpoint? It may be in a state of disabled and therefore not able to respond to requests.

This should do the trick. All you have to do is load some table variables with the name of tables you want created and the assoicated columns. This...

Create a linked server and query the two like you would normally. A linked server requires a 4 part name though.

Server.Database.Table.Column

You could use this query to see if the backup finished properly and is not damaged.

select a.database_name,b.physical_device_name,is_damaged, backup_start_date, backup_finish_date

from msdb..backupset a

join msdb..backupmediafamily b on a.media_set_id=b.media_set_id

where database_name like 'AdventureWorks'...

Pivot Tables limit what you can do dynamically, but I have modified my original post to meet your specification of displaying the data and having the user put in a...

This method uses pivot tables:

/*

==========================

Expected Output

==========================

Jan Feb Mar Apr May

Hired 3 0 2 0 0

Terminated 0 1 0 1 0

# of Employees 3 3 4 4 3

*/

DECLARE...

Are you trying to convert PatientNo to an Int? It has letters in it, so you cant convert it to an integer.

This produces the same error:

declare @var1 nvarchar(10)

set @var1...

Just as a note in SQL Server 2005 you have canned reports. One of which is "disk usage by top tables".

Just right click on the database --> reports -->...

the other method is actually sp_executesql, which is better because it lets you reuse execution plans and has better parameter capabilities.

more info here:

http://msdn2.microsoft.com/en-us/library/ms175170.aspx

A table named cannot be named dynamically via variable unless you use exec or sql_execute

declare @sql nvarchar(max)

set @sql = N' SELECT COUNT(*) FROM ' + @Tablename

exec (@sql)

You could try to do a simple convert, like such:

SELECT count(CONVERT(smallmoney,cost))

nabaj,

char(13) = carriage return

char(10) = line feed

This basically like hitting the enter key to create a new line or a line break.

Matt,

In the begining of the post we made some modifications to Jason's script to meet the users needs. We changed:

SELECT *

FROM ...

Nice one Jeff. I am adding this one to my toolbelt. 😀