Viewing 15 posts - 1,111 through 1,125 (of 1,220 total)
1. correct
2. specify the text/image column as being in an article (same as for any other column) - you mightneed to set the "max text repl size Option" depending on...
June 22, 2005 at 9:19 pm
Try the following :
SELECT 'Dear ' + n.FirstName AS Salutation,
'RE: BOVINE TB STATUS OF YOUR HERD NUMBER ' + CONVERT(varchar, n.HerdId) AS Regarding,
'This letter is to advise...
June 7, 2005 at 10:02 pm
Have a look at the SQL Server Log. Shortly after SQL starts, it writes a record into this log that looks like
Server Process ID is 3936.
This is the value...
June 2, 2005 at 9:45 pm
Only the new articles will be snapshot created for existing subscribers.
May 30, 2005 at 9:38 pm
By default, transactional replication does not send changes back to the publishing database.
However, allowing users to update the replica may introduce problems that you will need to deal...
May 30, 2005 at 9:36 pm
I have seen this sort of error happen occassionally even though there appears to have been no actual loss of network connectivity to the server. It was happening when...
May 23, 2005 at 9:33 pm
The most common cause for this error (for me) is when I attempt to open a package that uses the "Analysis Services Processing Task" task when the workstation I am...
May 23, 2005 at 9:28 pm
The atttachments for the send mail is simple a semi colon separated list of file names. I would create a global variable to contain the list of files and...
May 18, 2005 at 9:39 pm
vawrchar was a typo - should be varchar
May 18, 2005 at 5:08 pm
Q1 : nvarchar exists so that you can store unicode data (characters that require 2 bytes to be represented). Each character of an nvarchar column requires 2 bytes of...
May 17, 2005 at 9:53 pm
For what it is worth, Yukon does enforce all manner of password related checks based in the relevant Windows policy.
May 16, 2005 at 9:49 pm
These 2 products do not interact unless you build links between them.
Business Scorecard Accelerator is designed to use cubes to define KPI's in a structured manner. These KPI's can...
May 9, 2005 at 9:12 pm
Do you know the sa password ?
By default, members of the local administrators group on the server where SQL is installed are sql sysadmins. You could try connecting...
May 8, 2005 at 9:46 pm
SQL Server does not really know/care whether a drive is a SAN drive or SCSI or IDE etc - and this is regardless of the edition. It really only...
May 4, 2005 at 10:06 pm
Viewing 15 posts - 1,111 through 1,125 (of 1,220 total)