Search results for query: *

Hi all, I've created the report with Seagate crystal reports with the source to the database through a stored procedure (with ODBC). The stored procedure contains input parameter that I want to sent it to this report from .Net through Crystal report Control Crystl32.ocx. I installed this...

Can somebody help me on this?

Hi all, I've created the report with Seagate crystal reports with the source to the database through a stored procedure (with ODBC). The stored procedure contains input parameter that I want to sent it to this report from .Net through Crystal report Control Crystl32.ocx. I installed this...

Hi all, I've created the report with Seagate crystal reports with the source to the database through a stored procedure (with ODBC). The stored procedure contains input parameter that I want to sent it to this report from .Net through Crystal report Control Crystl32.ocx. I installed this...

Hi all, I've created the report with Seagate crystal reports with the source to the database through a stored procedure (with ODBC). The stored procedure contains input parameter that I want to sent it to this report from .Net through Crystal report Control Crystl32.ocx. I installed this...

The problem is that I removed the replication with Disable Publishing and Distributing and now I can not do with that option to remove this Publication (when I right click on Replication "Disable Publishing" is disabled). I tried with to delete it but error: SQL Server EM could not retreive the...

Hi all, I can not shrink my log, because error "The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed." I do not have replication right now, I have disabled...

My problem is that I have very old databse attached somewhere else 2 months ago, and recover one is corrupted even log file. And I can not attach this corrupted database error appears Page Audit ... and Log Explorer works only with attached log. Maybe I didn't understood, if not, can you please...

Hi all, I have one informtaive question - does somebody knows a good IT company who is able to recover corrupted database by sending corrupted MDF & LDF files. We tried through MSSQL Server Data Recovery but only 65% we have recovered. Database is corrupted seems to be overwriten while we...

Hi George, thanks a lot for your answer - I manage to recover with GetDataBack and File Scavenger, but in both cases files has been corrupted both of them mdf and ldf. Becuase I tried through MDF to attach the databse by reseting the status and then with BDCC to rebiuld the log, but Error...

Hello all, accidentaly I 've tried to restore the databse over existing one. I tried to stop after some moments, but the database now has Loading satus, and when I checked the folder wher databse was stored - the mdf and ldf files for this database disappeared! Can somebody explain what...

Can somebody help me on this issue? Rgds, Probani.

Hi all, I want to change the actual structure of FK constraints, and I have 300 tables. In order to implement replication with PK on subscriber I have to change the option into NOT FOR REPLICATION. With this query I can view tables that to not have this option enabled. select table_name...

Hello there, I have a lot of jobs in my database server and we want to format the server and re-install win3k in this machine. How can the jos be re-created after re-installing the win3k in this machine. I tried through Genenerate SQL script for JOB, but i think this is not working. maybe...

thank you denny, If I want to stop replication - can I just stop SQL Agent and then just detach database or another way better way exists to stop replication? thanks, probani

Hello guys, I have my database file mdf in one disk which doesn't have that much free space, so I want to put this file into another disk (E:). But the database is being replicated, how can I do this? Replication to doesn't be affected and move the data file into the drive where I have much...

hello there, I'm replicating branch databases into HQ, so for all articles I left default options. Then when I checked in subscriber the table structure I saw that referencial intergrity is not reflected (no primary key and foreign keys !!!), only indexes are created. So what I should do is to...

hello there, I'm replicating branch databases into HQ, so for all articles I left default options. Then when I checked in subscriber the table structure I saw that referencial intergrity is not reflected (no primary key and foreign keys !!!), only indexes are created. So what I should do is to...

Thanks, Denny.

Hi everybody, how is possible to backup database on different files by date, I mean to be created everyday on scheduled basis bak files by date - bckpmydb08052005.bak;bckpmydb08062005.bak ... I mean not to be appended or overwrited, but each file everyday (everyday toi be created ne file)...