Viewing 15 posts - 6,361 through 6,375 (of 7,164 total)
opc.three (5/23/2011)
Closed "as Won't Fix" with the reason being "Backward Compatibility Issues"...Booooo!
I guess we can officially call STUFF a...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 5:50 pm
dankwart menor (5/23/2011)
Thanks, that is working exquisitely
Excellent! I love it when a plan comes together 😀
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 5:43 pm
Craig Farrell (5/23/2011)
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 4:47 pm
Closed "as Won't Fix" with the reason being "Backward Compatibility Issues"...Booooo!
I guess we can officially call STUFF a legacy...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 4:29 pm
Query Analyzer only returns the first 256 characters of a column by default. You can increase it to a maximum of 8192 in:
Tools > Options > Results Tab
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 3:47 pm
You're very welcome.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 3:43 pm
Unfortunately you will not be able to have an actual "#" appear in your element name. It is not supported in the SQL Server implementation of XML...i.e. it must be...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 3:07 pm
Your decimal to hex conversion needs some work 😉
x35 = decimal 53 = the number 5 on the ascii map
x23 = decimal 35 = the hash sign on the ascii...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 2:46 pm
Are they fixed width files or delimited?
If fixed you can seek to the end of the file and then seek back this number of bytes:
10 * ([bytes in each row]...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 1:34 pm
A try/catch structure around the code you think may be having an issue would be a wise move to capture and output the error message.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 12:17 pm
How are you connecting to the remote server? Windows Authentication? If yes, make sure the Windows login running the SQL Agent job (Windows service account or proxy account) can connect...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 12:16 pm
I bought a Kindle about two months ago because of the issues with backlit tablets interrupting melatonin production (i.e. interfering with sleep patterns). I wish it had a browser sometimes...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 11:42 am
Direct all replies here:
http://www.sqlservercentral.com/Forums/Topic1113404-364-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 11:26 am
Sounds like a DENY may be in place.
What does this return?
USE [DBname]
GO
SELECT perms.*,
users.name
FROM sys.database_permissions perms
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 11:23 am
armm1388 (5/22/2011)
hi'In a database project which use of pictures, Is it better to save pictures in database or to file?
thanks very much
It depends on many things. FILESTREAM is an option....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 23, 2011 at 11:13 am
Viewing 15 posts - 6,361 through 6,375 (of 7,164 total)