Viewing 15 posts - 121 through 135 (of 349 total)
A second business unit is still receiving this same error.. (trying to create a PULL SUBSCRIPTION):
error: Could not connect to server 'MyServer\MyInstance' because 'MyServer\MyInstance' is not defined as a...
August 2, 2011 at 5:20 am
The space in the path directory name is fine. I had a very similar issue back in Aug 2009 (found my own post when I googled this issue...
July 25, 2011 at 10:33 am
thx for your reply Ron.. I'm a SQL Server DBA w/ little knowledge of MS-Access (forms, macros, commands, reports, etc) I was tapped to assist w/ this issue.....
July 15, 2011 at 11:55 am
correction... (on 3rd statement -- I avoided REGENERATING THE MASTER KEY and used the old one.. this fixed our issue)
OPEN MASTER KEY DECRYPTION BY PASSWORD = <Password>
ALTER MASTER...
July 15, 2011 at 10:25 am
Resolved... I used this solution to resolve:
http://www.sqlservercentral.com/Forums/Topic629972-359-2.aspx#bm960265
USE your_database
GO
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'your_old_sourcedb_master_key'
ALTER MASTER KEY DROP ENCRYPTION BY SERVICE MASTER KEY;
ALTER MASTER KEY REGENERATE...
July 15, 2011 at 10:12 am
We too had an issue with this. We installed SQL Server 2008 R2 w/ sp1 onto the D: drive in a 2 node cluster and encountered error when generating...
July 9, 2011 at 5:54 am
Craig - here is an interesting post on a SQL 2008 Data Compression benchmark. http://www.sqlservercentral.com/blogs/glennberry/archive/2010/02/22/experiments-with-data-compression-in-sql-server-2008.aspx
Due to extreme time limitations on our project, I may not...
June 7, 2011 at 11:39 am
a key factor regarding optimal disk striping for the new Minerva SQL Server SAN disk -- general recommendation is for SQL Server 2008 --- 256k stripe size. This is...
May 31, 2011 at 12:38 pm
a key factor regarding optimal disk striping for the new Minerva SQL Server SAN disk -- general recommendation is for SQL Server 2008 R2 --- 256k stripe size. This...
May 31, 2011 at 12:34 pm
the performance gained in READ I/O is substantial.. many less pages to READ thru during SELECT/UPDATE/DELETE processing.. and from what I understand, only qualifying pages are un-compressed at READ time......
May 31, 2011 at 9:49 am
thx for this feedback.. we are using EMC VNX. We've been granted a ton of space.. 10 TB for a 4 TB need.. and we have not implemented SQL...
May 31, 2011 at 9:35 am
We have the same questions as listed above. We are planning on implementing the 256k stripe architecture for SQL Server 2008 R2 recommendation -- definitely for our SQLUserData drive...
May 31, 2011 at 8:46 am
thx. yes, I already had that checkbox marked.. (Retain null values from the source as null values in the data flow)
The problem resides w/ the input record...
September 17, 2010 at 6:57 am
Resolution: I had originally bookmarked my RS page when it was displaying w/ ViewMode=Detail -- like this:
http://myserver/Reports_myinstance/Pages/Folder.aspx?ViewMode=Detail
I modified my bookmark to use ViewMode=List -- like this:
http://myserver/Reports_myinstance/Pages/Folder.aspx?ViewMode=List
July 8, 2010 at 5:26 am
thanks. your feedback helped resolve my issue.
much appreciated..
June 3, 2010 at 8:57 am
Viewing 15 posts - 121 through 135 (of 349 total)