You can use stored procedure sp_revlogin to get all the logins from old server to new server instead just copy master database to new server. Jessie
Sorry that I am the new one and not very clear about EXEC(...)instead of update statement. Could you specify for me? Thank you very much! Jessie
Here it is, thanks! USE [IB_Stage] GO DECLARE @recordsToUpdate TABLE ( [DocRequestID] int, [PrintedBy] varchar(20),...
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...
I found the issue, the problem is on the first part which fd.fielddata = a.analyst_id that trying convert nvarchar value to data type int. I just...
The following is whole code: Thanks, select p.projcode, p.projid, i.issueid, i.[created], i.[revised], p.projname AS [Project Name], c.compname AS...
Can anybody help me with the following code? Thanks in advance! --THE PROBLEM IS HERE ISNULL(( SELECT TOP 1...
After I emailed to the windows system admin group about all the job didn't run at a time period during the weekend and also asked them what is the...
Thanks! Actually this error occured intermittent and according to the above asp script, I guess that user may entered invalid value whem doing the...
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...
Thanks to all, I will look into that server this weekend trying to find something which cause all the jobs fail to run. Jessie
Yes, I checked the jobs scheduled to run daily. It seemed that SQL Server agent stopped running at that time period because all kinds the jobs didn't...
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!...
It seemed that the error occured at the very beginning of the following stored proc ( I attached the beginning part one) such as if @pendingrecs > 0...
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...
It is SP3, another server which the proc performs fine is sp4. Thanks! Jessie
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...
We just changed the service account and agent account this early morning and some DTS job failed because of the access deny, we are working on it...
I stoped and restarted SQL Server Agent, then it worked for scheduled jobs. Thanks Satya! Jessie
Separate names with a comma.
