Jakub

You can't insert the results into a table, because the procedure returns more than one result set.  And you can't do a UNION of the results for the same reason.

As...

Neil

Create a login, say WebUser, give it access to the database, put it into a role, say WebRole, and grant WebRole execute permission on each store procedure.  You do have...

Wayne

(1) You could set up master and target servers so that all jobs are defined on one server.  Then you could combine the two jobs into one, with the execution...

You could use roles instead of assigning permissions to individual users.  Then all you need to do is assign the permissions to the role, put the new user in the role...

And what better way of doing so than calling on the help of members of this community?

Terence

Before you implement this, search for other discussions on this topic.  There is a gotcha with this type of approach.  If you will be updating this table at the publisher...

You'd have to test the impact of taking transaction log backups every 20 minutes.  I would be surprised if it had a noticeable effect on performance, though.  Don't forget that...

Happy to help - can't explain the Microsoft thing, though!

John

Jon

From Books Online:

char[(n)]

Fixed-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is n bytes. The SQL-92...

Is it possible that one of the other triggers on the table is removing the updated data?

John

The answer to your question is I don't know whether it's actually possible.  But even if it were, I wouldn't want to do it.  You'd have performance issues with transmitting...

John

Have a look at the execution plan and see if you can tell what part of the query is taking the most resources.  Do you have an index on each...

Jeff

Somehow you have changed data_type to date_type.  If it still doesn't work after you've corrected that, chances are you have a case-sensitive collation, in which case you will need to...

Private message from original poster:

Table structure  is like this..

empId,Name,Address,Salary,Hire Date,Department

Sample data:

001,Lenin,bangalore,30000,12 Sep 2004,HR

I think Avinash means to use getdate() instead of sysdate()...  Also, if...

Answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=291993