Viewing 15 posts - 16,786 through 16,800 (of 39,970 total)
It works fine here in FF, Chrome, and IE 8.
This page isn't any different than any of our other pages from what I see. There are flash items and images,...
March 7, 2011 at 11:42 am
They work for me. If they are returning 0, then you have 0 bytes, no space in the field/row.
March 7, 2011 at 11:40 am
LEN ignores trailing spaces. A single space is a trailing space
http://msdn.microsoft.com/en-us/library/ms190329%28v=SQL.100%29.aspx
Use DataLength instead.
http://msdn.microsoft.com/en-us/library/ms173486%28v=SQL.100%29.aspx
March 7, 2011 at 11:01 am
The code above is good if you know how many rows you'll get. If not, you might look up PIVOT or cross tab queries to see if they help.
March 7, 2011 at 9:59 am
Could be a bad plan, maybe some parameter sniffing, or even something else.
Did you read this? http://www.sqlservercentral.com/redirect/articles/72634/
March 7, 2011 at 9:58 am
Are you trying to append to a file? Or perhaps permissions? This is an OS level error bubbling up. Either paths are wrong, permissions are wrong, or maybe the file...
March 7, 2011 at 9:58 am
This isn't quite clear. Are you saying that you have full backups of multiple databases in a folder and you want to restore these backups to new copies of the...
March 7, 2011 at 9:56 am
So I'm slightly confused. You have marked the two rows as duplicates with separate conditions, but the second one doesn't make sense. Are there other duplicates? In this set, which...
March 7, 2011 at 9:52 am
Out of my area, but I'll ask a few people if they know and get you an answer. Glad it's working.
March 7, 2011 at 9:49 am
Not according to the error you posted. The provider is named pipes.
Can you explain better what your setup is?
March 7, 2011 at 9:41 am
TRUNCATE TABLE: http://msdn.microsoft.com/en-us/library/ms177570%28v=SQL.100%29.aspx
From the permission section: The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role,...
March 7, 2011 at 9:39 am
I ran this:
CREATE TABLE TRLC
(
est_no varchar(10) default ' '
, right_no int default 0
, maj_auth varchar(15) default ' '
, [weight] varchar(10) default ' '
, idm_ht varchar(8) default '...
March 7, 2011 at 9:32 am
Just File | Open.
Is this stored in SQL Server or the file system?
March 7, 2011 at 9:25 am
Is your client on the same machine as the server? Can you switch to TCP/IP instead? I am not sure, but it seems there was some issue with named pipes...
March 7, 2011 at 9:22 am
Viewing 15 posts - 16,786 through 16,800 (of 39,970 total)