Hi All, I have the following records depicting shifts in the Shifts table. ID, Description, Start Time, End Time 1, Morning, 06:00, 13:59 2, Afternoon, 14:00, 21:59 3, Night, 22:00, 05:59 I now need to be able to get the shift relevant to a passed time but get stuck with getting the record for the night shift where the time starts b...
I'm facing conflicts between SQL BI tools of different versions (2005 and 2008). I have SQL BI tools 2008 installed on my PC and when I'm trying to install SQL BI tools 2005 (trying to do this because the part of the project I'm working on is written on VS 2005 and SQL 2005) and it says that i have a later version of the BI component and...
how can i use FREETEXT in sqlserver 2008? i have search problem? Its like a monster jobs search in key words please send me reply thank you ...
"Invalid object name 'TableName_Tombstone'" reads the rest of the exception message. I'm trying to sync sqlce with sql server 2008 and although I've attributed the TombstoneTableName a name with the following code: TableNameBuilder.TbombstoneTableName = TableName.TableName + "_Tombstone" It appears not to find it on the server db a...
Hi guys, I'm working at a web site search which uses Sql server 2008 express edition. I have 'Books' table which has a field named 'Title' where there are titles containing romanian (latin) characters. Well, if the user inserts a word like: 'casa' in the search field and i have a title in db like: 'test casă test' i want to show that ...
I'm working on moving some spatial searching capabilities from Postgres with PostGIS to SQL Server and I'm seeing some pretty terrible performance, even with indexes. My data is around a million points, and I want to find out which of those points are within given shapes, so the query looks something like this: DECLARE @Shape GEOMETRY ...
We are using the SQL Server Database project template with VS 2010. As part of our integration testing, I would like to first launch a fresh deploy of the database. But short of manually right clicking the project and picking "Deploy" It doesn't seem to be a simple thing to get a fresh copy of the database deployed. The documentation f...
So far, I know that change tracking is integrated with SQL Server 2008, and it's being done automatically. What I don't know is whether I should modify the schema by appending a "_tombstone" myself or it's being done automatically by the server. Right now when I'm attempting to access the tombstone table from the server. It results in ...
I am using .NET 4.0 & C# and SQL Server 2008. I have a table Products with a column called Keywords. I have another table Interests with 2 columns Accept and Reject. All 3 columns contains keywords separated by commas. I need to match: If Accept & Reject are empty, then there is a match If Accept has keywords, then there should be at l...
Hi, I have successfully created linked server between 2005 and 2008 version. We changed a table schema on 2008 and re ordered the table columns. We also did the same on 2005 server. If we query both table in their own database then schema looks fine however when I do SELECT * FROM and Select * from then it is showing me old schema ...
I am developing a multi-tenant application in .NET with SQL 2008. Each tenant can specify their own language. For instance, a Chinese company may use my application and want all of their data sorted and searchable via Chinese characters. And a German company may use my application and want all of their data sorted and searchable via G...
Hi, I need somebody to point me to the right direction, I have a MS Access DB that is updated by HP devices, and I have to sync it with the SQL Server 2008. I have a few Ideas, and I would like to know what do you think about this: Is there anything like triggers on access? if so can I comunicate with a SQL Server? Is there any way to...
I have my database with the columns as follows: keyword, part1_d1, part1_d2 ........ part1_d25, part2_d26, ......part2_d34 FYI: d1 through d34 are documents.. How can I give a query to obtain columns with column_name like '%part1%'; as below keyword, part1_d1, part1_d2, ........ part1_d25 I tried the query: select (Select COLUMN...
I want to import data from an Excel file - assume Excel 2003 / .xls - to Sql Server 2008. Have tried adding a linked server to the JET OLE DB Access driver, and of course it fails on the 64-bit machine. But when I try to drop the linked server while experimenting, there's another error saying that the linked server already/still exists!...
Hello, I have a table CREATE TABLE [dbo].[user]( [userID] [int] IDENTITY(1,1) NOT NULL, [fcode] [int] NULL, [scode] [int] NULL, [dcode] [int] NULL, [name] [nvarchar](50) NULL, [address] [nvarchar](50) NULL, CONSTRAINT [PK_user_1] PRIMARY KEY CLUSTERED ( [userID] ASC ) ) ON [PRIMARY] GO how can add uni...
Our production database size is 25Gb (approx) and having 700 tables, I just want to import about 2% of the data for every table in my local database for development/testing purposes... (data should be imported in a way that foreign key constraint should be preserved) ??? Your comments/suggestions will be warmly welcomed !!! ...
I have old .prc files (SQL Server Stored Procedures) which have exported from SQL Server 2000. Now when I try to open a .prc file using SSMS 2008, I get a bunch of chinese characters and other odd characters. I tried a solution found here, but it did not help. ...
I'm trying to create a simple stored procedure which I can use to write data to a log table. I'm a noob in stored procedures, so what I'm missing here? I get an error saying: Msg 201, Level 16, State 4, Procedure toLog, Line 0 Procedure or function 'toLog' expects parameter '@messageTime', which was not supplied. How to modify this co...
I am generating an XSD file based on the columns in my xml. I give them all the type, "xs:string". Then I try to import the file into my database using .NET with SQLbulk import, but for some fields are to small. I get the message, "type of column x in table y is too small to hold data" What type should I use for large amount of text (s...
I have 15-20 data task each in their own sequence container in a single SSIS. Is it possible to catch the data task or sequence which failed and email that details (task name or sequence name, cause for failure) to a user? ...