Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TonyKhela

    Reading BLOB data

    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]...
  2. TonyKhela

    Reading text file names and importing from Them

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

    SQL 2005 Peer to Peer Replication bandwidth issue

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

    SQL 2005 Peer to Peer Replication bandwidth issue

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

    how to extend sql server 2005 evaluation period

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

    Storing formatted data

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

    Storing formatted data

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

    Pivoting Resultset of a query

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

    Pivoting Resultset of a query

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

    Re-establishing Transaction Log URGENT

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

    RESTORE Problem - Invalid Microsoft Tape Format Backup Set

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

    RESTORE Problem - Invalid Microsoft Tape Format Backup Set

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

    Syntax error on update query

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

    SQL Server Integration Services Package

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

    ssis package problem

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

    SQL error Msg 8179

    George, Any ideas why this would give this error? Thanks in advance TK.
  17. TonyKhela

    SQL error Msg 8179

    Alex, I had already tried this before and it did not work. In any case, as I said I can find other ways around it but I wanted to get to the bottom of this. Thanks. George, The first server is SQL 2000 and the Linked Server is 2005. select @@version --SQL 2000 Microsoft SQL Server 2000 -...
  18. TonyKhela

    SQL error Msg 8179

    Hi All, I have a strange issue. In a distributed query (see below) SELECT c.dtepublished FROM its.dbo.internetinspection a LEFT OUTER JOIN [ITS].[dbo].[itsimsinspectionxref] b ON a.Insp_no=b.Insp_no LEFT OUTER JOIN LSD1HQ.[IMS2000_database].[dbo].[tblInspection] c ON...
  19. TonyKhela

    SqlNodeInstall task shows in scheduled tasks

    Hi, After a SQL 2005 install on a Win 2003 cluster, I can see several tasks in Scheduled Tasks on each node called "SqlNodeInstall", "SqlNodeInstall_1", "SqlNodeInstall_2" etc. They do not have a schedule so are probably not causing any issues but still I would like a clean system. My question...
  20. TonyKhela

    How to return JUST the user defined stored procedures.

    Hi, In SQL 2000 if you ran: SELECT * FROM SYSOBJECTS WHERE TYPE='P' It returned the stored procedures. But in SQL 2005, this will return all the system stored procedures too. I used the Profiler to capture the query that Mgmt Studio uses. This a cut down version of it: SELECT sp.name AS...

Part and Inventory Search

Back
Top