Alter table tbl_name alter column [col_name] int IDENTITY (1,1) NOT NULL
gives me Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'IDENTITY'.
col_nam...
Hi..
I have a big problem, hope that you can help...
I have windows 2003 server with CA brightstor 11.0 (Build 2670)
and is making backup to all my SQL Servers.
so I need to restor...
Hi Guys,
I have a serious problem regarding my MSSQL2000 Server during the installation. I actually installed it before, but after removing it, when I tried to do the installation again a s...
Hello,
I have a query and I want to retrieve the last 10 rows instead of the first 10 rows.
I know that the typical way is to just switch the order that you sort on.
But, I need the b...
Experts,
I have been on this for days. The primary key in my database is used as a product id, so it is not set to autoincrement.
I CAN UPDATE other fields but not the prodid,
how do i...
I am running Windows SBS 2003 with SQL Server 2005 (installed with Backup Exec 11d) and I am getting the following error in my event logs:
SQLBrowser event ID 3
The configuration of the Ad...
I've got something that's probably simple, but I'm still not that great at SQL...
Sample query:
SELECT SUM(field1) + SUM(field2) AS 'Total' FROM Table WHERE field3 = 'something'
Proble...
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...
In an sp i'm writing, I need to convert an integer value to a string. I usually do this with the cast() function. But this time, I need to left pad the string with zeros. So how do I do this?
...
I have a database called "technical support"
This has a log file called "TechnicalSupport2K_log"
The database is around 250MB but the log file is 6.5GB
Each night I run a backup command to ...
I applied SP2 on Win2003 Server for the SQL 2005 Standard.
Why do I get
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corpo...
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 rotate 186 columns into rows. For eg, what I have is like this:
product date1 date2 date3
A 100 100 200
B 200 200 ...
This is a easy one (Can't for the life of me figure it out)
I want to convert a number to a string by rounding to one decimal place and and then appending a '%' to it, so for example 17.547...
I have table A with two columns
Location_ ID, ITEM_ID
1 location many items (min 1 , max 5 items per location)
In my report I want to concat all item_id delimited by ',' by each loca...
I have a table named Table1 contains records like the following,
field name data type length
------------ ----------- --------
field1 nv...
I have a function called check_sitrep_tree_func which calls a stored procedure called "Up" (which just displays something). When i execute the stored proc (exec Up) it works fine. But, when I ...
Hi,
I have a column in our call management database called ElapsedTime and it is the number of minutes an action took its datattype is an INT. For example in the call management application...
To try to resolve deadlocks in my DB, as per recommendations in BOL and MSDN, I'm going through my transactions, and, in cases where they:
1. select rows from a deadlocking table
2. do lo...
I have a SQL server Database that shows "<Database name>(Loading)...but I cannot be able to stop it. I tried to detach it but I got a message cannot be able to detach a Database that is in a r...
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...
possible or impossible?
we have a database which previously was understood to have backups on it through the inception of the server. we found out today after having dropped tables that th...
I have two Columns that I need to take the Max value of and limit on the higher of the two.
I was trying to do this:
SELECT MAX (COLUMN1, COLUMN2) AS EXPR1
FROM TABLE
WHERE EXPR1 > 100
...
Hello,
I am trying to to execute the following query in MS SQL Server:
SELECT tblProducts.ProductName AS [Product Name],
SUM(tblOrderDetails.Quantity) AS [Quantity Sold],
SUM(tblOrder...
