Search results for query: *

Hello! I'm having trouble with replication on SQL 7. I'm getting the following error message, 'Could not find stored procedure 'sp_MSins_<table_name>''. Any help is greatly appreciated.

Hello! I'm running SQL 7 and I'm having trouble setting up replication. When I go to configure replication I get a message stating that my server name is null. So, I did @@servername and got null. How do I add my servername? Thanks in advance for any assistance.

Hello!!! I'm having a problem with BCP in SQL 7. I'm BCPing a file into a credit card application. It transfers the file without any problems. However, it moves the decimal place in the dollar field one space to the left. For Example, if the total is 456.78, after BCPing the amount will...

Thanks jnicho02.&nbsp;&nbsp;<br><br>By the way, cool website!!!

Hello!!!<br><br>I have a checkdb issue.&nbsp;&nbsp;Couple of our users were trying to get into one of our application and they were getting locked out.&nbsp;&nbsp;I checked the server and found out that SA had intiated a dbcc checkdb noninfomgs job.&nbsp;&nbsp;I asked around and none of us...

I have a SQL 7 database that switches to single user mode.&nbsp;&nbsp;I found out that if you have a maintenance plan set up on a database and if you selected the option to automatically repair, it will switch the database to Single User mode.&nbsp;&nbsp;My question is that once it fixes the...

I'm trying to run a stored procedure that requires both the publisher id and subscriber id.&nbsp;&nbsp;I got the publisher by running the 'sp_helppublication'.&nbsp;&nbsp;However, when I ran the 'sp_helpsubscription' I didnot get the subscriber id.&nbsp;&nbsp;How can I get the subscriber...

Hello!!!<br><br>I have replication set up between two servers running SQL 6.5.&nbsp;&nbsp;The servers are located on the same domain.&nbsp;&nbsp;I'm getting the following error message:&nbsp;&nbsp;'IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver...

Hello!!!<br><br>I'm running SQL 6.5 on four servers and I'm having trouble connecting to one of the server.&nbsp;&nbsp;One of our developer is trying to connect using AIX, and its not going through.&nbsp;&nbsp;So, I went to another machine and tried connecting using the Enterprise...