I cannot figure out how to do this. How can I create a connection to an ODBC data source (already set up as a System DSN in data sources) from Microsoft SQL Server Management Studio?
[SQLSTATE 01000] (Message 3014) Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] (Error 3101) RESTORE DATABASE is terminating abnormally. [SQLSTATE 420...
is there a way to add multiple columns to a table with one alter statement? does Sql Server even support such?
New to SQL Server 2005. I'm wanting to batch upload data from a remote system (VMS) into a SQL Server 2005 database. I've scripted out into files, the commands I need to create the table(s),...
I have a sql 2000 database that has been made suspect by having the log file deleted then replaced with an older copy. This is what happened. The database went into readonly mode because the...
Hello,
I am using MS SQL, I am trying to update blank data on one table with data from another table. There are multiple columns I wish to update which are for example: "fullname", "descrip...
i need to truncate this log file, 8Gb
documentation says i have to back it up and select the truncate on checkpoint option.
only thing is, from the server manager, when i do the backup, the...
I have been working on a local copy of a db (localDB) and have made a lot of changes to some tables and added some as well. The live db (liveDB) is on a shared host and is still active. So the...
I get "Cannot connect to WMI provider" error everytime I open SQL Server Configuration Manager.
Can someone please take a look
Hi,
I know Oracle uses a MOD function like Basic's to determine the remainder after a division. So 20 MOD 9 = 2 (9 goes into 20 twice for a total of 18, 20 - 18 = 2). I need to deter...
How do you within a query using sql 2000 convert a number in seconds....into hours and minutes...
Thanks
We are developing an Intranet for our organization and are using SQL 7.0 as the database for it. We have a content table with a field to hold the text for the various html pages. Can somebod...
How to find Size of Each Table in Database?
Something like TAble1 = 345Kb
Table2 = 3MB
Something like that.
Hi there
I have a problem on my SQL Server 2005 - I don't seem to be able to run table functions (scalar I can), i can create table functions but not run them:
set ANSI_NULLS ON
set QUO...
Hi there,
Is it possible to get the client process ID of an application that runs on SQL server?
We have a MySQL v5 database that sits behind a website on a web server.
A PHP script is used to take records and insert them into an SQL Server 2000 database that resides on another server....
Is there a function to get month name using integer value 1 to 12 in MS SQL?
Eg. 1 return January, 2 return February, 3 return March so on ...
Curious how to accomplish/correct syntax for the following in T-SQL...
Database Name: TestDB
Existing table name: MyTable
Existing Column Names: ID, NameFirst, NameLast, MyDate
Want to...
I know this is a newbie question, but can anyone tell me how to reset the auto increment field of my table to 1 or it's original value.
I've been using these tables for testing and the auto...
How do you reset the IDENTITY seed on a column in a table using a T-SQL statement?
My situation is that I've written a stored procedure to copy data from from one table (AccountOld) to anot...
I renamed my laptop which has a copy of SQL Server 2005 running on it. When I rebooted after renaming the machine I tried running an app which uses the ODBC connection to the SQL Server databa...
I would like to update a column in a table with a string. Later on I would like to add to that string.
I tried the following query,
"update TABLE1 set COLUMN1 = COLUMN1 + 'TEST STRING' ...
If I run this query on my database:
DELETE from products
WHERE id='30'
I get this error:
Delete statement conflicted with COLUMN REFERENCE constraint 'FK_product_g_prudu_OF582957'. The ...
Hi,
We have a text field called Product that comes as:
12 TheNameoftheproduct
I would like to use substring to split the value into
ProductNumber = 12
Product Name = theNameofthepro...
Hi,
I just installed Microsoft SQL Server Developer Edition on a Windows XP Workstation and I get the following error when I try to open Enterprise Manager:
The prodecure entry point ?Proc...
