Be made using this security context

Remote login: sa

With password: sa_password

I have set up the linked server with sa password

It is there

But I get the error message

Maybe it is becase sa of this server, does not have the permission to GRANT SELECT on an object in some other server

Yes it runs successfully

I already have set up the linked server

Many thanks to you 🙂

Maybe the sql service is not started

Right Click on My Comuter, then click on Manage then Services and Applications and then Services

You should see a "Sql Server" in the list...

I have the upgrade advisor installed on a server, but I still get the same errors

I want to upgrade from sql 2000 to 2008

I get errors like:

method not found 'system.collections.generic.ienumerable`1<Microsoft.SqlServer.Management.SqlParser.Parser.Error>

Can...

I have the upgrade advisor installed on a server, but I still get the same errors

I want to upgrade from sql 2000 to 2008

I get errors like:

method not found 'system.collections.generic.ienumerable`1<Microsoft.SqlServer.Management.SqlParser.Parser.Error>

Can...

It helped me a lot after 5 years!

Now, I checked what I had in "Data Transformation Services" >> "Meta Data Services Packages"

I removed all the objects there, since they were...

Thanks a lot for your advice

There was a warning on "Data Transformation Services"

Now, I checked what I had in "Data Transformation Services" >> "Meta Data Services Packages"

I removed all the...

Do u have the sample program which handles ADO InfoMessage event?

Or can u send me a sample of using :OUT (complete command) please?

sqlcmd -S servername\instanceName -i inputfile -o outputfile

inputfile contains the sql query

outputfile: The output goes here, but the results tab output and messages pad are both included

I need the one in...

sqlcmd -S servername\instanceName -i inputfile -o outputfile

inputfile contains the sql query

outputfile: The output goes here, but the results tab output and messages pad are both included

I need the one...

Yes, exactly

Any solution?