Viewing 15 posts - 16,651 through 16,665 (of 39,830 total)
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
Not sure, perhaps different permissions from the domain at work?
Could there be different versions of software somewhere? Is this the same OS?
March 7, 2011 at 9:21 am
That's probably true, and thanks for the comment. I suspect the companies that would be willing to do this are also the ones that are willing to invest in BI,...
March 7, 2011 at 9:08 am
Tom.Thomson (3/7/2011)
Steve Jones - SSC Editor (3/4/2011)
I would have sworn that the RAID 1+0 was 4 in Wikipedia, and I have submitted a correction.
That'll teach you not to rely on...
March 7, 2011 at 9:07 am
One quick note: we use Standard Edition.
I was hoping to use Resource Governor to tune the newsletter load and limit the impact of that process on our servers, but it's...
March 7, 2011 at 8:58 am
Congrats, Paul. I haven't read it, but I've seen some good comments around the web about it.
March 6, 2011 at 2:23 pm
Viewing 15 posts - 16,651 through 16,665 (of 39,830 total)