OK i see the problem that it was poitin ot a different server name which was recetnly renamed. So now how do i find where the wron name is listed...

no i did not setup local server as linked server and it does not allow me to do so but i can do a query using the local server name...

do you think ApexSQL or SQL Complaince managerv3.2 will give those options for me?

so how can i find who gave sysadmin previalges to X account from SSMS?

if there are any scripts already on this forum, that would be great .

just wondering if this is possible by using sys.dm_exec_query_stats . So can you please help me on how to do this, i need this for reporting purpose?

I like the idea of copying to network drive after backing to the local drive for which i have to convince my team for that.

anyways the problem is changed now.I...

say for example if i have a column for "SSN" it should appear as

in the text file.

I understand using the export wizard but how can i mask few columns?

OK, Actually i was able to export data into text files by each table using import/exp[ort wizard but i would like to get data from 10 different databases inot a...

I just want to prefix all those records as per the year which i want to do every year.

If I am prefixing numbers instead of letters it will sum the value like

update mytable empno='2004'+'.'+empno and the result is summing up 2004 + 4398586

but i want it as 2004.4398586,...

I have a table with list of indexes which should be be present in 10 different databases (similar indexes), I would like to compare indexes on a database to this...

is there a way i can get complete definition of index with list of all indexes in a database.?

does anyone have scripts ready to use for this purpose?