List which columns have a full-text index in SQL Server 2005

How do I list all tables / columns in my database that have a full-text index?

What's the most efficient way to match values between 2 tables based on most recent prior date?

I’ve got two tables in MS SQL Server: dailyt – which contains daily data: date val ——————— 2014-05-22 10 2014-05-21 9.5 2014-05-20 9 2014-05-19 8 2014-05-18 7.5 etc… And periodt – which contains data coming in at irregular periods: date val ——————— 2014-05-21 2 2014-05-18 1 Given a row in dailyt, I want to adjust […]

How to use Stored Procedure in SqlCE

I have just installed Sql Server Compact Edition. To my surprise, we can’t use stored procedure in sql server CE. Do I have any alternative of Stored Procedure in Sql Server CE. I am strongly obsessed with stored procedure, I can’nt think of an application without stored procedures. Please help, Thanks in advance. Edit: Can […]

Error deleting all tables “DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'”

I have a script to delete all tables in my database that looks like this: — Disable all constraints EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT all’ — Disable all triggers EXEC EnableAllTriggers @Enable = 0 — Delete data in all tables EXEC sp_MSForEachTable ‘DELETE FROM ?’ — Dnable all constraints EXEC sp_MSForEachTable ‘ALTER TABLE […]

Unable to find the requested .Net Framework Data Provider. It may not be installed.

I have searched for the answer but haven’t been able to find anything that fits my situation. The site works completely fine when I run it locally, but when after I publish it to Azure if I try to use a page that accesses the Database it gives me the following error page: Server Error […]

SQL Server DELETE is slower with indexes

I have an SQL Server 2005 database, and I tried putting indexes on the appropriate fields in order to speed up the DELETE of records from a table with millions of rows (big_table has only 3 columns), but now the DELETE execution time is even longer! (1 hour versus 13 min for example) I have […]

FREETDS and UNIXODBC character converting

ive got an error to fix. its: [FreeTDS][SQL Server]Error converting characters into server’s character set. Some character(s) could not be converted when i use turkish characters to insert i get this error. my question is how can i disable that converting thing? im connecting to sql server via freetds and unixodbc. thanks..

How do I grab multiple outputs from a stored procedure into temp table

My stored procedure returns me two outputs. I want to use one of them in another stored procedure. So trying to grab the second output in a temp table. but since the structure of both the outputs are different, there fore I always get “Column name or number of supplied values does not match table […]

Get Column names from a query without data

I have a view vwGetData which gets data from two tables t1,t2 and has fields: t1.Field1 [ALIAS1], t1.Field2, t2.Field3, t2.Field4, t2.Field5 [ALIAS5] I will provide below input Select * from vwGetData i want to get below output in C#/SQL ALIAS1 Field2 Field3 Field4 ALIAS5 or ALIAS1, Field2, Field3, Field4, ALIAS5 I want to do this […]

How to design Query for creating dynamic columns from rows

I have data Table1 ID Name ———– 1 n1 2 n2 3 n4 Table2 FID YearS Val ———————- 1 2008 Up 1 2009 Down 1 2010 Up 2 2000 Up 2 2001 Down 2 2002 Up 2 2003 Up 3 2009 Down 3 2010 Up I want to return data in following format: ID Yr1 […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.