Hi bryan,

I tried this with sql developer 2000 without any problem. I am afraid that the beer is no longer cold when it arives.

best regards,

Klaas-Jan

Hi,

declare @strTable varchar(100)

declare @strsql varchar(1000)

declare cur_del cursor

read_only

for select

O.[name] as tablename

from syscolumns C inner join sysobjects O on C.id=O.id

and O.type='U'

where C.[name]='ida'

open cur_del

fetch next from cur_del into @strTable

while @@fetch_status =...

Hi, ok so you want windows authentification with a password. I don't think that is possible. Maybe one of the guru's has found a way?

Hi,

if (select object_id('tempdb.dbo.#test'))

is not null

print 'test'

Right click the server and in properties you can select windows authentification or sql. When using sql you can check always promt for password.

You can use both ado.net and xpath queries. In ado.net you have more functionality.

select * from orders where shipregion is not null

Hi, what about wa in iis and have a sql user for connection from iis to the database. For vb or access applications we usualy make one sql login the...

Hi for xp_cmdshell you need administrator rights.

Hi add a varchar field with different values and use a where clause to search a record. Also a join with a new table is bad for performance.

Hi i think you don't need the 3 part syntacs in the insirt into. in stead of FROM rmtdb.dbo.rmttbl you could just use rmttbl. You already have a openquery so...

Hi you can schedule the dts packages or put them in a job. If the filenames are dynamic you have to write some active scripting (there are samples on this...

Hi i found out that there is a problem with ado connecting to temp tables. Temp tables only exists in a connection. After the connection they are automaticly dropped. Somehow...

Hi, you where right i had asumed it worked for alter view as well. My excusses. If you assign create view rights to a user then he can alter the...

HI, according to bol for altering views the same permissions as the create view aply. You can give a user ( or a role) create view rights with:

grant create view...