Search results for query: *

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

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

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

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

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

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

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

Hi, I'm trying to capture the error in the @ErrorSave variable, but without success. Please see below. Any help would be appreciated. Thanks in advance TK CREATE TABLE [dbo].[complaint1]( [Complaint_No] [varchar](8) , [Complaint_Description] [varchar](50) ) /* Data in the text file...

Hi All, I am having problems upsizing the Queries to sprocs. The UPsizing wizard works well for tables and data, but does not show the queries in the wizard. If I use the DTS Import of SQL Server 2000, the Queries show as VIEWS but are converted to Tables not Sprocs. What I really want is...

Hi All, I am having problems upsizing the Queries to sprocs. The UPsizing wizard works well for tables and data, but does not show the queries in the wizard. If I use the DTS Import of SQL Server 2000, the Queries show as VIEWS but are converted to Tables not Sprocs. What I really want is...

Does anyone know, if OWA has share calendars for meetings? I cant find a full list of features for OWA. Thx in advance TK

Hi All, I have two tables (see below) Employees _Live and tbl_Audit). I am trying to get any changes on any field to be captured into the Audit table. See my Trigger code below. However, I get a syntax error, can anyone help? thx TK CREATE TABLE [dbo].[Employees_Live] ( [TelephoneDirID] [int]...

Does anyone know what Microsoft plans are for SQL 7.0. When will they stop selling it? When will the Service Packs stop? When will security upgrades stop? When will they stop supporting it? I need to justify the upgrade to SQL 2000 and need facts to support my argument. Thanks TK

This is something I've never really got my head round. I know about per seat and per processor and per server, but I have many SQL servers, different versions and different usages. My understanding is that, all three are effective with SQL 2000. Per processor is most expensive, but is...

I run the code below, on two different IIS servers and get different results. IIS_Server1 gives me : LOGON_USER: DOMAIN1\tkhela AUTH_USER: DOMAIN1\tkhela REMOTE_USER: DOMAIN1\tkhela UNMAPPED_REMOTE_USER: DOMAIN1\tkhela IIS_Server2 gives me: LOGON_USER: AUTH_USER: REMOTE_USER...

I am running MySQL 4.0.20 on redhat 9. But i frequently face a problem of that the table is being lock. i see from the process list that i am the only one trying to update the record and the rest of the connection do nothing. Below is the log file i get when i try to show the innodb status...

I have been asked to devise a test plan for a Windows 2003 implementation. I only need to focus on Active Directory and Domain controllers. Does anyone have a testplan, that they have used? Your help is appreciated TK