There are 2 table, table "user_table_a" and table "user_table_b", which are the same except that table "user_table_b" has 1 more column than table "user_table_a". I use this SQL statement to c...
Got this error when I tried to restore AdventureWorks sample db
Could not find row in sysindexes for database ID 7, object ID 1, Run DBCC CHECKTABLE on sysindexes.
COuld not open new dat...
I am trying to connect to a linked server and keep getting the error Login failed. Not associated with a trusted SQL Server connection.
When I look at the server the user has permission. ...
I have two tables like the following, using MS SQL Server 2000:
Table A:
ID Date
--- ------
A1 1999-01-08
A2 1999-03-02
===================
Table B:
ID Date Amt
...
Hello,
I am tring to create a new instance of SQL SERVER through Command Prompt,
the utility called "osql" create new database but not the new instance.
I need a command through ...
If you need to alter more than one column in a table, does MS SQL support doing this in one ALTER TABLE statement?
Or is it necessary to use multiple ALTER TABLE statements?
I have a column named "Chain" in this this column has multiple values each seperated by a comma. Is there any way to remove or replace the last value, ie anything after the last comma.
I am using SQL Server Management Studio Express 2005 and I am trying to create a database from a backup file. I have done it before in here, but this time I am getting the attached error. I ...
Hello - my computer has crashed so I had to re-install the complete system incl sql server 2005 and tried to restore a mdf database file from a backup. Unfortunately, this is only a copied mdf...
I run MSDE on a Windows XP Server and i found that my database was marked as "suspect" by Enterprise Manager and its icon become gray.
I detach that database and try to re-attach it but there...
When running a query after attaching a database, I get the following error:
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space....
I am trying to rotate 186 columns into rows. For eg, what I have is like this:
product date1 date2 date3
A 100 100 200
B 200 200 ...
Ive lost my MS SQL Server disk and I need to use Enterprise Manager and other tools. Can you download these tools? I cant find anything on the MS site...
How do i compare new and old value in a trigger after update?
if update() is no good because i want to know if the value is changed and not if the column was updated.
Keren
I'm looking for dates in an SQL table, but the results are incorrect.
The datetime column looks this way by opening and viewing the table in SQL Enterprise:
8/10/2005 9:44:41 PM.
My q...
Hi Experts
I have a SP that creates a varchar(200) string that creates from a table entry such as (A+(0.75*B)) a string such as (0.093000000000+(0.75*0.004087939911))
I now need to evalu...
I have a field in table Appointment called Memo (type text)
I would like a sql script which will remove all carriage returns in the text of the memo field and replace with a space or colon or...
Hi again,
I need to create a function that returns a boolean value, to be used in a CASE expression.
I have tried with 'RETURNS BIT' but it is not considered as boolean an SQL fails in the c...
What is the 9.00.3054.00 version of SQL Server 2005?
SQL Server 2005 Service Pack 2 is 2005.90.3042, so what is 3054?
How do you within a query using sql 2000 convert a number in seconds....into hours and minutes...
Thanks
I made a Conversion Program in vb6 (access to sql) with SQL having no Identitys in the table So i can preserve the RowID and then hoping after the converision to alter the column to put the ...
Hi Guru:
I work with Oracle but is completedly new to SQL Server. I was required to create database and restore from a dump file (I would think that it likes oracle's import). The dump file...
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...
Hi,
I am using a SQL Server 2000 DB, interrogated by Enterprise manager.
I can SELECT as:
SELECT c_AnswerMutli.*
FROM c_Applicant
INNER JOIN c_AnswerMulti ON c_Applicant.id = c_An...
hai there
I am developing an applicatin in VB and SQL SERVER 2000
I pass a date value (24/03/2005 10:33:27) from a text box to a stored procedure varchar variable
in stored procedure i w...
