this is a generic stored procedure:
CREATE PROCEDURE [daab_UpdateCustomers]
(
@CustomerID nchar(5),
@CompanyName nvarchar(40),
@ContactName nvarchar(30) = NULL,
@ContactTitle nvarc...
As a backup precaution, can we just copy all our SQL MDF and LDF files to another computer on the network periodically?
Can you copy these files without shutting down SQL (ie while they ar...
We have a MSSQL 2000 Server and a MSSQL 2005 Reporting Server. The reporting server has been running great with the 2000 backend up until recently.
Recently, because of the departure of a ...
I have a sql data table that contains the following columns
TRADER_NAME, PASSWORD, DISPLAY_NAME, ACTIVE
PASSWORD is a varbinary(20) field and contains the following binary data
0xC9F3230B10...
For some reason, my query is generating an "invalid column name" error on only one server out of many.
I do not want to post the entire query as it is too large but this query here sums up ...
I installed sql server 2005 on a machine called sql2. I had a live machine called sql1. After getting everything all setup on sql2, i removed sql1 from the domain, and renamed sql2 to be sql...
Is it possible and how to change a named instance of SQL 2005 Standard to the default instance?
Here is the scenerio: Currently, the server has SQL 2000 Standard installed. The client would...
Hi, whether I use the maintenance plan wizard or create a simple maintenance plan to backup databases, the plan fails. If I try to execute the associated Server Agent Job, it too fails:
St...
Friends,
I have the following part of my qry:
Seconds=case when ((passingtime*.0001)-((floor((passingtime*.0001)/3600.0000))*3600.0000)-((floor(((passingtime*.0001)-((floor((passingtime*...
I have 2 ms sql 2005 servers when I export from server1 to server2 tables in server2 appear as owned by server1 example:
instead of table dbo.names (as was in server1) I get server1.names ...
Am trying to convert an oracle table over to sql 2005. In Oracle this table had a before trigger on it so that when a record was insterted it would insert the next highest value into the prim...
Angellll helped me create this Oracle function below which allows me to insert a new record into an Oracle 10g table.
I'm able to run this insert statement successfully from SQL Server Man...
My objective is this:
I want to be able to set one of my variables in my Stored Procedure to equal an exact value, i.e. "DISABLED".
Second, I want to be able to pass in a specific workstati...
I am getting following error while I am trying to insert the data to the remote database from the local database.
Error:
OLE DB provider "SQLNCLI" for linked server "69.57.179.9" returned me...
SQL SERVER 2005
How do I format decimal places. A part of a stored proc calculates a goalie's goals against average
(Cast(TS.TotalGoalsAgainst AS Decimal)/Cast(TS.TotalMinutesPlayed As ...
I am very new to SQL Admin-
I created a user and made it the owner of some stuff- Only to realize I was in the wrong DB-
I am trying to delete the user and it won't let me-
It is e...
I'm trying to set up a stored procedure to perform the following:
1: Perform a select query
2: Loop through results of select
3: for each result, perform a second query
4: based on result ...
Hi all,
I am attempting to create a simple internal messaging system and have come up with the following schema. My problem is how to handle the cascading deletes that take place within the...
I notice my SQL Server 2005 uses
SQL_Latin1_General_CP1_CI_AS
collation which ignore case when comparing string.
How can I overcome this limitation?
I'm trying to update a field in table 1 (pricing.mod_type)to = a field in table 2 (archive.pendingmod), but I only want to select the most recent of [archive.pendingmod] based off of a increm...
Hi,
I have the below LEFT OUTER JOIN:
SELECT a.EmpName, b.DeptName
FROM Emp a LEFT OUTER JOIN Dept b
ON a.DeptNo = b.DeptNo
If i need, i can write
SELECT a.EmpName, b.DeptName
F...
Hi,
I need to create a SSRS report that shows data from 2 different Stored Procedures that expect the same two parameters. How do I do this please? One Stored Procedure will return 3 or 4 l...
I am trying to install SQL 2005 Express on Windows 2003 R2. The install fails at the end when it is trying to start the services and the install complete fails.
In the event log I get:The SQ...
I would like to issue this command:
BULK INSERT TableA
FROM 'C:\Temp\TableA.txt'
WITH (FORMATFILE='C:\Temp\TableA.xml');
But I haven't moved to SQL Server 2005 yet.
SQL Server 2000 doe...
I am trying to import data using SSIS from an AS/400 iSeries Database into a SQL Server 2005 Database.
I am trying to use SSIS to import the data. My issue that I am having is that when I tr...
