Hi, I am trying to write a SQL Server query but have had no luck and was wondering if anyone may have any ideas on how to achieve my query. What i'm trying to do: I have a table with several columns naming the ones that i am dealing with TaskID, StatusCode, Timestamp. Now this table just holds tasks for one of our systems that run ...
Hi, I have a SP using FTS (Full Text Search). I want searches across multiple fields, 'intelligently' ranking results based on the weights I assign. Consider a search on a view fetching data from tables: Book, Author and Genre. Now, I want the searcher to be able to do: "Ludlum Fiction", "Robert Ludlum Bourne", "Bourne Ludlum", etc....
var store = new FMP.AspNetJsonStore({ fields: [ { name: 'AssetID' }, { name: 'AssociationID' }, { name: 'Image' }, { name: 'StatusName' }, { name: 'ModelName' }, { name: 'IPAddress' }, { name: 'InScope', type: 'boolean' }, ...
Scenario: I have a list table being populated from a combobox. That list table can have up to 50 things listed in it(whats listed in the listbox is column names). Tricky part: I have a text file that matches one field in the sql table. X1,X2,X3 are the listbox items. So i basically need: select <line in text file>, from <blah> wher...
I'm new here, and relatively new to stored procedures, so please bear with me! I've checked related questions on here and can't find anything that works in this instance. I am trying to build a stored procedure (MS SQL Server 2005) that takes a number of passed in values and in effect dynamically builds up the SQL as you would with inli...
Hello, We're using DB2 9.1 on Linux and SQL Server 2005, and the IBM db2 odbc driver. We have a linked server set up to DB2. From SQL Server, I can do the following: -- I can create the new table fine exec ('create table dev.TestSylviaB (field1 int) in TS_DEV_USER_XXXX') at LinkDB2 -- I can use 4 part naming to select from it, as lo...
I need to run sql statements from the application itself. i.e. the user can go into the asp.net applciation, gets a box and can run sql statements from there I am already doing something like this http://stackoverflow.com/questions/1858329/can-i-rollback-dynamic-sql-in-mssql-tsql/1860334#1860334 That is running dynamic sql is there a ...
Is the SQL Server synchronized to be compatible with many processes? Do i have to make synchronization to be possible to work with DataBases so that more than 1 process be used at the same time? ...
I have a WebTrends ODBC source on server1 and a SQL Server 2005 on server2. I want to connect to this ODBC from SQL Server on server2. So far, I managed to connect to this ODBC from SQL Server which is on same server, using following definition for linked server: EXEC sp_addlinkedserver @server = N'WT_ODBC', @provider=N'MSDASQL', @da...
How do you convert a Unicode Integer into a Unicode Character in SQL Server 2005. For example, SELECT UNICODE('$') returns 36. I am looking for a function that takes 36 and returns '$'. ...
I'm looking for the easiest way to view what users are logging into my database. We have some old user accounts that might not be getting used anymore. Instead of just turning them off and seeing who complains, I thought there might be some way to monitor who logs in and runs some type of query over the next month or so. What would be th...
I have a web-application which is reciving the following while trying to connect to a database hosted on another server. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is conf...
I have a rather simple command which I occasionally run: BEGIN TRAN T1; truncate table mytable insert into mytable select name from myview COMMIT TRAN T1; This command has two ugly side effects: Firstly, select requests on mytable often time out. Secondly, select requests on mytable sometimes return no results. I don't care if it re...
I'm dealing with some really pain in the ass servers, and I'd like them to just use transactions without DTC (for now so I can concentrate elsewhere). I use multiple databases within the scope, so the typical behavior is to promote, but I want to avoid it. What would the behavior be of an in-doubt transaction under this model, if it's ...
Hi to everyone, I'm reading a csv file and insert the information in a sql 2005 database. After about 250 object.save operations, it times out. here the code and the exact error message. this is not the first version of the code but it always give the same time out. This is not a big database, only 2 tables. Is there something I'm not...
Is there any way of setting an "Column Alias" in SQL Server? For Example i have two columns. Description and Price ID colDescription colPrice 1 Red ball costs %colPrice% dollars 2 2 Blue ball costs %colPrice% dollars 3 The selection of colDescription for ID=2, should fe...
Hi, I need to set up a system which will allow developers to request an emergency ID for a database. They will be assigned to a role called 'analyst' which will provide them a drop down box with the databases they can gain access to. They will submit the request and a temporary SQL Login will be generated and displayed on screen. The ...
I receive this error sporadically throughout the day. According to the stack, it's thrown during enlistment. If it were getting this error every time I'd be able to troubleshoot and fix (typically a firewall or LMHOSTS issue). Since it's randomly happening, I can't for the life of me think about what would do this. Any ideas? System...
I have a process where data is transferred from an Excel spreadsheet into SQL Server. To do this, I've created a dtsx using the SQL Server Import / Export Data wizard. The trouble is, the script could be run against any database. But the wizard seems to default to using the format CREATE TABLE [Database].[dbo].[table] when creating th...
When configuring a SQL 2005 Server in preparation for connectivity to a SharePoint Server 2007 farm, Microsoft recommends that Local and Remote Connections use both TCP/IP and named pipes. Where is this setting found? ...