Thank you for your response. How do I do the same thing for text data type. How do I find out if the file stored is a pdf/doc/txt/oft etc...
We have an application that saves attached files as a blob datatype in a table. How do I retrieve data from the table and display the contents of the...
Hello - I created a DTS package to import 2 columns into a Database table. The table is defined as ClientEmail (ClientID varchar(255) NOT NULL,...
Yes. It is an enabled subscriber. And, the Impersonate SQL Server Agent on the Publisher Option is also checked. I can also ping the publisher from...
Thank you for your help. I guess I could have done it as a backup restore operation, but I am interested in finding out why the replication is not...
hello - I am trying to get a copy of the database on another SQL Server. So, I created a snapshot replication and ran the snapshot agent. When I try...
But, with the above query, I am not getting any output when there are no records in table t1. There are some SalesPersonIDs in the system that do not...
Hi. I have two tables that I need to merge based on a condition. One table is the list of all sales person IDs and the their phone numbers. Another...
Thank you both for your responses! I will definitely try the query. But, we have so much data on this query that I am not sure if performance will be...
I need to create a query for the following scenario: I have a table with Region, SalesPersonID and Sales Column. Each region can have multiple...
Are there any documents or links that tell us what specific steps to take for installing SQL Server 2000 on a Windows 2003 server. I read something...
I have been successfully running replication the last one week. But, I did not have to do the steps that you mentioned. But, how do I find out the...
Thanks again for the help. I tried to completely disable publishing on the server. I deleted all the subscriptions, then the publications and then I...
I think I kind-of solved it! I executed sp_dropsubscriber on the publication database and I was then able to create the replication. This morning I...
Thanks for replying! I was successfully able to create the publication that I wanted. But, now I have a new error when I try to create a push...
I am not able to disable or enable publishing on our database server. We recently had to restore our entire database server. And, when I restored the...
Separate names with a comma.
