I know that a sql server full text index can not index more than one table. but, i have relationships in tables that i would like to implement
We are working on designing an application that is typically oltp (think: purchasing system). however, this one in particular has the need that
I have an interbase db. how can i convert it to sql server?
We have 18 databases that should have identical schemas, but don't. in certain scenarios, a table was added to one, but not the rest. or,
Do you guys keep track of stored procedures and database schema in your source control system of choice? when you make a change (add a
A db audit trail captures the user last modified, modified date, and created date. there are several possible implementations:
I'm looking for some "best practices" for automating the deployment of stored procedures/views/functions/table changes from source control. i'm
I am looking to manage a sql server 2008 db using management studio 2005. the reason for this is because our server is a 64-bit machine and we
I've got an ms-access application that's accessing and ms-sql db through an odbc connection. i'm trying to force my users to update the data
I have a table say t in sql server 2005 database and it has two columns say a and b, which more often than not won't have any values in them. how
There is an almost identical, but not really answered question
We have a web application that uses sql server 2008 as the database. our users are able to do full-text searches on particular columns in the
I am trying to append my email to my @email string a bad @status is passed in. it works without the line i commented out. i think i'm close, but
I want to know how does the sql server know what @p# is in say this linqtosql query select [t0].[memberid],
Okay still fighting with doing some sqlcachedependecy in my asp.net mvc application i got this piece of code from microsoft to cache
How can you cascade filter the attributes of more dimensions in a ssas cube, viewed in excel 2007. for example, if we
What could be the possible causes for the following exception? system.platformnotsupportedexception: 'resourcepool' is not
I have a new database table i need to create... it logically contains an id, a name, and a "value".
How to create a SQL Server function to "join" multiple rows from a subquery into a single delimited field?
To illustrate, assume that i have two tables as follows: vehicleid name 1 chuck 2 larry locationid vehicleid city
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
I have a table in my db that has 2 bit fields, one called active and one called public..for all records active
I have a simple sql 'select' query, and i'd like to dump the results into an excel file. i'm only able to save as .csv and converting to .xls
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Currently, if i want to output a sql script for a table in my database, in management studio, i can right click and output a create script.
Generally, how bad of a performance hit is storing a file in a database (specifically mssql) as opposed to the file system? i can't come up with
Does running a SQL Server 2005 database in compatibility level 80 have a negative impact on performance?
Our software must be able to run on sql server 2000 and 2005. to simplify development, we're running our sql server 2005 databases in
Is there any way to use inheritance in database (specifically in sql server 2005)? suppose i have few field like
How much database performance overhead is involved with using c# and linq compared to custom optimized queries loaded with mostly low-level c,
We've been having some issues with a sharepoint instance in a test environment. thankfully this is not production ;) the problems started when the
In sql server how do you query a database to bring back all the tables that have a field of a specific name?
I have ms sql server ms on my pc which i want to connect with the laravel project in cpanel i have created two rules in the firewall for the port
I'm looking mainly at things like new sql syntax, new kinds of locking, new capabilities etc. not so much in the surrounding services like data
I'm working on a side project that would be a simple web application to maintain a list of classes and their upcoming schedules. i would
I would like to create a report from a project management system that has been created in lotus notes. i have connected to oracle from ssrs
Problem: i have an address field from an access database which has been converted to sql server 2005. this field has everything all in one field.
What is the best full text search alternative to microsoft sql? (which works with ms sql) i'm looking for something similar to
I have a query that originally looks like this: select c.id, c.name, c.countrycode, c.customernumber, cacc.accountnumber,
How do i return a constant from an sql statement? for example how would i change the code below so "my message" would return if my
I am using sql server 2000 and i have two databases that both replicate (transactional push subscription) to a single database. i need to know
How to write stored procedure output directly to a file on an FTP without using local or temp files?
I want to get the results of a stored procedure and place them into a csv file onto an ftp location. the catch though is that i cannot
I have an application deployed into multiple zones and there are some issues with opening larger documents (20-50mb) across the wan.
I would like to cross-reference construct a distance chart similar to the one
I need to import a large csv file into an sql server. i'm using this : bulk insert csvtest from 'c:\csvfile.txt'
Has anyone been able to get a variable record length text file (csv) into sql server via ssis? i have tried time and again to get a csv
I am reading in csv file and translating it to an sql table. the kicker is that one of the columns in the table is of data type id that needs to
When attempting to connect to a sql server 2008 instance using management studio, i get the following error: login failed.
For my asp.net website with forms authentication, i will use windows integrated security to access a sql database. i will give db permissions to
I have lots of article store in ms sql server 2005 database in a table called articles- "articles (articleid, articletitle,
I see that there is something called stunion() which will union the result of one geography type with another. but is is possible to
How to solve the following error message "Unclosed quotation mark after the character string" in SQL Server?
Below is the table i have created and inserted values in it: create table prod_sales (saleid int identity(1,1), saledate
I have the following table t key value
Is there a function or how would you implement a function that would check the last two characters of a string and convert this string to
I have the following sql query that joins two select statements on two columns select * from (select top(100) name
Check if a challenge for a specific user has been completed when that challenge has more than one task
I have two tables below: challengetask: tells how many tasks that a challenge has.
I have a table like this parent_id col1 col2 col3 101 john 1 9/12/2009 4:33:22 pm
I'm new to sql programming and i was creating a table doing several when cases and the fact is that i have files that end in '.sas' and i want to
With cust as (select distinct c.swcustomerid as enduserid, a.assetid as
I have a table that looks like this: account#
I have created a installed sql server 2008 on my win xp box and i am developing my wpf web app on my laptop. when i try to create a connection
By using sp_who2 i can get a list of current log-in users and machine names. some users are using sql server log-in user name such as sa. is there
We're working with a fixed transaction log size on our databases, and i'd like to put together an application to monitor the log sizes so we can
I've been asked to implement some code that will update a row in a ms sql server database and then use a stored proc to insert the update in a
I'm using ado.net to access sql server 2005 and would like to be able to log from inside the t-sql stored procedures that i'm calling. is that
In ms sql server management studio express, is there a way to set the default author name to my name when i create a stored procedure by right
I'm designing this collection of classes and abstract (mustinherit) classes…
I am starting a new client/server project at work and i want to start using some of the newer technologies i've been reading
I would like to add a [bit] field that is calculated from a boolean [int] field sql table looks as follow: create table
I'm working on creating a point-of-sale system using an mvc model in c# and sql server, but i seem to be having some kind of issue connecting to
I have the following code that i'm trying to refactor to format a phone number field in the format i need it in:
What would a Database Diagram (ER Diagram/Table Layout) look like for measuring distribution of something?
If i was, for example, going to count "activities" across many computers and show a rollup of that activity, what would the database look
I'm trying to generate a table which returns a count for the preceding instances of the foreign key value up to and including the foreign key
I know a role name and want to find all users in this role. how do i acheive this in sql server 2000 (in the sql script, not in management studio
The query optimizer is estimating that the results of a join will have only one row, when the actual number of rows is 2000. this is causing later
I'm trying to access the reporting services via web services in my visual studio 2008 application. how/where can i find my wsdl?
Is it possible to install/register another local server instance in any sqlserver version, besides the default local instance, where only one
i've been developing a site using asp.net mvc, and have decided to use the new sql server 2008 filestream facility to store files
I was wondering if there are any alternatives to microsoft's sql server management studio? not there's anything wrong with ssms, but
Has anyone tried installing sql server 2008 developer on a machine that already has 2005 developer installed? i am unsure if i should do
What is the best method for executing ftp commands from a sql server stored procedure? we currently use something like this: exec
I am trying to enable full-text indexing in sql server 2005 express. i am running this on my laptop with vista ultimate. i understand that
We're in the process of upgrading one of our sql server instances from 2000 to 2005. i installed the performance dashboard
One simple method i've used in the past is basically just creating a second table whose structure mirrors the one i want to audit, and then create
How can i connect to a remote sql server using mac os x? i don't really need a gui, but it would be nice to have for the color coding and
I have a problem solving an ms sql query. in summary, the query should get the date column as two columns, year and month, the count of other
I new to sql, and i need one parameter called @user1 in the stored procedure to accept just 3 words for example ('max', 'low',
I have a problem creating a sql server query. in summary, the query should get columns that are sum and count, grouped by
I have a sql table with 2 columns id (int) and createdate (datetime) type. i want to filter all the ids for each thursday for a given month
I have the problem that i am using visual studio 2013 to create a mdf file and then open it like it is described in this tutorial:
I imported a table from sql database to spss dataset, i edited the table by adding a new column to it after some statistics, but when i try to
I have a table with columns like sourceid (guid), state (1:deactivated, 2:activated, 3:dead), modifieddate. i am writing a query to
I am ingesting data from two different source (source a and source b). although data may be coming from two different sources, there is a