Forum Replies Created

Viewing 10 posts - 18,916 through 18,925 (of 18,925 total)

  • RE: Question of the Day for 15 Jul 2004

    Come on guys I'm not even a DBA and I know this one. I built a little software that queries pretty much every major system table to extract information...

  • RE: Question of the Day for 09 Jul 2004

    I'm glad I'm not the only one who thinks this isn't a fair question... at least I learned something new today.

  • RE: cant connect to server in DTS

    I found the solution... Sqlserver was a named instance using a domain account so I just changed to local info to : REMI\Dev and it worked like a charm...

    That's 1...

  • RE: Validate object name

    Thanx for all your replies but I think I wasn't too clear in my question.  I'm already well aware of the naming conventions and that this DB is breaking about...

  • RE: Sp wont delete

    Problem solved... I dropped the table and recreated it and it works like a charm again. Thanx for all your input.

  • RE: Sp wont delete

    I tried dropping the sp and recreating it like this but it still gives me the same error message.

    SET QUOTED_IDENTIFIER OFF

    GO

    SET ANSI_NULLS OFF

    GO

    CREATE PROCEDURE [dbo].[DeleteADP] @PkADP as int

    AS

    SET NOCOUNT ON

    if...

  • RE: Need to insert an integer value into a variable from a query

    here's one function I like to use (works only with that have a Primary key):

    CREATE FUNCTION [dbo].[CountALL] (@sTableName as varchar(255))

    RETURNS int AS

    BEGIN

    --this is about...

  • RE: xp_execresultset PROBLEM! Help!

    This is just a hunche but have you tried :

    select @query = N'SET ANSI_NULLS ON; GO; SET ANSI_WARNINGS ON; GO; select * from OPENROWSET(''MSDASQL'',''DRIVER={SQL Server};SERVER=127.0.0.1;UID=my_uname;PWD=my_pass'',''SELECT * FROM pubs.dbo.authors ORDER...

  • RE: Weird Date problem

    Yes everything works fine on the old server. the problem occurs only when I try running the queries on the new server when they have dates after the 12th...

  • RE: Weird Date problem

    I checked for the user who set the local setting and it's been set by the local admin. Collation type is the same on SERVEUR5 as SERVEUR4 (FRENCH_CI_AS)

    Language is...

Viewing 10 posts - 18,916 through 18,925 (of 18,925 total)