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...
is there any built-in function or udf to convert Timestamp to Readable date/time format.
pls help me with this.
tnx in advance!
I found this script to check if a column exist in a table and to create the col if not exisiting:
IF NOT EXISTS (SELECT TABLE_NAME,COLUMN_NAME
FROM master.dbo.INFO...
I am missing something but do not know what it is.... i am trying to convert the Amount Field which is a varchar to a float... please Help
INSERT INTO tblLSWA15
(PolicyNumber, CompanyCo...
I have a database in SQL Server 2000 where the MDF file is 61MB and the LDF file is is 5.3GB. I am not sure why the LDF file size is so huge! How can I shrink the LDF file? Will shrinking t...
Is there such thing as a foreach statement in TSQL? or is a cursor the only option here?
I want to itterate through a small result set and it would be nice to have something more susinct th...
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 SQL database (SQL 2000) that has an Access2000 front end to it. Everything works ok for me, but for others it is not. When they click on the table or the report, they get "Connectio...
I want to convert some ntext fields in a table to varchar, keeping the same column name and data. Is there a way to do this in sql?
Thanks, Tom.
Hello All,
I have two tables in oracle database.
1) MOTDC_STG_SHIP_CONF_HEADER_TMP
2) MOTDC_STG_SHIP_CONF_HEADER
Both tables are identical, only first table (MOTDC_STG_SHIP_CONF_HEADE...
Hi guys 'n gals,
What is the easiest way to copy a Table from one database to another, which are located on the same server?
I'm using SQL Server 2000, if that makes a difference?
...
How can I make this query work. The lower(name_cat) appears to be cauing the problem. I tried moving it to distinct lower(name_cat) but that gave the same error.
select
distinct name_ca...
Hi there.
I am coming across a particularly frustrating little error...I've scoured the internet and have yet to find an answer which works for me.
I have installed SQL Server 2000 Rep...
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.
Hi All,
I have an old MSSQL 2000 installation from a previous admin setup here and no one has the SA password. Does anyone know of any utilities to extract/find the SA password, or am I SOL?
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 ...
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 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...
Looking for a stored procedure that will copy a row from one table to another. The row has a unique id field called id. If the row exists in the target the procedure should do an UPDATE. Ot...
Hi Experts
I have tables whose IDENTITY starts at 100; I use 1 to 99 for Test ID's. So, I frequently have to clean out these tables and start again, during development. What is the easiest ...
How can I put an IF EXISTS for both my creation of the constraint and Drop below to safegard from any errors?
ALTER TABLE PurchaseDownload
DROP CONSTRAINT [FK_PurchaseDownload_ProductFile]...
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?
After SP 4 installation on MS SQL 7.0 I found problems with clients (ODBC) connectivity. Connection using Name Pipes works fine, but TCP/IP connection fails. The error message on clients is SQ...
we just virtualized our sql server development box and installed SQL Server 2005 standard edition. Previously we were running sql server 2000. We moved over all the databases and I setup the...
If i have an excel spreadsheet wtih all 50 state abbreviations, names and a country_id column (defaulted to 1) in it. How do i get that excel data into sql express?
couldnt find the tool...
