Database Access

Dear All,

I Have two SQL Server ABC and XYZ and i have changed the SA password of both the servers.

I have added link server on the both the servers.

When i execute a link server query in a SQL Query Analyser on either server it works, but when i use the same query in a job, then it fails.

So anyone can help in the above problem.

Regards,
VinayakThe sql server service accout needs to be granted authority|||Hello,

Can u help me in the same.......

Data type

Hi,
I am trying to find the data types of the fields in my table "XYZ"....Since i have 140 fields in that table, i like to store a value in INT datatype.
Does anyone it on top of their head? Really appreciate the help...

Thanks.

Do you mean a one-time query to take a peek at the data types in your table? Try this:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'yourTable'
|||Thanks. Really appreciate your help..