I want to run scheduled nightly exports of my database code into my SVN source. It's easy to schedule automated check-in's into svn from a folder, but scheduling the export from SQL in SQL Management Studio is Right click target database, choose Tasks > Generate Scripts. Follow the wizard and presto you've got scripts in a folder....
Hi, I'm having problems with Full-Text Search on SQL Server 2005. In my setup, I am indexing a single column, let's call it Content. The indexing is done in the neutral culture since the column might contain text in different languages. The fulltext index is created as follows: CREATE FULLTEXT INDEX ON [dbo].[Table1]([Content]) KEY IN...
Hi everyone, I'm using SSIS on SQL Server 2005 and have run across an error. As part of the cleanup process I removed a couple of connections from the connection manager section, that we didn't end up using. But now when I attempt to execute the package I get an error stating that "The connection {some guid} is not found. This error ...
Is there a way to get the synonyms of the words in an expression, in SQL Server 2005? In SQL Server 2008 this can be done using dm_fts_parser function, but this one does not exist in 2005. EDIT: I found that there is a file that indicates the words used by Thesaurus, in %ProgramFiles%\Microsoft SQL Server\MSSQL.1\MSSQL\FTData and also t...
Getting the following error when trying to create this sql function in SQL2k5. Any ideas here? It runs fine outside the function. UPDATE THIS work NOW ,but I have to come to the realization that this needs to be in the form of a view since I need to do an inner join on the product_id so this current form will only work when I am passing...
I have a Sql Server 2005 Standard production database with some <120 tables and <150 stored procedures. The newer version update requires beside the application layer upgrade also the upgrade to the db. According to the resources provided I intent to perform the upgrade as follows: create for each new table create script with insert...
I'm in the process of testing an application and it's database and for this I want to restart my testing each time completely clean. This application loads a large amount of data from Twitter. Therefore, before I start, I delete all data from the database and kill any processes from my web account associated with this application. When I...
There are some constraints to this question; I don't have the ability to fundamentally alter any database structure. The challenge here is that I have rows in a database that contain information that really should be on its own row. A somewhat simplified example of the column structure: [PersonID] [FirstName] [LastName] [FirstNameGuest...
Hi all, I'm getting alot of deadlocks on a table. It is SQL Server 2005 the sp that is getting the error does the following Delete From EmployeeAccrualAdj Where EmployeeID = @iEmployeeID and SchemeCode = @sSchemeCode and AdjTypeCode = @sAdjTypeCode and EffectiveDate >= @dtDateFrom I'm trying to work out if the...
I'm refactoring some older SQL, which is struggling after 4 years and 1.7m rows of data. Is there a way to improve the following MS SQL Query: SELECT ServiceGetDayRange_1.[Display Start Date], SUM (CASE WHEN Calls.line_date BETWEEN [Start Date] AND [End Date] THEN 1 ELSE 0 END) AS PerDayCount FROM dbo.ServiceGetDayRange(GET...
I've been wrestling with the SSMS Solution in SQL 2008. I'm beginning to wonder if other professionals actually use this feature -- it just seems like it doesn't work well. Opinions? Avoid like the plague? Suggestions for using it properly? ...
Hi all, We currently have a table that looks like this: ChildId | ParentID ------------------ 1 | NULL 2 | NULL 3 | 1 4 | 3 Can anyone help me come up with a constraint/trigger that would prevent a circular reference from being inserted or updated into the table? Thanks ...
How to install sql server 2005 express edition via command prompt (silent install). Further the installed instance should be accessible via lan instance name: test username : sa password : admin123 Can you plz generate the required script for it. Thanks in advance. ...
How can I find sql server port number from windows? Is there any generic way to find port number for sql server 2000, 2005 and 2008? ...
my practice is that i fill use databinded listboxes and using a tablebindingsource and tableadapter. Then to get selective records in listbox i build stored procedure and select required records. But now i want that the stored procedure must take some parameter from some textbox value. like i to implement the following query string q...
Hi Guys, I Get this error message whenever I tried to up my aspx page. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 ...
I've noticed that we have a lot of indexes that begin with a certain column and that column has low cardinality (i.e. Company and 99% of records belong to the 'live' company). Therefore these indexes are next to useless (from what I've read) as they are not providing a means of segregating the data in the table to be found quickly. So,...
I have programmed a Windows Service in C# which should connect to an SQL-Server 2005 Express Database with System.Data.SqlClient. As Microsoft prefers to use Windows Authentication over SQL Authentication I tried to connect to the DB with Trusted Conenction / Integrated Security. However that doesn't work as I get a System.Data.SqlClie...
I have contacts that can be in more than one group and have more than one request. I need to simply get contacts for a specific group that have no specific requests. How do I improve the performance of this query: SELECT top 1 con_name , con_id FROM tbl_group_to_contact gc INNER JOIN tbl_contact c ON gc.con_id = c.i...
I have an application that loads a vast amount of data from twitter. We have began to notice some performance issues and so I setup SQL Profiler for the applications database. I have noticed the following SQL statement are being executed but do not appear anywhere in my code. Therefore, I am assuming that either SQL Server 2005 or ColdFu...