Search results for query: *

We migrated to from SQL Server 2000 to SQL Server 2005. 2005 has been configured in mixed mode authentication. When I try to create/save a function from my client (local) machine I get the following error: "Login failed for User xxx". I should mention that within the function, there is...

Hi, We migrated to SQl server 2005 and it is in mixed mode. When I try to create a function from my client (local) machine then it gives me an error "Login failed for User JOHN", but when I remotely login to server and try to create a function, it works fine. Can someone please help me with...

I am sure I am posting this to the wrong section of this forum. My question is related to SQL Server 2005 and Classic ASP. I can't seem to connect to our prod db using the below code. <% set cn=server.createobject("ADODB.Connection") cn.provider = "sqloledb" provstr =...

Hi, I have an application written in VB 6.0. It used to point to server A, now since we moved to new server, the app needs to point to Server B. The server name (for ex old server A) is hardcoded, so i changed it to server B (new server name) and created .exe again. It still points to the old...

Can someone help me with this please. I have 2005 sql server jobs that are scheduled to run automaticallybut are failing to run. The jobs call .exe (.exe is in VB 6.0). When i look at the history of the job it says that the "Executed as user: The step did not generate any output. Process Exit...

I have a project in VB 6.0. We are moving to a new server (serverB) and have change in the servername.At the time of loading the VB application on new server it gives an error: Error message: "CRVIEWER9.dll could not be loaded -- Continue loading Project"? if I click on yes then it gives me one...

After installing SQL 2000 DTS designer components was anyone able to run the SQl 2000 DTS under legacy in sql 2005 management studio. I get error. Thanks in advance!

Can someone help me with this ---How can I make the service account for MS SQL server service to have write permissions on a folder. Thanks!

Hi, I am in the process of migrating from SQl server 2000 to sql server 2005. I was trying to move Crystal reports from Server A to Server B, i had to open the crystal report and point to new ODBC so that it points to new server (Server B). This reports calls a Stored procedure. But when I try...

Hi, We are doing side by side migartion from SQL server 2000 to SQl server 2005. We have 50 DTS packages. Can someone tell me how to move all these DTS packaes to SSIS environment and put them under Management studio > Legacy > Data Transformation Services. I would like to rewrite them later...

We have 14 scheduled jobs sitting on server A,. We are planning to move everything to Server B. We have SQL server 2000 on both the servers. Moved all the databases. Could someone tell me is there a way that we can move our jobs to server B from Server A or do I have to rewrite the jobs on...

I am trying to access a Crystal Version 10 reports via the web through an ASP page. Our ASP page calls a SmartViewerActiveX.asp containing the following code: <OBJECT ID="CRViewer" CLASSID="CLSID:C4847596-972C-11D0-9567-00A0C9273C2A" WIDTH=100% HEIGHT=99%...

I am trying to access a Crystal Version 10 reports via the web through an ASP page. Our ASP page calls a SmartViewerActiveX.asp containing the following code: <OBJECT ID="CRViewer" CLASSID="CLSID:C4847596-972C-11D0-9567-00A0C9273C2A" WIDTH=100% HEIGHT=99%...

I have two tables EMP and CUST with columns Empsym and Custsym. I need to join on these fields --- Empsym with the string of symbols in Custsym. Can someone help me with this. Empsym Custsym 15 16H;42A;23 23 36D;15;24 21A D42;35;XB D42 65;3B;X6;44;56;14B;21W;21A;15C

How can I convert Varchar value to Money in sql server 2000.

Can someone help me with this. is it possible to display just the date part from a Datetime column in sqlserver 2000. Want Output as ‘10/15/2008’ not ‘2008-10-15 00:00:00.000’ Thanks!

Is there any difference between VB 2008 and VB.NET Thanks in advance

Can someone help me with this.I am trying to use CASE statement and I get the following error Line 4: Incorrect syntax near '='. [Select EmpUsr.*, CASE When usrkey = adminusrkey then 'AdminName' = fname +' '+Lname Else when usrkey <> adminusrkey then 'ClientName' =...

I have three tables T1 , T2 , T3. T1 --- Fname, Lname, usrkey, cert_id, grp_cert_id T2 --- usrkey,empno T3 --- usrkey I am trying to write a query to get the list of all usernames and Groupnames along with empno. Username = fname + Lname Groupname = fname + lname if certid = grp_cert_id...

I have two tables X and Y. X has empid and jobid, they both can be either same or different. Table Y has TEST_EMPID and CompanyName. I am trying to join table X to table Y. I need to select CompanyName as Emp_CompanyName when x.Empid = Y.TEST_EMPID and companyName as Job_CompanyName when X.Jobid...