try to update table
update item
set Field1 = 0 where stat like 'R'
was working fine in SQL 2000
getting this error below on 2005
Msg 217, Level 16, State 1, Procedure preqitemUpdAudit...
Trying to restore a DB to a test DB with BackupExec 12d and we are getting this error
The Virtual Device Interface (VDI) used to communicate with SQL Server could not be configured
Can a...
Hi SQL Gurus,
I looking for step by step help with best practices to defrag my SQL 2000 server to improve performance...I'm a bit of noob when it comes to SQL...Just barely decent to naviga...
Background:
I've just experienced an increased user load on my web application and now I'm getting random timeouts occurring on different pages throughout my site. I know I need to run SQL Pr...
Hi
I have a database with a transaction log of 28g, I think this is because the log has not been backed up which i am now doing. Can anyone tell me how to shrink the log please.
Cheers
I need to sort my DateTime column in ascending order. However, 12:00 PM is returned after 1:00 PM or 2:00 PM in the SQL Sever 2005. Any solution for this?
Hello, I have 4 tables, Plant, Plant_Type, Object and Object_Type.
Plant table
ID
Name
TypeID (linked to ID in Plant_Type)
Plant_Type table
ID
Name
Object table
ID
Plant_ID (l...
We are a small company and run SQL-Server2000 (15GB-Size, bid data storage) and MS Access FrontEnd. I am now thinking of upgrading. For cost-reasons, I think I shall evaluate open-source as we...
Hi,
I have a payroll data file in a text file... it contains all data for pay cheques...
this file starts with file title, with a unique id per file...
then for each paycheque we have ...
Using Mssql 2000 on Windows 2003 SBS
I am using a program which insert records to a table in my database, i dont have any access to change program code or make any sort of modification. is ...
I know this has been asked a lot but I can't seem to find a solution to my problem. Please see Code.
The except statement does not work. I am using SQL Microsoft management studio 2005, I am not sure is database is on sql server 2000 or 2005. The statement does not work for me in gives the ...
Hi all,
Can you use EXISTS (for better performance) in the way that you can use IN? For example...
SELECT * FROM tbl WHERE COL1 IN (1,2,3,4,5,6,7,8,9)
and
SELECT * FROM tbl WHERE C...
I have database on a MSSQL 2005 server. Here I want to create a view that gets data from a database which lies on a different server. This server is an Oracle server.
How do I connect to th...
My SQL 2005 table has the following columns:
[VolumeID]
,[DataID]
,[VersionNum]
,[Seq]
,[RowSeqNum]
,[IterationNum]
,[Customer_Parent]
...
I'm writing essentially my first real Stored Procedure, and I continue to get this error when I execute it, regarding an @return_value, which I have not even declared in the Stored Procedure. ...
I have cerated the one procedure
cerate PROCEDURE [UspSerialNumber]
@strFlag as char(1), -- Operation Flag
@Param1 VARCHAR(8000), -- XML string
@Param2 VARCHAR(20), -- Login ...
Hi-
I am trying to insert data into a temp table using an Order By. The insert works but the Order By does not.
Can anyone help?
I want to write a dtsx package that will loop through a sql table which contains Oracle connection and query info. Within the loop, I want to use the values retrieved from each row of the sql ...
Hi Experts.
We have what seems a high memory hard faults/min count in Windows 2008 x64 Resource Monitor/Task Manager for the SQL2008 x64 Analysis Service process named msmdsrv.exe.
When c...
Hi
having a helluva time getting xp_cmdshell to work in a sproc for my regular users. I am using SQLServer v2008. The users are running the sproc via a passthru query under Access
Here i...
Hi,
I have installed SQL 2008 Server and want an application to connect it from WAN. I have opened port 1433 and the connection itself works. I want users to connect with SQL authentication...
The following query display the result:
id amount rateref handlingincome countervalue
8335 2300000.00 0.8835 0.00 2603282.39954725523486134
8339 ...
We are looking at bringing up a new DR site, and we want to use log shipping to keep a warm stand by. Since we can only purchase SQL 2008 now, we are thinking of just using that. Our productio...
If I have a table with a field that is a date with time.
I would like to get the latest value for a particular set of records.
eg. which would give the best performance (just written the ...
