Hi, I'm looking how to change the language from English to Spanish permanently, for all sessions. I reached it with this statement: SET LANGUAGE spanish But when I start a new session the English language comes back. Thanks. ...
BOL states that SQL Server level 10 messages are "Informational messages that return status information or report errors that are not severe." However these errors seem severe and not informational: 2540 - The system cannot self repair this error. 2745 - Process ID %d has raised user error %d, severity %d. SQL Server is terminating th...
Hi Everyone. I have an environment with Delphi 2010 + SQL Server 2000 +Windows 7 (RC) for i am testing it on Windows 7... When I try added a new dbExpress connection for SQL Server and press "Test Connection" from the data explorer, I'll get the following message:- Borland.Data.TDBXError: DBX Error: Driver could not be properly initia...
i keep getting an error: The upsizing wizard does not work with this version of SQL Server to which your access project is connected. has anyone else seen this issue. ...
I have installed SQL 2005 and now have instance name as the default one: SERVERNAME I'd like to change to: SERVERNAME\MyDB Is this possible? If yes, how? ...
Any quick doc / pdf to understand basics that i can print and have idea? Not 2k8... by quick book i meant something of this sort: http://searchsqlserver.techtarget.com/tip/0,289483,sid87%5Fgci1052507%5Fmem1,00.html?ShortReg=1&mboxConv=searchSQLServer%5FRegActivate%5FSubmit& Little concepts and than the commands. I got it for bac...
If I want to delete all the tables in my database like this, will it take care of the foreign key constraint? If not, how do I take care of that first? GO IF OBJECT_ID('dbo.[Course]','U') IS NOT NULL DROP TABLE dbo.[Course] GO IF OBJECT_ID('dbo.[Student]','U') IS NOT NULL DROP TABLE dbo.[Student] ...
I want to create a stored procedure that performs insert or update operation on a column if that column does not contains a value that already exists in database it should allow insert when COUNT(field) = 0 or update when COUNT(field)=0 or 1 And I should know that either of these operation is performed or not. Please solve my problem us...
So I've created a cursor on a temp table in a stored proc. However, in the @@fetch_status while loop, this temporary table is changed. I would expect that the cursor will see the new entries in the table it was declared on and will continue looping on them. Is this actually the case or does SQL take a snapshot of the table when you decla...
Hello guys, Here's my problem: I have a website that uses two different nonidentical sql server databases: one that is used to store information about the website users, the other stores information about my online retail store. But my hosting plan would only let me deploy a single database. Hence I want to combine my two databases, to ...
I have a web application which i make on my local host and publish it on different servers. in the web config of this application i have connectionstrings property like: <connectionStrings> <add name="MyConnectionString" connectionString="Data Source=XYZ-PC\SQLEXPRESS;Initial Catalog=SumooHServerDB;Integrated Security=True" providerNam...
what is the best practice for this when converting from an access database or in general ...
I am putting together a schema for a database. The goal of the database is to track applications in our department. I have a repeated problem that I am trying to solve. For example, I have an "Applications" table. I want to keep track if any application uses a database or a bug tracking system so right now I have fields in the Applica...
Instead of writing the SQL query, is there any lazy way to get the data from database in XML format. ...
Hello! I am creating a small search function on my site, this enables the search for articles in the system. Each article has a set of keywords associated to it and these keywords are stored inside a SQL Server database. This is the table: CREATE TABLE [dbo].[SearchWords] ( [ID] [int] IDENTITY(1,1) NOT NULL, [ArticleID] [int] ...
I need to add a delete flag column to all 40 user tables in a database. I could write a script to loop through sys.tables, but I thought I'd check and see if anyone has either a better solution, or pre-created sql for this scenario. ...
Is there an idiomatic way of doing this? ...
Let me start by explaining my scenario: I am developing a quiz engine in C# Asp.net. There is an option to display one question at a time. Since there will be a lot of users accessing the quiz, I do not want to make database calls for each question. Ideally I want to load all the questions on page load, and somehow display one question ...
I'm getting weird issues with ie and firefox when showing image datatypes stored in a sql server 2008 database. Before the images are finished loading/caching there are white lines that flash upwards through them. It is not how images normally load in firefox or ie, any ideas? ...
I want to run a query over a table in SQL Server to save out the data as files. The table has one column with a filename in it and one column that is an image column with binary file contents data in it. I'm sure I saw some syntax that would let me do this, but I cannot for the life of me find it anymore. Is this possible? ...