Recent content by bertrandkis

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

You don't need to do anything special. Use the DTS wizard. From the Tools Menu in EM -> wizards -> Data transformation ->Export data. Choose your source database On the screen to specify the destination Choose text file in the drop down then specify the destination file naming it with a CSV...

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

This query will do the trick for you. This technique is called correlated subquery. select UniqueID, Tariff from dbo.BHT_QA8D_EXTRACT_Dec05 as T1 where Exists(Select Tariff from dbo.BHT_QA8D_EXTRACT_Dec05 as T2 where T1.UniqueID=T2.UniqueID and T1.Tariff...

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

Hey NoCoolHandle, Your UDF script is good but it's limited to the problem you wanted to solve because you have hard coded the column names and tables in the UDF "Select @v = @v + Firstname + ', ' From Firstnames where mid = @mid" so it cannot be used in a different scenario. However...

Thanks for the tip. However the Stuff() function will not work as the code is dymanic and I am using a Select * to generate the query because the column names and number of columns change. So what I need now is to change the Database collation before I generete the mail and then set it back to...

Well I am glad that you have taken my idea one step further. As long as it works, the code is good. You deserve my *. Good work.

The key here is to understand how assigment into variables works.Since we ar on the subject, the following is an Excerpt from my SQL Bible: --A variable is a tempory memory location where a program stores data as it runs --2 Types of variables in MSSQL: Local and Global variables --A variable...

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 disappointed that it did not work.Any way, the challenge now is to find the records that are causing the conversion to fail. To do that we have to proceed by elimination and test the data one partition at a time. For example you may select all records where the date is 02-04-2006, SELCT *...

Your problem might be some records with date formats that SQL cannot convert into a proper datetime format. If you are sure that the entries in the SysEntryDate are consistent 1-3-2006 12:2:23, all you need is to extract the date part and then cast it to a datetime. You can use string functions...