| |
thread by: Leo Kozhushnik |
last post Jul 20 '05 by: Thomas
Hello there,
Im trying to change the owership of the DTS package but am a little
confused.
sp_changeobjectowner changes the ownership of table, view, or stored
procedure in the current database...
How could i change the DTS package ownership?
|
thread by: Aaron |
last post Jul 20 '05 by: WangKhar
I need a SQL statement to take data that would normally look like this
in a result set (SELECT ID, Name FROM Employee):
ID Name
-- -------
1 Aaron
2 Mike
3 Eric
To look like this, in one row and column with commas separating each
|
thread by: Steven de Vries |
last post Jul 20 '05 by: Matt
Hi,
I'am trying a very simple sql statement but it does not work.
I use the SQL version 8.0
I use the "Northwind" sample database and the Table "Employees".
The sql statement is:
SELECT * From Employees Where City = "London"
|
thread by: Doug Baroter |
last post Jul 20 '05 by: Doug Baroter
Hi,
I'm on SQL Server 2000, say, I have a table named , how I find
if there is any column which has a formula in it? In other words, how
to identify formula column programmatically? I've looked at
information_schema.columns view for clue but to no avail.
Thanks.
|
thread by: Craig |
last post Jul 20 '05 by: Craig
I'm using SQL 7.
Trouble is i've changed the name of my server from ADMIN to ADMINDESK,
since the name change SQL won't run.
How do I fix this?
Cheers
Craig
|
thread by: Albe V° |
last post Jul 20 '05 by: Erland Sommarskog
We're working on a new release of a software.
In the existing version, each client connects and executes a long batch of
analysis on some tables.
In the new release, we need to allow each client to execute analysis on a
subset of data, according to certain login information.
Our idea is:
1) Connection to db
2) Creation of one View...
|
thread by: Peter Olcott |
last post Jul 20 '05 by: Makjalele
Is there some way to save a selection set in SQL
so that another SQL query can further refine the
prior query?
|
| |
thread by: Raj |
last post Jul 20 '05 by: Erland Sommarskog
Hi all,
Can anyone help me with a script which would delete files or
move them to a different folder at some scheduled time..!
Please.....!!!
Thanks in advance...
|
thread by: Cobra Pilot |
last post Jul 20 '05 by: Simon Hayes
I am hoping someone in this group can lead me to some whitepapers that
discuss converting a legacy AS400 DB2 database to SQL2000 using DTS. I
believe the AS400 is SNA so I'll probably need to connect through a Host
Integration server. I don't need the details now, just a high level
overview.
|
thread by: Senthil |
last post Jul 20 '05 by: Dan Guzman
Hey All,
We are running sql 2000 on 32 processor box. It is so weird that
around 4:30 PM every day one CPU spikes upto 85-90%. It continues to
go like that until rest of the day. We checked for jobs that will
start around that time but no luck. Only thing that we doubt now is a
job that starts around 2:30 pm. The job GZIPs the trace file...
|
thread by: Andrew Chalk |
last post Jul 20 '05 by: Ray Higdon
What is the easiest way to copy a record from one table to another (with
identical structure)?
Regards
|
thread by: Peanut044 |
last post Jul 20 '05 by: Erland Sommarskog
Hi all!
I am in need of writing a few stored procedures.
The first one is to create a stored procedure to recover a database
from backup and the second one is to create a stored procedure to
execute a transaction log backup (even though I know this can be done
through a maintainence plan). Any help would be greatly appreciated.
I know...
|
thread by: D. Buck |
last post Jul 20 '05 by: Erland Sommarskog
Details:
MS SQL 2000 dual Intel 1.2 GHz processors.
1 GB RAM
2.1 GB dB
Dynamic Memory Managment.
No other apps running on this server.
First question:
Since I have Dynamic Memory Managment setup, Is it usuall that the
sqlsrv.exe process on the server steadily climbs and is in the 800 to
|
thread by: John Posada |
last post Jul 20 '05 by: John Posada
Hi, guys...new guy here. Let me introduce:
I'm a technical writer for B&N.com and I've been using ERwin
Datamodeler 4, release 4.1.2771 to create data dictionaries. I'm not a
DBA, though I'm slowly picking stuff up.
I discovered something yesterday that from my perspective is quite
serious and I wanted to verify that it is indeed an...
|
thread by: Mahesha |
last post Jul 20 '05 by: --CELKO--
Exponential Moving avg is calculated using the formula.
EMA = (Today's Price)* K + (EMA yesterday) * (1-K)
where K = 2 / (N+1)
The user is going to Input the K.
It is something like
F(N) = Price * K + F(N-1) * (1-K)
How can I reference, the previously calculated value in the Next row
calculation. I need to implement this in SQL Server.
|
| |
thread by: Anthony Altieri |
last post Jul 20 '05 by: Anthony Altieri
Here is the table in question.
Number of records 5512825
not a big table and plenty of good indexs i think? that is the big
questions.
Could some one help?
After the table creation and index you will see a query that takes
almost 2.3 minutes to run this is totally bad. That time is through
the query analyzer.
Any help here would be greatly...
|
thread by: Subodh |
last post Jul 20 '05 by: Subodh Goyal
HI,
I need to run same kind of transactions (basically deleting records)
in a loop but I have only 1 hour in a day to run my procedure. So I
need to set a timer in a SP so that SP terminates after one hour and
then rest of the transactions will be done next day.
Can anybody suggest as how to check execution time in a stored
procedure? The...
|
thread by: Dave |
last post Jul 20 '05 by: clockworkoi
I am doing a complete backup on a sql 7 db and then doing a complete
restore (with overwrite existing db) on a sql 2000 server. This is now
our hot standby server. I have the process automated and it works
great. The only problem I have now is the logins dont work.
I have tried running EXEC sp_change_users_login 'Report', and the
logins...
|
thread by: Subodh |
last post Jul 20 '05 by: Subodh
Hi,
I need to purge date of a table with 290 million records up to 50%.
I'm planning to do in chunks but also needs to truncate the
Transaction log manually(in a SP) after every purge operation. If
somebody can tell me how do truncate T-log in a SP? My DB is running
in simple recovery model and we don't take T-log backups. Its a OLAP
db.
...
|
thread by: Iasonas |
last post Jul 20 '05 by: Iasonas
Hi,
I would like to know how I can replicate an sql server from another
one. I want them to contain at all times the same data.
Thankz
|
thread by: Peter A. |
last post Jul 20 '05 by: uiukin
I need a second opinion from someone out there. I have a database with about
20 tables. Each of these tables need to store one or maybe more images for
each record. I cannot use a varchar field to point to an image file on the
server.
Therefore, I am trying to figure out if its better for me to put an image
field in each table OR make a...
|
thread by: Meyzi |
last post Jul 20 '05 by: Meyzi
How can I add a DTS package into a Job on the Server agent. I have
read here about many problems peolple have encountered using this, but
havent found any instructions how to set it up.
i am also interetsed in creting the DTS package as a executable file
so that anyone could execute the Job or DTS package.
any help will be appreciated....
|
thread by: Nico de Groot |
last post Jul 20 '05 by: Simon Hayes
I have a 2 node Microsoft 2000 cluster with a shared storage device. I
want to create automatic failover for MS SQL 2000 server. I can do
that wit the following options:
1. Active/Pasive (one instance installed)
2. Active/Active (More then one instance/virtual sql servers
installed)
I have a question about option 2.
|
| |
thread by: MEM |
last post Jul 20 '05 by: MEM
I'm fairly new to sql stored procedures. ok, I currently have a stored
procedure that dynamically sorts as well as pages through a recordset:
___________________________________________________________________________
PROCEDURE dbo.ViewAllSales
@Page int,
@RecsPerPage int,
@SortSQL varchar(100),
@varSession_ID varchar(4),
|
thread by: Dave Phelan |
last post Jul 20 '05 by: Erland Sommarskog
I am running SQL Server 6.5 on a W2K server. I recently encountered the
problem described in Microsoft KB atricle 153455. The server has NO
service packs installed on it. I have downloaded sp5a from the MS site
and tried to install it, but I am told that SQL Server is not installed
on the machine, which it is.
I know this is a stretch, but...
|