We have an ordering system written in Access with a SQL back end that's replicated to a web site SQL server (the web side is working fine). Ever since the client has installed SP4 for SQL 2000...
Getting this error when I try to install Idera SQL backup and Quest Litespeed.
I've been using the following C#/SQL combo to get a solution. It works as-is but I would like to have a pure-SQL solution if possible.
[C#/SQL Combo]
string strCurrentTimeOnly = DateTime.N...
Immediate help appreciated.
This morning when I came in, my computer was indicating It was completely out of disk space. When I looked at the hard drive space, it was completely full. It w...
Hi Experts,
I am in the process of creating a query in SQL Server Mgt. Studio ( SQL Server 2005 ). I am trying to compare accounts gathered from certain criteria for the current month and ...
Summary: How can I update two tables with one sql statement?
Details:
The AP Invoice has two tables ... HIST and INVC.
I need to update the EXPPED field in each Table. When I attempt u...
I have a simple table that has data I need to export to an XML formatted file. I can get the data formatted correctly when it is one record but when there is 2 or more the Select..for XML exp...
when i try to import data through DTS package and i am geeting some error as attached
Hi.
I am using VB6/ADO to perform a backup of an application master database, then restoring it (changing the filenames) as a new client database. (We are a web dev company and use a gener...
in oracle i use this sql statement ot get system date (select sysdate from dual); it returns date and time . what is the equivalent in sqlserver
Hello,
I would like to write some SQL that loops thru the results of a SELECT statement. As an example, if I have a table DEPT with column NAME, I'm guessing the code would look something ...
Hi, I want to know if it is posible to schedule a job using utc datetime. I have a database in other region that have a different time zone and it also have Daylight Saving Time that is not ap...
I have a 'person' table that has the following fields among others:
PersonID(primary key)
FirstName,
LastName,
DateOfBirth,
LicenseNumber
ClientD
LastVisitedDate
I have a second tabl...
I am looking to produce a report which summarises the users with access to each of our SSRS reports.
I would assume this is all stored in the [ReportServer] database, but can't find any dat...
We have an SQL database 1.9G in size (OK) and after some trouble with the SQL maintenance plan, the .trn file grew so large it has become a problem (40G.)
1st and foremost, we need to reduce ...
I am having some difficulty locating the cause of php webpages loading slowly through IIS. The php code uses several select statements with no joins. I think I have isolated the problem to com...
I need to bulk copy data from one database to another. I can't use SqlBulkCopy class because it only appeared in .Net 2.0 and I'm on 1.1 with no chance to upgrade.
What I have is:
- connecti...
Hi all,
I have the following BCP statement that I cannot get to work:
bcp partman.dbo.export_part out c:\test.csv /U /P /sqlsvr1 /c /t
I am hoping to export the data from table export...
I have a db that has a main table [tblClients] and three large tables [tblScreenings] [tblIntakes] [tblMedical]. tblClients has a one to many relationship to each of the other three tables. Ea...
Hi All,
I am using the below query to export the results of the select query into SHEET! of excel file testing.xls but it comes up with an error as follows:
[OLE/DB provider returned m...
We recerived following error message on SQL Server.
"SqlDumpExceptionHandler: Process 83 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this proces...
I have a complex query, from a subquery. I'm trying to return a unique column. Here is a simplified example: (Note: EMPID Should be unique, taking the latest FINISHDATETIME, if there is a dup)...
The following block work fine in studio
select int_custodial_agent_nbr into #tempCA from [IND-2].dbo.custodial_agents where int_custodial_agent_id = 14 DECLARE @table varchar(20), @str_sql...
How do you run another script within a master script?
TIA
Hi there,
I was wondering if you can point me in the right direction; I would like to enter data into a table, but would like to alter some fields, depending on the value of the data: (ie. Ac...
