Forum Replies Created

Viewing 15 posts - 1 through 15 (of 19 total)

  • RE: Restoring a SQL2000 bkp on SQL7

    That's what I thought but just to be sure ...

    Perhaps a parameter when performing backup ? no?

  • RE: Backup problem

    Did you tried to put the 'INIT' parameter in your backup script ?

    (Hope you use a script 'cause I do not trust the Entreprise Manager's wizards)

  • RE: Backup of DTS packages

    Fine, the MSDB of couse.

    Thanks a lot

  • RE: SQL Mail

    OK I'm back.

    The problem is that for security reasons both SQL services 5server and agent) are running on different accounts. Perhaps that' the point. The Agent is running on a...

  • RE: OPENQUERY

    Did you tried an OPENROWSET like this one

    SET ANSI_NULLS ON

    GO

    CREATE PROCEDURE usp_Test

    AS

    SELECT a.*

    FROM OPENROWSET('SQLOLEDB','Server';'user';'Password',

    'SELECT * FROM Database.dbo.') AS a

    GO

    The openrowset have better performances than linked servers.

    ...

  • RE: SQL Mail

    The sql account is a DOMAIN user specially created to run the SQL Server service under Windows2000. The version of SQL is 7 sp4.

    The SQL Agent runs under a local...

  • RE: Huge log files under SQL Server 7

    Wow, it does the job!

    Thanks.

  • RE: Calling DTS with ASP scripts ...

    There is a 'cheap and dirty' walkaround ...

    Enclose the package into a job, create a table TOTO with a trigger that fires on insert and that executes the job.

    In your...

  • RE: Linking to a Linked Server

    We also use an Oracle Database synchronized with a SQL2000 Server.

    The first thing to know is that ther is a wellknown bug in that context.

    The linked Server works but so...

  • RE: DTS Transformation (maybe)

    You can use a UNION between several SELECT

    ex

    SELECT a, b, c, d

    from table1

    where e='Y' (the validation flag)

    UNION

    SELECT asd a, grt b, ohsd c, ewh d

    from table2

    ...

  • RE: DTS works but schedule JOB don't

    I also had the problem. You need to register your entreprise manager with another login (not SA better a login that is used only to run the packages).

    When this is...

  • RE: Linked Server - Poor performance?

    Did you try the openrowset command for SELECT. I had the same perfomance problems with an Oracle linked server.

    LINKED SERVER:

    Select * from Oraclesvr..SPAR3.USERS

    OPENROWSET:

    SELECT MAT_USR, NOM_USR, PRENOM_USR, SIGNET_USR, CC_DEFLT_USR, STATUS_USR

    FROM...

  • RE: Realtime transformation for 1 to many tables

    There is a trick to do the job but ...

    You create a table (ex.: working table) with a datetime field.

    You create a trigger that insert the getdate() value into that...

  • RE: DTS - SQL Source to DBase file

    Using Enterprise Manager to design your package, you can create a dynamic properties task.

    In there you select the connection, OLEDB properties and datasource and SET.

    The you select (ex.) a query...

  • RE: Invalid Object Name #.....

    The end of the stored proc. commit the transaction and clear all temp tables and variables. Perhaps you'd better to use a ##tablename so it is stored in the general...

Viewing 15 posts - 1 through 15 (of 19 total)