But for some applications, use of windows authentication just isnt possible. I think the answer you gave me is talking about normal users, I am referring to more like Java/.NEt...

From what I recall, you can leave this as SA.

Schedule the SSIS package using SQL agent and it will run under the context of the SQL Agent account.

That doesnt work, even beforeit checks the sys.databases the compiler already attempts to connect to a database that might not exists, thats where the...

Any ideas guys ?

If 2 instances are trying to read data off the table, I dont see anything that will go wrong here. please explain

Guys,

I am not looking for the next identity column, I only need the last one on the table or the MAX one.

create table #test

(

ID int identity(1,1),

code varchar(1)

)

insert into #test (code)

select...

I have a function which selects max(ID) from a table.

The column ID is an identity column, I am wondering if there is a built in function in SQL that will...

How can this be proven ?

Hi

They are stored procedures with different parameters.

Thanks for the reply, basically I have tables/stored procedures/functions/views that I need to automate the scripting for replication, there are over 700 articles. I mainly have a lookup table which...

Ok

I understand it now, so what does the SSIS task do because from what i have seen, it doesnt work properly.

What i mean is that the code will create the login in the master DB, but it will not map permissions to the user databases.

i.e grant permissions for user DB's...

I can see this, but this does not resolve permission problems though.

On a 2005, what DMVs can i use and what kind of information can I extract ?

Any work arounds guys ?