Viewing 12 posts - 1,336 through 1,347 (of 1,347 total)
have you tried it with inner joins instead of outer joins?
September 12, 2006 at 11:52 am
Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]User does not have permission to alter database 'WebDB'.
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement failed.
[Microsoft][ODBC SQL...
July 25, 2006 at 11:18 am
it's not set to drop tables, just replace existing data. I tried changing some options and still doesn't work. and giving create table or db_ddladmin doesn't work either. Only dbo.
The...
July 24, 2006 at 12:57 pm
in my experience the SAN guys just cut up the space to make their life easier and repeat things like the SAN has cache to make up for the shared...
June 26, 2006 at 1:09 pm
thanks, works perfectly
i changed it a little and here is the final one i'm using
select
b.close_price, b.date
June 6, 2006 at 9:45 am
thank you
i'll be trying this in the next few weeks and will compare it to simply having SSIS jobs scheduled and downloading data manually
June 6, 2006 at 9:10 am
have you looked into products from wild packets and other companies?
May 16, 2006 at 8:28 am
you need to set up the disk volumes for the other instance and run SQL 2000 Ent set up again to create a new instance. Then transfer any DB's you...
May 16, 2006 at 7:58 am
we run veritas and i have changed all the backups to be SQL jobs that use xp_cmdshell to call a batch file that calls the veritas executable with the backup...
May 5, 2006 at 12:57 pm
I'm new to the SQL stuff and come from an exchange backround. I got some great performance improvement from taking the public folder databases and putting them on separate servers.
I...
May 5, 2006 at 12:51 pm
Where I work we ship SQL databases daily to another remote EMC unit via SRDF and backup daily copies to tape via Veritas 5.1 enterprise Server or whatever it's called....
February 27, 2006 at 9:26 am
If you have a problem with SQL, is Microsoft going to support it on Veritas? I'm a new DBA, but one of the last things I did in my past...
February 27, 2006 at 8:54 am
Viewing 12 posts - 1,336 through 1,347 (of 1,347 total)