Search results for query: *

Hi all, I have a SQL 2000 box with 60 databases and I need to move all the databases to a new sql 2005 box. What is the quickest way to do that?

I installed SQL2005 on a 64bits Dell server and apllied SP1 but the SSIS service did not install and does not even appear on the services lists. Although the BI dev studio is installed and I can Create packages but when I go to the management studio to connect to an SSIS server I get the error...

I have Crystal Reports 8 Web Component Server (WCsinsapi.dll) installed on my Win2000 running IIS. This allows me to host reports on the machine a open them from the Browser. Now I have a new group of reports that are designed in Crystal 11 and hosted on the same machine when I try to open them...

I have installed sql server 2005 on a Windows 2003 box and Created a linked server to link to a SQL2000(SVRFOO) running on Win2000 box. When I try to run this query: select * from SVRFOO.databasedn.dbo.People against the linked server I get this message OLE DB provider "SQLNCLI" for linked...

Hello friends, I am trying to bind a dataset to a drop down box using the following code: strSQL= "SELECT RoleID ,FullName FROM CONTACT " Dim dsDataset As New DataSet Dim daAdapter As New SqlClient.SqlDataAdapter(strSQL, dbConnection) daAdapter.Fill(dsDataset) With cboContacts...

I have created the following trigger CREATE TRIGGER Learner_ITrig ON dbo.Learner FOR insert AS Begin if (select count(LearnerID) from learner where Learnerid=(select LearnerID from Inserted))>1 begin RAISERROR ('This ID already exists in the database', 16, 1) rollback tran end If...

Hello folks, I am sending a email from sql server that consists of results of a query and that's working perfect. When I open the text file generated by xp_sendmail in notepad it's OK, but when I open it in MS Word or WordPad, I see garbage characters in form of squares added to the content. Is...

I am writting an app in vb.net. I have a form with a tabcontrol with 2 tabs only.At design time, the tab control size is smaller than the form,but when I run the application the tab control resizes itself beyond the form size such that I can't see the borders of the tabcontrol and some controls...

Hi folks, I am creating some datacubes on the dev server and I have to implement the cubes at a client once it has been tested.Is there a way to script the cube and just run the script file on the Client server without needing to recreate the cube from scratch and the calculated members? Thanks

Does any one knows how to call a stored procedure from a view? Is this possible?

Hi all, I am restoring a database from a backup file and everything goes well right until the end but instead of getting the confirmation message,I get this Error Message: COULD NOT FIND ROW IN SYSINDEXES FOR DATABASE ID 8,OBJECT ID 1,INDEX ID 1.RUN DBCC CHECKTABLE ON SYSINDEXES When I click OK...

Hi folks, I have created an new dot project on IIS running from win2000 Server but I have a funny string in the Url: http://128.25.20.2/(ealz2ajcmhm1nq55tme1dw55)/index.aspx The IP address is my local ip but WHAT THE HELL IS the funny string between brackets? How can I get rid of it? Thanks guys.

Hello folks! I have a framed page that consist of 2 frames.The top frame has a form (Searchcriateria.aspx) with a couple of text boxes and drop down boxes that the user uses to specify his search criteria. When he clicks submit, the values entered in the text boxes must be passed to the page...

Someone started a thread on Monday 19/04/04 where he was asking for help on how to import data from a text file into SQL table and the text file contained something like this. UsersName=david TimeLoggedIn=12/12/01 Location=London UsersName=david TimeLoggedIn=12/12/01 Location=London...

I would like to create my own version of the cdonts dll that ships with IIS to send email using SMTP. My version of this DLL will implement load balancing.If i have for example 10000 mails to send I would like to be able to balance the load between 3 or 4 servers.To be able to do this at a...

I want to change the width of a data grid that displays a single column of data to 200. This is how I do it: Me.grdError.TableStyles.Add(New System.Windows.Forms.DataGridTableStyle()) Me.grdError.TableStyles(0).PreferredColumnWidth = 200 Me.grdError.DataSource =...

Is there anyone in the forum who has written the Microsoft exam 70-019 Desing and Implementation of Data Warehouse with SQL Server 7.0? If you have please, give me tips on study materials to use, resources and links and what to expect from the exam. Thanx

I have a front end application that collect data from a database change the data according to a set of rules and then stores it back to the DB.The application uses loops intesively because every single record must be processed but now the application holds control of the processor and thus...

I WOULD LIKE TO TRANSFER DATA FROM SQL SERVER TO A TABLE IN ACCESS BUT IT DOES NOT SEEM TO WORK THIS IS HOW I DO IT: Dim mySelectCommand As SqlCommand = New SqlCommand("select * from customers", SqlConnection1) Dim mySqlDataAdapter As SqlDataAdapter = New...

MY PC IS GIVING THE FOLLOWING ERROR WHILE BOOTING: CMOS checksum error - Default loaded CMOS battery failed ! IF I PRESS F1 THE BOOTUP SEQUENCE CONTINUES WITHOUT PROBLEM BUT THE PROBLEM IS THAT IT LOOSING ALL CMOS INFO. I CHANGED THE BATTERY WITH A FRESH ONE BUT THE PROBLEM DOES NOT GO AWAY...