I open DBF File Through OPENROWSET it works fine but my problem is when I delete that file (c:\mydata.dbf) mannually i.e. Through Keyboard Del button it displays File Access Denied Error. How i solve this problem. Can anybody tell how to solve this problem ...more >>

Hello, Let say I have two tables. Tbl1 (ID1 int PK, tbl1Name nvarchar(50), etc , etc, etc a lot more fields here.) Tbl2 (ID2 int PK, GenericID, GenericTypeID int, tbl2Name nvarchar(50), CreateDate datetime(8)) I want to inner join Tbl1.ID1 with Tbl2.GenericID I want to get all d...more >>

Here are some questions i would like to know about sql server: 1. When i simple do select * from table, no index exept clustered index is being used 2. If i add where condition like: where UserID = 'UserID' i sould add index to UserId field if it is not primary key clustered. 3. If i use wher...more >>

I've "inherited" from an ex-colleague a project based on MS SQL Server which contains a huge number of stored procedures. Unfortunately, when he wrote the stored, he didn't pay much attention to respect the case sensitivity. Now, I've to install the project on a server using a case sesitive co...more >>

I need to create a job that will poll a certain date in my table, based on the current date - if it's over 2 days (48 hours) since it was entered, it needs to send an email to each of the supervisors - - I have the query done, that will provide a result set with the dynamic data, including the...more >>

Hi, I'm working on a query in SQL Server 2k. I have values that are the seconds, i.e. 421, that would make more sense formatted as time "7:01". I guess it's late in the day and I'm getting foggy. That can't be terribly tricky, can it? I usually am working with dates that I need in differen...more >>

Hi, Is it possible to write a function that accepts a resultset from a query as well as a page size and page number variables and return the page in question. Essentially I want to provide paging on all my large table selects but don't want to have to write my SQL to do this over and ove...more >>

I am using SQL Server 2000. I have two tables. A master table (Vendor) and an Address table (Address) that can contain multiple address records for a particular vendor. (1-M) I want to "join" the two tables so that the resulting query shows the multiple records... For instance, I want to...more >>

Hy all, I'm accessing the SQL Server from C++ through ADO and OLE DB. Now we wan't to handle some specific errors returned when we execute an SQL statement. The description text returned with the error (with seems to be from sysmessages) is not very useful for our customers. So we want to ...more >>

Hello all, I have a bit of a design issue I'd appreciate any pointers with. Basically, we have a situation where we deploy anywhere from 1 to 10 machines to a project collecting data, and a single machine can collect anywhere upwards of a hundred million records per project. Our original idea...more >>

SQL Server 2005 Express installed on a stand-alone Windows XP pc. Under Databases it has System Databases and I've created 2 more (A and B). I now want to run a sql script that creates a dozen or so tables. When I run the script it's creating the tables in System Databases/tables instead o...more >>

CREATE TABLE [dbo].[Category]( [CatID] [nvarchar](16) NOT NULL, [CatDesc1] [nvarchar](16) NULL, [CatDesc2] [nvarchar](16) NULL CONSTRAINT [Category$PrimaryKey] PRIMARY KEY CLUSTERED ( [CatID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMAR...more >>

Hi, Is there anyway to put all the stored procedures in Visual Source Safe for SQL 2000? As far as I know, the only way is to save it in a txt file for 2000. How about 2005? anyway to put them all in VSS? Thanks Ed...more >>

I don't know if Sql Server would give me the same error, but I am running a statement that I assume should work but doesn't in my vb.net program and am trying to figure out if the syntax is incorrect. The following statement works fine if I don't have the "with Rollup" option. da2 = New Ol...more >>

I'm trying to replace a value for a record IF it meets a criteria that I set...sort of like a find/replace. Find an entry based on a criteria and then replace the value in another column with a text string. Example: OwnerName Confidential Smith, John 0 Smith...more >>

I'm trying to replace a value for a record IF it meets a criteria that I set...sort of like a find/replace. Find an entry based on a criteria and then replace the value in another column with a text string. Example: OwnerName Confidential Smith, John 0 Smith...more >>

I have implemented log shipping which is perfectly running, I got some structural changes and perform them into primary server, after adding the column in one table. My Log shipping stopped and gives the error at the time of restoring. Please tell me what I should to do, to resolve this iss...more >>

Requesting help from the T-SQL Gurus in here as I am struggling to build the queries for a couple reports..... I have a two different versions of the same scenario, and for the life of me I can never remember how to do this (without using a Cursor). The scenario is that I have a bunch of r...more >>

I have gone through and defined an FTP Connection Manager. When I click on 'Test Connection' it comes back successful. However, when I create an FTP Task using this connection manager I keep receiving the message that the Connection Manager "" cannot be found. I am building a package that...more >>

what i'm I doing wrong. Any reason this statement returns 0 instead of 6? select SUM(50/100)*(0.06*200)...more >>

This has caused the Transaction Log to grow to over 30 GBs, and we run out of disk space. Even with Database in Simple Mode same thing happens. ALTER TABLE dbo.Table1 ADD Field45 varchar(15) NOT NULL DEFAULT '' WITH VALUES Need some advise on what to do? -- Thanks and God Bless,...more >>

I'm trying to calculate the amount of space used in the tranlog as well as get the actual size of the tranlog. I know I can used DBCC SQLPERF(LOGSPACE) to get the log size in MB and the % of log space used. The only problem with only using this command is the Log Size in MB is not the actua...more >>

Hello, maybe somebody can help about this error message. We are trying to use a CLR function named "GetBODescriptor" in order to select records from distinct views, for a parameter. Problem is that, for less than half of existing views, this error occurs: Msg 6522, Level 16, State 1, Line 1 ...more >>

Hi all. Is there at time datatype I can use to define a field in a table. I am just interested in saving the Time value of the datetime. Eg. I want to save the shippment time of a freigh metod.... -- Thanks all Regards Geir...more >>

Dear All! i m using following query to get the result but its giving me error "Incorrect syntax near 'cast', expected 'AS'" SELECT territory, DATEDIFF(day, max(cast(substring( b.batch, 9, 10 )) as Datetime),getdate()-1) AS T_days FROM tbl_reports group by territory How can i us...more >>

If you run this in Sql Server 2005: print len(0x00) print len(0x10) print len(0x20) print len(0x21) print len(0x30) You get this output: 1 1 0 1 1 Can anybody explain that to me? Thanks, Michael Carr ...more >>

I need to write an SQL statement from which I can get column headings from a table in Ms SQL SERVER 2005. For Example 1: Select * from Table Results: Serial, Customer_Name, Address1, Address2, Address3, Address4 Example 2: Now if we need column headings? Select [Column Headings] As Head...more >>

Hi, I want to write a stored procedure that will read all values in a table(TermCodes) and insert them into another table(DischargeReasons). The second table has a primary key that I need to manually increment by 1 so I need to find the max and add one in the stored procedure. The code belo...more >>

let say if I have following table itemA itemB target date 2 3 4 5/20/2007 2 3 5 5/22/2007 3 2 2 4/20/2007 3 4 5 4/10/2007 1 2 ...more >>

I'm going to have to store and index maybe 10,000 files or more at 300KB-2MB each, probably with an everage around 400KB. Mild read and write requirements. Rather than use the file system I'm tempted to use a dedicated database and keep everything in BLOBs. I've worked with BLOB data before, ...more >>

Col1 Col2 Col3=20 17 84 1000=20 15 84 1853=20 13 84 5000=20 11 84 50=20 9 84 67876=20 7 84 556=20 5 84 2000000=20 18 85 2000=20 16 85 26=20 14 85 200000=20 12 85 200000=20 10 85 567=20 8 85 6666=20 ...more >>

Below are three triggers I wrote to keep balance of the "onsale" field of the "product" table. They work well if only single record is inserted/updated/deleted. But if multiple records deleted (I've not tested for insertion and updating) and the "deleted" table have 2 (or more) records with s...more >>