Viewing 15 posts - 31 through 45 (of 80 total)
Sorry, I've never heard of "servername@dbname" being a connection string for the native SQL Server connections. So I'm still blank on this.
==> this works anyway
Let me ask this, where are...
September 11, 2012 at 4:59 am
Hi,
via native sql server connectivity: servername@dbname and now, in new server, there is Sql 2012 client installed by a third party and it does not read one of the...
September 11, 2012 at 4:31 am
OK,
thank you for the info. I'll just let it run then and hope it finishes in time before the normal JOB routines start
ville
August 22, 2012 at 8:29 am
Hi,
the wait_type is 'PAGEIOLATCH_EX' and the reads, writes, logical_reads are changing all the time...
so does this meant that it is actually deleting but it just takes a long time...?
v
August 22, 2012 at 8:22 am
Hi,
just adding more info here
Like I said my Windows account have complete rights to the remote share, where the DTSX and CSV reside
1. I cannot even run the package from...
January 19, 2012 at 12:28 am
FYI
The name of the DBF file must be of old dos 8.3 format....
v
September 22, 2011 at 11:53 am
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...
September 20, 2011 at 4:13 am
Thanks, good to know the T-Sql way as well even though I already implemented this with SSIS
v
September 4, 2011 at 10:54 pm
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 (<...
August 25, 2011 at 1:00 pm
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...
August 24, 2011 at 3:06 am
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...
August 23, 2011 at 2:15 am
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
November 12, 2010 at 3:45 am
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...
September 22, 2010 at 11:32 pm
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...
February 4, 2010 at 4:41 am
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...
February 3, 2010 at 10:22 am
Viewing 15 posts - 31 through 45 (of 80 total)