Viewing 14 posts - 1 through 14 (of 14 total)
save the path, file name and ext in diff column if you want to search the FN
January 21, 2009 at 7:46 pm
it will really raise an error. simply because it cannot find the cascade record referenced by the parent table.
January 21, 2009 at 4:13 am
i suggest to save the dir path of the image not the image itself.
January 20, 2009 at 11:43 pm
yes, you can also do that if no one is using the table. otherwise, data integrity issue...
January 20, 2009 at 11:07 pm
may we know the size of your dbs?
January 20, 2009 at 10:58 pm
i agree with lowell, also watch your logs.
January 20, 2009 at 10:39 pm
View definition cannot contain the following
TOP
Text, ntext or image columns
DISTINCT
MIN, MAX, COUNT, STDEV, VARIANCE, AVG
SUM on a nullable expression
A derived table
Rowset function
Another view
UNION
Subqueries, outer joins, self joins
Full-text predicates like CONTAIN...
January 20, 2009 at 9:17 pm
run code and show me the result
January 20, 2009 at 8:35 pm
try to recreate the replication and include the distribution server.
January 20, 2009 at 7:38 pm
in distribution server check logreader agent job step->run agent properties. you can add
-ReadBatchSize=50
January 20, 2009 at 4:18 am
Increase the value of QueryTimeout property and decrease the value of ReadBatchSize property of the Log Reader Agent profile so that the processing of the transaction log is successful.
January 20, 2009 at 2:58 am
grant exec on [sp] to
January 20, 2009 at 2:03 am
Try to grant permission on the folder where the excel file is located also uncheck read only option on the folder.
January 20, 2009 at 1:41 am
Viewing 14 posts - 1 through 14 (of 14 total)