I actually feel that the number of recent certifications a person has is directly related to how long they've been un-employed;

I'm guilty of it myself, when one company went...

well adding a user and granting permissions are a three part process.

first you really needed to already have a ROLE in your specific database that has the permissions you want...

Now that I'm...

here's a really easy example:

--common tables between the two

SELECT name from SandBox.sys.tables

INTERSECT

SELECT name from Dictionary.sys.tables

--tables only in SandBox

SELECT name from SandBox.sys.tables

EXCEPT

SELECT name from Dictionary.sys.tables

--tables only in Dictionary

SELECT name from Dictionary.sys.tables

EXCEPT

SELECT...

i believe that's incorrect:

i'm pretty sure this code, Executed on server A would copy the entire...

if not too much time has passed, they may still be in the default trace;

there's a built in report that filters by database in SSMS:

your linked server, is it for an excel spreadsheet, or an access database?

I've never gotten Access to work in Ace / 64 bit, but i've read creating a DSN, and...

i'd consider using row_number() fo5r this one, i htink:

SELECT * FROM

(

SELECT ROW_NUMBER() OVER( PARTITION BY CustId ORDER BY[Actual Date] DESC) AS RW,

[Next],

CustId,

Customer,

[Scheduled Date],

[Actual Date],

[Last]

FROM [Customer]

) MyAlias

WHERE RW = 1

i couldn't see how to get the data filtered either;

it seemed like maybe the Nextdate, but that doesn;t match your total criteria; maybe by NextCompany,Location?

i cannot see why you want...

LinkSvrName?

I know you are obfuscating this, but you didn't provide the other information I mentioned at all.

What the name of the server you are running this code on?

Is the "remote"...

maybe this?

http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/04f9eab4-907d-400c-b15c-710fd2f972e0

SQL server tools / client components , integration services and browser are MACHINE aware - ie) 1 per machine.

SQL database engine , analysis services and reporting services are instance...

more details are needed to really help, i guess;

maybe there's a custom entry in the hosts file:

from a commandline, notepad.exe %SystemRoot%\system32\drivers\etc\hosts

in that extension-less hosts file, maybe someone has put the...

sudhirnune (4/9/2013)

---

Tanks Lowwel, it is perfectly working.

But my problem is that I may not be able to use the Global Temp table.

Can we Have the local temp / Genral table...

i edited the post, so re-copy it and try again.

the line for the global temp table should have been here:

set @query = 'SELECT name, ' + @cols2 + ' ...

i guess something like this, where you insert into ##GlobalTable would give you the results as a table so you can update from it later.

DECLARE @cols AS NVARCHAR(MAX),

@query AS NVARCHAR(MAX),

@cols2...