Viewing 15 posts - 226 through 240 (of 280 total)
You could use BULK INSERT instead, together with a format file (create using bcp utility). Save the Excel file as .csv first.
e.g. at the command line...
bcp Database..Table format nul...
January 16, 2012 at 7:06 am
Your problem is right there, declaring tag image as varchar(8000). It needs to be type varbinary(max) or image, as you say. As far as I am aware there...
January 13, 2012 at 11:32 am
Your problem is right there, declaring tag image as varchar(8000). It needs to be type varbinary(max) or image, as you say. As far as I am aware there...
January 13, 2012 at 11:32 am
There doesn't seem to be much wrong with your second snippet, though I'm not sure why you're using an outer join - you don't want nulls included surely?
The first snippet...
January 13, 2012 at 10:48 am
There doesn't seem to be much wrong with your second snippet, though I'm not sure why you're using an outer join - you don't want nulls included surely?
The first snippet...
January 13, 2012 at 10:48 am
Images can be stored as varbinary(max) data type.
e.g.
DECLARE @myTempVar varbinary(max)
SET @myTempVar =
SELECT * FROM OPENROWSET(BULK 'X:\path\image.ext', SINGLE_BLOB)
January 13, 2012 at 9:50 am
I've done something similar using a mishmash of ASP, SSRS and HTML. The BASIC, BASIC steps you need (and you'll need a combination of these) are:
1. Create...
January 13, 2012 at 9:39 am
My apologies, I misunderstood your original question.
According to BOL, propagation from B to A is rarely possible...
"By default, Subscribers to transactional publications should be treated as read-only, because changes are...
January 13, 2012 at 6:54 am
ys.dm_db_mirroring_connections for mirroring, this will give you a lot of useful stats about active/passive/history of connections and parameter settings.
Check the logs on the secondary, you should see some entry there...
January 13, 2012 at 5:08 am
Please could you post the SQL queries you are currently using and the ASP code you have developed already.
First thoughts are: use the CASE/IF statement or the C#/VB.NET/whatever equivalent in...
January 13, 2012 at 4:05 am
I believe these variables will be different if you have a named, not a default, instance.
I may be wrong.
EDIT: No, I was right.
select @@servername returns... <SERVER>\<INSTANCE>
select @@servicename returns... <INSTANCE>
January 13, 2012 at 3:36 am
Use the error logs and DMVs to check the LSNs on the primary and mirror, make sure they match - it could be that you have a delay specified somewhere....
January 13, 2012 at 3:34 am
My thoughts are:
Short-term i.e. 1-2 months - £350/daily rate.
Med-term i.e. 2-6 months - £250/daily rate.
Long-term i.e. salaried position - £30-40k or £16-18ph
If these numbers seem high, bear in mind that...
January 13, 2012 at 3:29 am
Got it! Many thanks to Dan Lloyd - I'm using double quotes in the VALUES in SQL rather than single quotes. So SQL was taking the values as...
December 30, 2011 at 3:48 am
I've just run the query directly against the DB, the same message appears:
Msg 103, Level 15, State 4, Line 1
The identifier that starts with 'Lorem ipsum dolor sit amet, consectetur...
December 30, 2011 at 3:33 am
Viewing 15 posts - 226 through 240 (of 280 total)