if you are using sql server managemnt studio.. And u want to create basic tables.. coding is not required.. u just have to play with the tool.. google how to...

ID Hid Hid Name ...

Ahh... That makes it more clear.. Now try it again Poornima..!!:-)

I can see this msg...

I believe u should also have thorough understanding on relationships and length, size of the variables. They cost u a lot when it comes to the performance.

Exactly, it says the same.. But I couldn't find where it is.. Am i supposed to write the whole convert function dynamically???

Sean, Have a look at my complete code

USE msdb

declare @dbname varchar(50);

declare @sql nvarchar(MAX)='';

declare @AsOfDate datetime = convert(datetime, '12/31/2012');

declare @orgid int = 0;

declare @assets money = 0.00;

declare @liabilities money = 0.00;

declare...

Poornima,

That might be because of the partially or wrongly installed programs of Mgmt studio you tried before.. Go to control panel and try to uninstall all the previous...

Thankyou for sharing the information.... I figured it today... 🙂

Any better replies?????

I couldn't figure out how do i add a query to sql server agent and...

Thanks for the information. Yes the recipients are all aware, This is just to send them one or two column query results so that they can work on the effected...

Now How do I do it automatically evrynight.. I dont have to run the query again and again

It should run by its self at the end of the day...

USE msdb

GO

EXEC sp_send_dbmail @profile_name='prathibha',

@recipients='prathibha_aviator@abc.com',

@subject='Unbalanced Accounts',

@body='',

@query='select * from CNAccounting_Joliet_2013.dbo.employee',

@execute_query_database= 'CNAccounting_Joliet_2013',

@attach_query_result_as_file= 1,

@query_attachment_filename= 'Results'

Is this right??? My intention is just to give the query results as an attached file

So My data base is DB1

I have some 120 tables in that

I have one particular table which is oraganization

My job is to run a query "select * from organization"

and the...