Hello,
I am trying to get our Disaster Recovery plan in place here, but I am running into problems trying to backup our SQL 2005 databases.
We are running SBS 2003 R2 Premium, I have in...
I have a query that pulls back a recordset based on a user provided organization code. If the code is 4 characters long it needs to match one record, if 5 then another, and if 'All' then it j...
MS SQL 2000
vb.net
Hi experts
I have a question
On sql server I have this table, which contains the next columns:
ID checkInDate checkOutDate sVID
1 10/14/2007 10/19/2007 2
2 ...
I want to be able to change the reply-to address of emails sent from SQL Server but I can't see how to.
Is there a way to do this?
We are running SQL Server 2000.
I have an employee database and I want to restrict access to specific tables to only a couple of people not including the Network Admins. What would be the best way to go about doing this seei...
I have an assembly which reads an XML file from the Internet, parses it and updates a MS SQL Server 2005 database. This works perfectly if run standalone.
My problems arise after I registe...
I have an MSSQL Server 8.0.2039.
I have 4 user databases on this server. The transaction logs for 3 of the databases grow normally and are usually ok to shrink with a script that can shrink ...
I have an existing query that I thought was right. It turns out that it's not counting distinct records because I have the Group by User. I can't figure how to do the Case statements without...
Hi,
I have a production server having 2-3 data and about 2-3 log files per database. All of these files are in primary filegroup. Previously there was space issue for which files were Some of...
Experts,
The raw data file I receive looks something like this:
**note: IDENT is a Identity field
**note: the value "(new)" actually appears in the field
PatientID, Med1, ...
I am back into the Crystal Reports XI R2 Designer again (after a very long layoff) and I am trying to make my first-ever cross tab report. To model the data, I made a query in SQL Server 2000 ...
Ok whats wrong with this MS SQL statement? I'm getting Must declare the scalar variable "@Clients"
ALTER PROCEDURE ActiveClients
(@CID int)
AS
DECLARE @Clients TABLE
(ClientID INT,
...
I have a patient database I am trying to INSERT or UPDATE data, with values parsed from an email, depending on whether the patient already exists in the database.
To parse the email I am us...
I am trying to call a file from appliation server ( xls file ) to imprt into table using DTS ...
but its giving foloowing error
Source I have provided is \\IP\C$\Filename
DTSRun:Loading...
Data migration question
I need to import data by doing a cross check as follows:
Source tables
tblPerson
personID (int), FirstName, LastName, Address1
TBLPERSONDETAIL...
How come I get an error when inserting a date like: 20000202
and NOT get an error with : 2000February02 ??
string DOB = "";
DOB = ddlDOBYear.SelectedItem + ddlDOBMonth.SelectedItem + dd...
I have a Microsoft SQL 2000 server in which I have created Linked servers to Adaptive Server Anywhere and Advantage StreamlineSQL Driver ODBCs. In the 2000 version I can see the tables that t...
What is the difference in how sql 2000 and sql 2005 instances?
Hi Experts,
When I attempt to run an aspx page that requires a database connection I get the following error:
Exception Details: System.Data.SqlClient.SqlException: Login failed for user...
hello there,
i want to create a chart where i have time on X-axis and Traffic on Y axis.now i want to subtract the previous value of traffic with the next value and show it on the graph and...
Does any know of a official url/link which shows the desupport dates/matrix for SQL Server 2000/2005.
Hi.
I am trying to restore a 2005 database, but I keep getting the following error: "System.Data.SqlClient.SqlError: Directory lookup for the file". Any help with this would be much apprec...
I have two SQL 2000 servers Prod(A) and Test(B). I currently have a job on (A) which runs some stored procedures and restores a live database to test via a linked server.
On completion of t...
Hi
I have three update queries given below. I want to covert then in to triggers so my REQ_COVER table is upto date which rely on the info from other tables.if there is a other automatic me...
SQL 8.0
Windows 2003 Server
Linked server to Oracle database
When I type the following in I get a result set back:
SELECT RPICU, RPDICJ, RPVINV, RPDIVJ, RPAN8 FROM
OPENQUERY(MMM_...
