This was working in our older version it starts failing now so we are not sure whether its 2000 to 2005 issue or vb coding issues but the application event...

as it is hashed out I can hash the values & compare it against the database. but how will i communicate back to the application that the username as has...

yes. it is hashed out.

1. I tried to login using my domain with windows authentication from the user machine which runs windows xp. It worked.

2. I tried using a sql login from user machine....

yes. In my case the logon exists & when I try to create the user & execute as this new user to create db objects, the script as I detailed...

I can able to understand the steps. But, wat if I don't want the login password to be embedded into the script. Is there a way the login could be...

It is newid() & its not sequential. also, we have an issue of slow performance & retrieval of record from reporting environment as the primary key are GUID. hence, would...

how do you get trained in hardware, networking, security? Whether doing Comptia training is good if so what place offers evening classes in these subject areas?

excellent. this is a good place to start once I move into the production. but, is there any template i can use to justify the capacity planning during the development...

we are in the development phase for the project where we use sql server 2005. It is a transactional database which has the capacity to audit, & reporting. these transactional...

this should really help. but, i will have to wait & see if this works as i would be scheduling this next week.

Thanks, Win

nope.

My requirement is:

1. Script:

delete from table1 where userid = ?

--Comments: Here ? = dynamically passed parameter

2. Create a new job in SQL Server Agent and put the above script as...

Thanks, Lynn.

Yes. This is a solution.

yup. this won't work.

select 'First', 'Second', 'Third' union all

select 'Apple',null,'Banana' union all

select 'Vista', null, null union all

select null,'Water',null union all

select null,null,'Coke';

select db_name(), b.name as username,a.name as login

from master.dbo.syslogins a, sysusers b

where a.sid = b.sid and b.issqluser = 1

The above query was very useful for my scenario. I also added issqluser...