Hi,

problem solved. I added 'Net use ..../DELETE' as the firs command before the actual 'Net Use....'. Maybe at some point it was stuck even though the last command in the...

Thanks, good to know the T-Sql way as well even though I already implemented this with SSIS

v

Hi,

like I said earlier, I'm a newbie with varbinary-data in sql server, but what I've read recently, I wouldn't be so tight with this. When the images are small (<...

I did this with SSIS and loaded the example pictures to a varbinary column with 'Import Column' transformation. First there is a CMD that reads all JPG filenames into a...

OK, thanks, I'll use varbinary(max) instead

I was asked to store the data in DB to avoid possible access violations with SSRS usage...

I have to admid I'm new to this kind...

Hi,

as I suspected, it was about the access rights. The account they use as SqlAgent 'Log on' user did not have read access to TeraData folders...

Solved

v

It's a long time ago but I do believe that the scripts (Charles Hottle provided) did really work as I posted here. There were tens of logins and I definately...

You should always be careful with the 'NOT IN' especially when you compare to a result set of a sub-query.

Select * from table where some_attribute NOT IN (Select distinct...

Hi,

and thanks. These scripts worked. I did not compare what might have been the difference compared to the other versions I've tried.

I tested the

sp_script_login.txt worked fine when I copied a...

I already tried Transfer Logins task in SSIS but it creates the logins with random passwords according to the online help

regards, ville

Hi,

I tried the script in the middle (no comments visible about the difference in the scripts) but no luck. Password is not transferred....

Regards, ville

Hi again,

I just can't change the Data folder nor the Tmp folder for the ASServer. There is no Browse-button like the Help tells you and the fields are grayed. The...

Hi,

FYI

it worked fine, the AS database structure with all the cubes were created to the new location with the 'Restore database' but after the restart of the service the data...

Hi

I'm trying to do this for Sql2000 Analysis Services (AS) database

...already executing my plan as I described

Ville

Hi,

changing to Bulk-logged would not have helped in this scenario. Updating existing column values is always logged. You can use bulk-logged when using bcp, select * into table from table2,...