Recent content by TonyKhela

Hi, I need to read blob varbinary(max) data using TSQL. To illustrate this, you can create a table and insert a blob document (c:\King.doc) within it using the following code: Create table document (DocumentID int not null primary key identity(1,1), DocName varchar(255), [FileExtension]...

I had a SQL coding question and wondered if anyone can help. We have hundreds of csv files in a folder with names like “CP1.txt”, “CP2.txt”, “CP3.txt” etc. The files represent code tables and each contains just two “|” separated columns like: 1|Person 2|Marked for deletion 3|Use instead I...

I still cannot see where this limitation is being applied. Has anyone seen this behaviour on their implementation of Replication? Regards

Hi All, I am setting up P2P replication for a high latency environment. I have noticed that the bandwidth between Distribution and Subscriber servers maxes out at 1MBit per second (our network bandwidth is 100MBit per second). Does anyone know where this limitation is being enforced and what...

I installed SQL on a machine that had a date of May 2003. I later corrected the date but now sql won't start, saying that evaluation period has expired. I have tried to put the date back to 2003 but no joy. Is there a way to extend without re-install? I'm running Win XP SP2. Thanks TK

As far as I'm aware you will lose the formatting of RTF when stored in a sql data field. Please explain, if I have mis-understood. Thanks TK

Hi, I needed to store formatted character based data in sql server 2005 fields. Text that contains: • carriage returns • bold • italics • bullet points • etc. Any ideas on how to do this. All help is appreciated. Regards TK

No, didn't really help. I wanted a simple sproc or query to turn columns into rows and rows in to columns. Would be grateful for any hekp. thanks TK

Hi, I need to know how to pivot (This may not be the correct term) the resultset of a query. EG. When I run: use pubs select au_lname, au_fname, city from authors where au_lname in ('white','green') I get the followig resultset: au_lname au_fname city Green Marjorie Oakland White...

OK. What version is your SQL Server? Have you tried detach and attach. Attach can 'sometimes' create the missing log file. You can also put the database in 'emergency mode' to bring it back up without the TL (it will create a new TL). http://www.devx.com/vb2themax/Tip/18624 Let me know how you...

Hi, I tried the follwoing: backup database BOBJECMS to disk='D:\BAK\BOBJECMS\BOBJECMS.bak' with init, format It worked for me. TK

Hi, I have exactly the same issue, except using SQL 2005 backups. I backup a db on server1 and verify. It's fine. I copy to usb external drive and copy to server2, and its now 'corrupted'. This happens the other way to too. ie. from server2 to usb drive to server1. The file has same size and...

Hi, I need to run something like: UPDATE tblDirectDebitInst SET tblDirectDebitInst.[Next Processing date]=#5/22/2007# FROM tblMembers INNER JOIN (tblDirectDebits INNER JOIN tblDirectDebitInst ON tblDirectDebits.fklddid = tblDirectDebitInst.ddidno) ON (tblMembers.[Id No] = tblDirectDebits.[Id...

Hi, Open up Visual Studio, start a new project/solution, with SSIS as type. Then right click, SSIS Packages and choose 'add existing package'. Navigate to the .dtsx file and add it. You can modify it. Hope it helps. Regards TK

Hi, In Visual Studio, under ToolBox - Data Flow Transformations, add a DAta Conversion item in between the Source and Destination items. You can then convert each column to another datatype. Then, in the destination, see Mappings, in there you can choose the input fields (original - unchanged...