SQL Server 2005 bigint missing?
I am trying to set a column as a 64-bit integer, but my only available options are tinyint, smallint and int. Where did bigint run off to? Notes: I'm using Access 2008 to access my SQL Server. ...
sql-server-2005
SQL Server 2005 Reporting Services: Reports are Compressed
I have a report that I am capable of viewing correctly in Internet Explorer (IE) with the help of Reports from SQL Server 2005 Report Server (SSRS). The problem is that the report is compressed to about 100px by 100px in Firefox and probably other browsers such as Safari and Chrome. Also, I am using IIS6. How can a report be rendered pr...
Writing a dreaded SQL search query (2nd phase)
I am working on a search query (with an asp.net 3.5 front end) which seems quite simple, but is quite complex. The complete query is: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[usp_Item_Search] @Item_Num varchar(30) = NULL ,@Search_Type int = NULL ,@Vendor_Num varchar(10) = NULL ,@Search_User_I...
asp.net error: "Conversion failed when converting character string to smalldatetime data type"
I am getting an error when attempting to call a stored proc from my asp.net page. e.Message = "Conversion failed when converting character string to smalldatetime data type." The stored proc is being called by: The asp.net code that is calling the stored proc is: //Display search results in GridView; SqlConnection con = new ...
In SQL Server, why there are duplicated DMVs in all database? Such as sys.databases.
Hi guys, In SQL Server, there are some *DMV*s that appear in all databases and have the same content in it. What's the purpose of this approach? For example, the following 2 query will give the same result. select * from master.sys.databases select * from tempdb.sys.databases Thanks. ...
Full Text indexing Multiple languages
Hi all, My DB stores content in three languages (English,French & Arabic) I have full text indexing enabled for few tables and would like to know few best practices: 1. When show I us language neutral indexing? 2. Can I Index Arabic? I don't see Arabic in the Indexable language! 3. should I have separate indexes for each language? (Each...
t-sql query not showing expected result
I have sales table data as shown below I want it to display group wise sales according to Date. Sales table contains data for different groups but my query shows only two rows. The SQL Query: select i.gName, sum(Quantity) as '180ml', isnull((select sum(Quantity) from saleslog where BillDate='12-10-201...
procedure in sql server (getting problem )?
hi, In my application i am implementing search, it is like when user enter text separated with comma in a text box, search result will be displayed. This is my requirement and for this i write a procedure for this it is like this....... create procedure [dbo].[videos_getSearch](@searchstring AS VARCHAR(1000)) AS BEGIN DECLARE @Cur...
SQL Server Error Log Configuration
Dear Friends, What is SQL Query to return the SQL Error Log Configuration? Thanks in Advance ...
SQL Server 2005 - install & setup -ADD_LOCAL property / template.ini / UPGRADE property
I'm trying to install SQL Server 2005 Developer Edition on my Windows 7 Ultimate laptop. When the installation runs, I am getting the following error :- A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the nam...
SSIS - cast a date to use in an expression
I want to cast a date into ISO format, and use it as a string in an expression in SSIS. This is what I type in T-SQL select convert(varchar(8), GetDate(), 112) and this is what I get back 20100630 My goal - is to create an archive folder based on the date. I have the File System Task part of creating a folder sorted, I can do that...
SSRS 2008 Reporting Services on SQL Server 2005
Hi All, I know that the only stupid question is the one that you don't ask ... but even so this could be borderline :) Is it possible to install SSRS 2008 [stand alone] on a site that has SQL server 2005 installed. I know that you can store the SSRS 2008 Report and Temp databases on SQL Server 2005 [With some restrictions based on th...
SQL Server Deadlock Problem - How to Resolve ?
Hi All We have a SQL Job (2005) that from time to time will fail due a deadlock. The error is as follows ; Transaction (Process ID 52) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed. This i...
Async=true and Entity Framework
Background WCF Stack, Data Access Implemented in Entity Framework, Simple ASP.NET Front End This is a two part question. Recently we ran into an issue with periodic crashes with an exception that read: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified ne...
DateTime error message: Conversion failed when converting datetime from character string.
I am passing parameters to a stored proc. The parameters code block on the asp.net side is: SqlConnection con = new SqlConnection(strConn); string sqlItemSearch = "usp_Item_Search"; SqlCommand cmdItemSearch = new SqlCommand(sqlItemSearch, con); cmdItemSearch.CommandType = CommandType.StoredProcedure; cmdItemSearch.Parameters.Ad...
SQL Server performance issue
Having following sql server coenfiguration. OS : Windows Server 2003 SQL Server 2005 Professional edition with SP3 Service Broker enabled There are schedule jobs but for testing i have disabled agent. When no user connected, its CPU uses goes upto 90%. I was wondering what is it doing internally. Executed following statement sele...
Sql server Encryption or security permissions
Just started looking into encryption using keys and certificates in sql server 2005/08 and although it looks very good I'm not too sure why I should use it over sql server security permissioning. For example, I have a table with sensitive data in, such as user-name/passwords. I can either encrypt the data using say ENCRYPTBYCERT, or s...
What happens to encrypted data if the certificate is dropped?
If I encrypt data using ENCRYPTBYCERT in sql server 2005/08, what happens if the certificate used to encrypt it with is dropped from the database? The data is still encrypted, but the certificate is no longer there so can't be decrypted. What do I do? How do I get the original plaintext back? Recreating the certificate with the same ...
What really is DAC - Dedicated Administrator Connection in SqlServer 2005
What really is DAC? When is DAC to be used? ...
sp_msforeachtable does not give me the right result.
Hi guys, I want to use sp_msforeachtable to do some work for some tables in a database. I use the IF statement to filter the tables. But it doesn't give me the right answer. As the following script shows, I use AdventureWorks to do the testing. I want to do some work on every table except Person.Address, Person.Contact, Person.CountryRe...