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...

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...

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...

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...

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...

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...

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...

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)...

Hello, for the security reasons we have installed certificate on ISS and we want to go users through https. The thing is that they can access the page even through http. Let's say http://mydomain.com to redirect into https://mydomain.com. I tried using meta http-equiv="refresh", but it loops...

Hello, my replication stopped for some days, because of some problems in the Windows 2003 server communication. After this issue was solved, I'm getting the messsage in the subscriber "The subscription(s) have been marked inactive ..." The Snapshot I created at the beginning and it worked for 2...

Hello, we are using windows 2003 servers on the branches and we have good links 1Mbit/s. I have configured Transactional replication in order branches to replicate in HQ. It is happening very often that we are not able to access these servers with Remote Desktop and SQL Server Enterprise...

hi all, I want to enable replication between to servers A and B, A - is publisher/ditributor and B - is subsriber. The thing is that the online database is located in the server A. So, a don't want to replicate everrything on the server B, because I want to make the last backup from server A...

Dear all, I'm calling another window as a popup from asp.net with javascript function, but the thing is that is doing postback through LinkButton: LinkButton1.Attributes.Add("onClick", "hape('displ_descr.aspx?par=" & Label2.Text & "');") How can I pass the parameter PAR from javascript not...

Hello there, in vb.net (it is actually web application) I would like to perform condition based on if actual selected date by user is yeserday's date or no? this the code : ------------------------------------------------------- Dim date1 As New Date date1 =...

hello there, I want to access registry and to assign permission to a domain user domain_name\start.sql into this regisrty keys: 1.HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer 2.HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQLServer 3.HKEY_LOCAL_MACHINE\Software\Microsoft\Windows...