Top Solutions

Hello.  I have a question about UPDATE with INNER JOIN.

UPDATE         AliasA
SET                AliasA.CarMaker = mstMakerModel.Maker
FROM            tblCarAuctionList AS AliasA INNER JOIN
                      mstMakerModel ON...

I have a Windows SBS 2003 Server, Service Pack 2, 2gb ram and 200gb disk.

I have installed MS SQL Server 2000 with its latest Service Pack 4 and left in tact its standard "MSSQL Desktop Engine (SBSMonitoriing)" and "MSSSQL Desktop Engine...

Hi,

I have a DateTime variable:

DECLARE @Date datetime
SET @Date = '2007-07-20'

After I'm done with this, How can I modify the @Date variable to something like this:

DECLARE @ModifiedDate datetime
set @ModifiedDate = @Date...

Hi Experts,
I have a single SQL Server 2005 (running on Server 2003 std) which refuses to install SP4.. I have pasted the logs and the "SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log" it refers to in the event log as an attachment.

I have searched...

Windows SharePoint Services 3.0 running on Windows Server 2003 SP2. Everything was working fine. One morning, at 3am, the server installed a Windows update and rebooted. After that reboot, all we get when trying to hit our SharePoint site AND the...

I have SQL Server Std. running on a Win 2003 server. Everything has been fine except for the past few days the Default Instance/Service does not launch anymore. I have uninstalled and reinstalled it but to no good. I do login as Administrator on...

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 "Connection Failed - SQLState: "28000" SQL Server Error 18456. ...

i have a table with students details in it, i want to select all the students who joined a class on a particular day and then i need another query to select all students who joined classes over the course of date range eg 03/12/2003 to...

I am currently doing a Backup Plan for my Databases.(FULL Mode)

I have a database of 28MB but its log file is around 8000MB! How will i manage to clear the Logs?

I tried the following:
1. Full backup of the Database.
    (Size of Full...

Hello,

In SQL-Server, I'm trying to find the equivalent of the following SQL statement:

      "CREATE TABLE employees AS SELECT * FROM all_emp"

I know you can do this with to create a view in SQL SERVER, but is hasn't worked with a...

Hi,

Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.

This error happen when I tried to insert a value too long in a varchar column:
(insert "123456" in a column...

Is there anything wrong with this query? I keep getting a error saying

Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'IF'.  
 

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...

I am getting a large number of large tmp flies (about 170-190MB's each) on the C:\Windows\Temp Folder on an SBS 2003 Server.  Does anyone know why these are being created and how to control them?
Thanks.

I have a somewhat complex select, which is supposed to return appointments that need notified bewteen today and the appointment date. Sounds simple, but, the appointments have a notification date...which depends on how many days in advance the...

I have a SQL Server 2005 database, and it's data and log files reside on drive E:\

Hey is there an easy way to move the database (mdf, ldf) files from one drive to another?

What would be the steps?

Thanks.

Hello Experts!

We have CA Arcserve backup running.  Currently they fail with the following errors:

E8535 2010-06-24 05:39:19 Failed to receive data from the agent.

CA help suggests to do this:

1. Increase receiving and sending timeout...

I need to use (I think) the GETDATE() function to return the current date, but I need to make sure that it is only the date and no time, or at least time to be 0.
Is this the right way to go about it

CONVERT(DateTime, CONVERT(Char, GETDATE(),...

Running MS Small Bus. Svr with SQL 2k, both with latest non-beta svc packs.  Have about 8 databases.  ALL show status as NORMAL.

ONE of the database will not complete a good backup - all others will.

Have tried numerous times (with Ent....

Msg 3930, Level 16, State 1, Line 49
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.


what does this mean?

We are in the process of having a company upgrade our current Citrix XenApp farm from 4.5 to 6.5.  The old 4.5 farm utilized a SQL 2000 box that has since been virtualized.  We are implementing a physical SQL 2008 R2 Standard box to host a couple...

Log Name:      Application
Source:        Blackberry Notification System
Date:          31/08/2011 3:18:41 AM
Event ID:      373
Task Category: None
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      ...

Using the install cd, trying to install v2008 R2 Developer Edition on my laptop.  Windows 7 Professional, 64bit OS.  Have had v2005 and v2008 here before, but removed it all before this installation.  Installation begins fine, but once it reaches...

I have a SQL Server that has been working fine for the past year.  But all of a sudden when I rebooted my server I got this error:

"The SQL Server (TESSI2005) service terminated with service-specific error 17058 (0x42A2)."

 Everything that...

Hi.

I have a large number of databases on my MS SQL server.

There are files .MDF and .LDF files. From what I can tell (and I may well be VERY wrong here), the MDF file is the REAL data. The LDF file are changes yet to be merged into the...

We bought a new Dell MD3200 DAS (NOT iSCSI) This is connected with the MiniSAS cables.
http://www.dell.com/us/enterprise/p/powervault-md3200/pd

I have 2 Windows 2008 R2 servers which I would like to Cluster SQL on, I already have some good...

Attempting to repair_rebuild database.
1. Stopped SQL services by running sqlservr -m within the command prompt
2. Logged on as Sa within Query Analyzer
3. Executed command Dbcc Checkdb('SalesDW', Repair_Rebuild)
* Received Error: Repair...

I recently installed SQL Server 2005.  I see by going into SS 05 that I have an sa login. I don't remember supplying or being asked for a password for sa at installation.  I can open up the sa and see the properties.  It has dots for Password and...

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 logins for the database...same as they were before.
...

Hello,

I am trying to execute a stored procedure from a VB6 application - get an error message telling me thta execute permission is denied.

Have read elsewhere on this site that I need to grant the user EXECUTE permission using a statement...

How do you refresh a DataGridView with the current contents of the database after you do an UPDATE?


Private Sub btnUpdatePosition_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdatePosition.Click
       ...

Here is my statement:
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = SIM20050214) DROP TABLE SIM20050214

Here is the error:
Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'SIM20050214'.

What...

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]

delete from ProductFile
where ProductID in...

Hi all
I was in process of writing a php code to connect to MSSQL database and get details out of there to show in my application, The MSSQL DBN contains a field with encrypted data and i have written php function to get that decrypted fine, ...

I have a SQL 2000 DB with collation SQL_Latin1_General_CP1_CI_AS, I am attempting to upgrade and host this in SQL 2005 Enterprise x64 bit.

When I run the installer for SQL Server 2005 I get server collation option to install as Latin1 (which...

Hi Experts,

How can we convert a variable @presentdate to varchar?

Declare @presentday as datetime
select @PresentDay = convert( datetime, convert( varchar(10), getdate(), 101 ))
select * from table where date1 = @presentday...

Hello,

In our SQL Server database we have money values that are negative.  But I need to convert all negative values to positive values.  I am using the following code in Query Analyzer:

--Convert all negative numbers to positive numbers...

I'm writing a SQL Query in VB2003 against an MS SQL Server 2000 database.  Basically, I"m trying to replicate an Access query (which works) in MS SQL language.  The problem is, I can't seem to make a nested CASE statement work.

Here is my...

I need to update a field of a table that is itself used in the query to determine what to update.  The only error I get out of SQL is a general syntax error.

UPDATE tblInvoice_Master SET tblInvoice_Master.PercentSalesTax =
SELECT
      TaxRate...

I have a SQLServer, which was a installed on a stand-alone machine, running fine. I attached it to a domain and I am trying to install Microsoft CRM 3.0 on a seperate server, using my newly attached SQL server as its database server.

With that...

Hi,

I don't know how to add an administrator of the administrator users of SQL Server Analysis Services in SQL Server 2008 ?

During the installation of SSAS, the installer provides the option of adding one or more Administrators (Tab...

Hi all,

I've been tasked with getting WSUS working again on our network, as it had lain unused for quite for some time. Initial investigation simply revealed that all was working fine, but that the updates were set to only download once...

I'm apparently confused about the way SQL works with a LEFT OUTER JOIN.  Below is a sample statement I am using for summing InvAmt, PmtAmt, CreditMemoAmt.  Payments and credits are based on a join of Invoices.

SELECT a.contact_id,...

I do have a problem I am stuck with for 2 days:

1st and important: It is a winApp, not an WebApp
I am using VS2005, C# on WinXP.

I have an c# object (a class).
I want to display these objects in a gridView. It should be updateable,...

We are getting this error in event viewer on one of our SQL 2000 servers:

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).


The SQL Server itself is running fine, but the...

Hello,

I need to be able to update the SQL command default timeout of 30 to something greater.  I KNOW this can be done super easy through code, however, I do not have that luxury and need to do it through a config file for deployment reasons....

Okay so If I do...

SELECT * from orders

the 'OrderDate' column is formatted like '2007-03-28 16:29:35.000'

but if I do

SELECT * from Orders where OrderDate = '2007-03-28' then nothing is displayed.

What I ultimatley want is to do ...

I have a table with the following columns

ACCOUNTID     CATEGORYID
1001                10  
1002                10
1003                10
1004                10
.....                  .....

I would like the table to look like the...

Hi,
I have been running some scheduled batch jobs for a period of time on sone large files overnight.
I have a SQL job that updates a table with about 700,000 rows.
This has been running fine till recently, where I am getting the error...

( Product : DBMS -> ORACLE, DB2 and SQL Server )
Hi Experts,

I want to know the difference between the functions SYSDATE, CURRENT_DATE, CURRENT_TIMESTAMP in ORACLE, DB2 and SQL Server.?

What does CURRENT_DATE in oracle do ? Is it date...

I need to install SQL express on my SBS 2003 for CA Brightstor Arc Server backup 12.1 but each time I attempt to install the SQL the installation fails. Attached in the code section is the installation log.

Back ground on the server. I just...

I have the following stored proc (see below) which works very well to save a big chunk of text to a text file.  How can this be modified to accept one line at a time and append the text to my text file?

I need to take into account the fact...

I get the following error:
Msg 1087, Level 15, State 2, Line 16
Must declare the table variable "@table_name".

In the following code:
=============================================
DECLARE c CURSOR FOR
      SELECT table_name FROM...

Hi,
I have a SSIS package that also sends files over FTP
It works great inside BIDS..

But when i copy the Package across to to production it fails with the following

Code: 0xC001602A    Source: Package Connection manager "FTP Connection...

My company has a MDSN subscription and use it to install almost everything. What I want to know is what does the MSDN cover?

I have a query that works currently and inserts
the date and time into a table. How can I pick a different format like 1 or 8, instead of the current format that is being used by default?

INSERT test (ImportDte)
VALUES ( GETDATE() )

This...

We are currently using SCCM 2007.
It's been working fine up until a few days ago.
Recently i opened the Configuration Manager console and noticed a red cross against the Component status and Site System status folders.
If i go into the Site...

Hi,

I am trying to start SQL Server 2008 R2 services following on from a scheduled restart and am receiving the following error message:

'Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information review...

I am recently unable to connect to connect to the MICROSOFT##SSEE SQL instance using SQL Management Studio. It houses my WSUS 3.0 databases. Upon starting the server I see this error in the event log:

Event Type:      Warning
Event Source:...

Hi all,

Let's say you have 2 tables (UserSecFunctions and UserInfo). The UserInfo table holds all UserIDs you need to insert into the UserSecFunctions along with some other minute data. How would this statement be written?

I would assume...

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 Transaction Log radio box is greyed out

Hello,

We are new to MS SQL Server Management Studio and need to export a table to a csv formatted file. We figure there must be a wizard or some function to do this but have not found it.  Could you give us simple instructions on how to do...

Trying to use LIKE in the CASE statement but not working for some reason (won't execute).  Any tricks to using LIKE within a CASE expression?

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?

I'll define a couple of tables to help clarify the question.
MainType
MainTypeID     MainTypeName
1                     car
2                     truck
3                     boat
SubType
SubTypeID     MainTypeID           SubTypeName
1   ...

Hi. We installed a ECC 6 Server (abap+java) with MSSQL 2005 with SID:T13 & updated all patches in the system. Later we did a system copy & named it a T14.

IN SE06 (post-installation activity); First we selected 'standard installation' instead...

I've got an SSIS package that I've been trying to adapt to use distributed transactions. Whenever I set the TransactionOption to "Required" in the outermost container, everything stopped working. The only way I could get any SQL steps to work...

I have a stored procedure that receives 20 different parameters as fully built Insert queries...The potential exists though that some of those parameters may be passed to the stored-procedure as empty or nulls.  I need to check to make sure that...

After installing SQL 2005 Reporting Server, I'm unable to start the HTTP SSL service. The Event Log shows the following:

The HTTP SSL service terminated with the following error:
The system cannot find the file specified.

I don't know...

Just wondering if it is possible to use the case statement to determine what to execute in a stored procedure.

The code snippet shows an example of what I'm trying to do. The select statements are the same because I haven't finished them yet,...

Hi all

In SSIS, I am trying to parse together a string (hard-coded) and an double (column) as another column, with this expression:

"Debits are " +  [debits] +", and credits are" +  [credits] +", difference is " +  [debits] - [credits]
...

I have just run my SSIS package through SQL Agent and recieved the following error.

"component "Schedules01" (426)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".  End Error  Error: 2009-05-24 04:16:10.30     Code:...

When I look at my DBs in the MS SQL Server Management Studio, I have three DBs that say (In Recovery) next to their names.  One of the DBs have been this way for over 12 hours.

What is the server doing when it says this? If this is an OK...

ALTER TABLE dbo.TCONTACT_TEST ADD
       LVL_SYS_NR INT AFTER  ACC_NR_TE,
       CNT_FAX_NR_TE VARCHAR(15)AFTER CNT_PHN_EXT_TE

----This brings up an error on the word AFTER

Hi All,

Have a strange issue i cannot seem to find a reason for. When attempting my installation, at the Server configuration page - I am unable to assign the service account name DOMAINB\S-CA-SqlServer as the running account.

When I select...

Hi

When I type the following in SQL Query Analyzer

SELECT DATEPART(ww,GETDATE())

Result: 45

But the actual week number is 44

Is there anyways to fix this - since some years have 53 weeks and some 52 weeks

Thanks,

kris

Hello,
when i run this stored procedure i get an error message saying :
"Server: Msg 203, Level 16, State 2, Procedure spUPLOADOUTOFSTOCKS, Line 27
The name 'INSERT INTO DBO.OOS_UPLOAD (SITE, SKU, ID_BUCKET) SELECT DISTINCT O.SITE,...

I have a SQL Server 2005 Express installed on my Intranet server that resides in my DMZ.

I have access from my LAN to my DMZ open.

I have the SQL Server configured to allow remote connections to the server.

When I attempt to access the...

I'm a sql newbie witha n oracle query giving an  ORA-01427 Error

UPDATE FIPS_CODE
SET GROUP_CODE = (SELECT group_code FROM GROUPS WHERE GROUPS.FIPS = fipscd)
WHERE EXISTS (SELECT group_code FROM GROUPS WHERE GROUPS.FIPS = fipscd)

there...

Hello all, I've spent hours troubleshooting this and I need some fresh perspective . . .

We have a relatively simple report setup in SSRS, simple matrix with columns across the top and data points going down.  The SQL query behind the report...

Where can I find a (64-bit supporting) odbc driver for windows to connect to the iseries as/400. I can't find it anywhere on IBM's site?

Thanks!

I am looking for code to return yesterday and today regardless of time of time code runs, in other words,  if getdate when I execute returns  6/27/05 11:09 am, I want to be able to return 6/26/2005 and 6/27/2005.
Thanks in advance.

I have a nested query that i am running in SQL Server 2005 that pulls data from a different database that is in Oracle.  I am trying to make my query pull records that are always dated one day back, all records for that day.

When I try doing...

I've been tasked with moving a bunch of code from dynamic SQL to stored procedures and I've run into a bit of a problem with a search function.  The nasty little bit of code in question generates a huge SQL statement something like this:
...

Hi
Does anyone know whether this is possible.

I want to insert 2 values into a table, only if 1 of the values match the value in a table column

i.e
@Number VarChar(100),
@Code VarChar(400)
AS
insert into mytable
(NumberValue,...

Hello Experts,

I have a new installation of SQL 2008, and have used the copy tool to copy over a database from SQL 2000.  Everything looks fine from the manager, however I can't determine how to change a password for a SQL user.  (Not Windows...

In SQL we can do the following

insert into Test(va1, va2, va3)
select va1, va2, va3
from Other
where ......

How do I do the same thing like above but in format of update-select ?

I'm getting an error which is resulting in the sql server 2005 database being inaccessible and fatal errors from .NET -

 ERROR [HY000] [Microsoft][SQL Native Client][SQL Server]Warning: Fatal error 9001 occurred at Aug 22 2007  8:43AM. Note...

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 database and received the following error:

Error...

Can't quite get my head around this Run-Once script, at the moment, appreciate any quick help, so I can get on with my favourite job, reviewing all the uploaded images, for approval. - LOL...

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 case so I have to use:
SELECT CASE WHEN...

Hi experts

My SQL query :

SQL = SQL & " AND ((cint(ShipOther1) <= " & ProdWeight & " AND " & ProdWeight & " <= cint(ShipOther2)) "
               SQL = SQL & " OR (ShipCost1 <= " & ProdWeight & " AND " & ProdWeight & " <= ShipCost2)) "
...

Hi,

We are developing a report in MS-Word through VB application.  Our database is SQL Server 2000. We are getting the following error while generating the report:-Error Number -2147467259, ODBC SQL Server Driver  timeout expired.

(This...

Select OrderID,
'Sell--' + Convert(varchar(24), sum(CAST(Price AS DECIMAL(13,2))) )
From OrderDetail
GroupBy OrderID

I want to display price as varchar but somehow above code send an following error
"Error converting data type varchar to...

I am using AspxGridView control and want to redirect to another page by clicking on the edit button. which type of column can be used to get this redirect. I have already tried something like this

<dxwgv:GridViewDataHyperLinkColumn...

I am having the worst time with this... lord knows what I'm missing.
v2008,  have a very critical solution driven procedurally across the data layer.  it traverses mutliple servers, basically doing reconcilation on demand.  if/when it is needed,...

I've inherited a SharePoint server that I need help getting access to the database.  I'm a domain admin and I have the account I think the sharepoint was installed as, but when I connect to the local servers instance and try to view the...

Hi All,

I am needing to create a temp table using Where NOT EXISTS.  I am trying to compare data from the temp table and a permanent  table to see how much data is missing.  What am I doing wrong?