Viewing 15 posts - 6,601 through 6,615 (of 7,164 total)
What about something along these lines?
SET DATEFORMAT MDY ;
DECLARE @date DATETIME ;
SET @date = '2011-03-01 13:10:29.817' ;
SELECT CONVERT(VARCHAR(30), @date, 101) +
RIGHT(CONVERT(VARCHAR(30), @date, 0), 7)...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 11:54 am
Nic-306421 (4/20/2011)
Hi Jason,Spot on, it does contain a BLOB column, I'll read through the link and code you provided and then implement that.
Indeed, nice catch!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 11:11 am
Syed Jahanzaib Bin hassan (4/20/2011)
and use this new JDBC driver 2.0 by...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 10:30 am
I am not sure how you can figure out whether your process is 32 or 64 bit.
I'm thinking it could be as simple as launching Task Manager and examining the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 10:27 am
jallmond (4/20/2011)
In this MSFT article, it clearly states that the x64 client also installs the 32-bit binaries.
That's the same article I linked to above.
So my present understanding is that the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:57 am
Nothing personal...I do have qualifications, I just don't display them on my shirt sleeve (or in my forum signature). What's in a qualification anyway?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:41 am
Syed Jahanzaib Bin hassan (4/20/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:28 am
From MSDN http://msdn.microsoft.com/en-us/library/ms131321.aspx
The x64 and Itanium versions of sqlncli.msi also install the 32-bit version of SQL Server Native Client.
You can run processes in 32-bit mode on a 64-bit server. In...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:19 am
Here's how I usually do it:
SELECT SYSTEM_USER -- should show me
EXECUTE AS LOGIN='login_to_test' -- allows me to impersonate the test login's security context
SELECT SYSTEM_USER -- should show login_to_test
-- test the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:16 am
Syed Jahanzaib Bin hassan (4/20/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:08 am
Stefan Krzywicki (4/20/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 9:01 am
It depends on whether the process is running in 32-bit or 64-bit mode. This is also true of DSNs. If you are referencing a DSN in your connection string when...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 8:50 am
I am taking CDC to mean Change Data Capture.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 20, 2011 at 1:43 am
Please don't cross post, it just fragments the conversation:
http://www.sqlservercentral.com/Forums/Topic1095501-392-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 19, 2011 at 4:56 pm
LutzM (4/19/2011)
Brandie Tarvin (4/19/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 19, 2011 at 4:34 pm
Viewing 15 posts - 6,601 through 6,615 (of 7,164 total)