We got the following error messge when we try to update one record on 32-bit 2000 server through 64-bit 2005 server:(1 row(s) affected) OLE DB...
Can anybody help me with the following code? Thanks in advance! --THE PROBLEM IS HERE ISNULL(( SELECT TOP 1...
Hi, Can any one help me with the following error message:The page cannot be displayed There is a problem with the page you are trying to reach and it...
Hi, Does any body have an idea why the jobs we scheduled running daily didn't run at every weekend and also monday morning at a time period? Thanks!...
Hi, One of our dts package ran fine yesterday but failed today, I checked the package that it failed on the first task whcih is select a connection...
Hi SQL Expert, I am receiving an error when trying to execute the following stored proc on sqltest.qnxtdatacleanup:exec spProviderSelectMaintenance...
Hi, I have problem when I would like shrink one log file to around 5 GB from over 11 GB right after the transaction log backed up. Every time when I...
Hi, I have to schedule a differential backup job to run every 4 hrs per day and would like to retain backup file for 3 days and baackup that file...
Hi, I have one concern regarding SQL Server services account change, we'll plan to change few servers services and agent account. I am just wondering...
The log_shipping_primaries and the log_shipping_secondaries tables are updated based on the SQL Server server names. You must runSelect @@servername...
I checked our log shipping monitor, found last backup was 12/5/06 3:01PM, last copy was 8/22/07 8:30AM and last restore was 8/22/07 8:00AM. And then...
I am just wondering if there is any alert I can set for SQL Service and SQL agent start or down. Is any body have this kind of ideas? Thanks! Jessie
After we did some service patchs upgrade, the stored proce suddently ran slow with the follwoing warning, Is anybody can help me to figure out why?...
Hi, I was asked to fixed the following issue, is anybody can help me to figure out what's the issue for the following error message? When we gererate...
Hi, Few days ago, we were asked to disable the log shipping until further notice, after an hour something, we were asked to have log shipping backed...
Hi, I was asked for the following question, Is this should be related to permission? Thanks to give me help.Jessie- is there a way around this? We...
Hi, I am just wonderful if I need to resize tempdb log file to enough large, will this change require a reboot, or restart of any of the systems....
After we set simple recovery module for that database, the log file still grow to full, Is any body have ideas about it? Thanks! Jessie
Hi, Is anybody can help me about the following: BackupDiskFile::CreateMedia: Backup device 'x:MSSQLBACKUPELDERHEALTH_BACKUP.BAK' failed to create....
Is any body can give me some suggestions? Thanks! I recently found that our data files for a critical database were all reached their original sizes,...
Separate names with a comma.
