Viewing 10 posts - 18,916 through 18,925 (of 18,925 total)
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...
July 15, 2004 at 7:31 am
I'm glad I'm not the only one who thinks this isn't a fair question... at least I learned something new today.
July 9, 2004 at 6:30 am
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...
July 9, 2004 at 6:20 am
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...
July 7, 2004 at 6:36 am
Problem solved... I dropped the table and recreated it and it works like a charm again. Thanx for all your input.
June 29, 2004 at 7:32 am
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...
June 29, 2004 at 6:18 am
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...
June 28, 2004 at 6:47 am
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...
June 15, 2004 at 6:43 am
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...
May 27, 2004 at 10:39 am
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...
May 27, 2004 at 9:44 am
Viewing 10 posts - 18,916 through 18,925 (of 18,925 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy