I want to trace the all information of which user is doing what kind of work in MSSQL environment.. it's a kind of user log history..

Currently i am using express edition

but if i want to switch it then will express edition backup get restore in enterprises edition?

It's working 🙂 i forgot to give a front and back space

Yes i tried it

Yes i tried it before asking you this doubt but

it is returning collegename

Rizvi Institute of Management Studies And Research, Mumbai -

i don't want dash(-) also

Use Rownumber() it will create a virtual column of separate id for each row.. then by using that id you can update any duplicate record.

and its bad practice if your...

I am sure that the update quey is fired from outside... I am using a photon to upload data in Database and ip of Pc get hacked

Installed on remote server...

How can i extend date of expiry??????

OR

Please tell the solution if you have any ...

I checked there in Help -> About ->

but it doesn't mentioned the date i got the below informtion

Microsoft SQL Server Management Studio:10.50.2500.0

Microsoft Data Access Components (MDAC) :3.85.1117

Microsoft MSXML:2.6 3.0 5.0...

Some trial versions has expiry date which are downloaded from internet.

after 102 days or 120 days the version get expired...

So i wanted to know the free downloaded version expiration date...

Yes .... Problem get solved by adding port ...:)

Thank u very much

Yes i am connecting to right ip address......

actually when i was working on MSSQL2005 ..

ICS started after setting.

don't know why 2008R2 giving a problem...!!!!!!!!!!!

Univ_streamRelation is not exist in source ..

I am connecting both server database via SQL Authentication

I imported one table on other server it done successfully.

but now if i tried to import whole database on other server it's showing error :-

Messages

Error 0xc0202009: Source 322 - Univ_streamRelation...

is there need to have or to exist a table in database where we are transfering data??