I am building a query in code (ASP) and when I execute the query, I get the following error: ================================================ Microsoft OLE DB Provider for SQL Server error '80040e37' Invalid object name 'Circuits2005'. ================================================= ...more >>

CREATE PROCEDURE SP_Login ( @Email Varchar(60) = '', @Password Varchar(100) = '' ) As Declare @UserEmail Int Set Nocount On If not exists( Select CdUser From User Where Email = @Email And Password = @Password) Begin Raiserror(13001,18,1) --User not found End it should...more >>

How do I add data that has an apostrophe in it? For example, update logon set question='Mother's maiden name' won't work as there is an apostrophe in it. I need to be able to allow apostrophes in some of my fields. Thanks, Tom ...more >>

I have a the following tables: CREATE TABLE [dbo].[xref] ( [IndustryCd] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [From] [int] NULL , [To] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[naics] ( [NAICS_Cd] [int] NOT NULL , [NAICS_Adj] [int] NULL , [NAICS_Descr...more >>

I am getting the following error message from a view I have created. I would think it was a design issue but it appeared to be working at one time. When it was reopened I received the following error: ----Could not allocate ancillary table for view or function resolution. The maximum numbe...more >>

In All Programs/Microsoft SQL Server - Switch is something called SQL Server Upgrade Wizard. I have no idea what that does, so I thought I'd start it up and see what happens. What happens is that I get an error message saying that my virtual memory is too low, and should be set at the physi...more >>

I have a table to hold information about Start and Stop Time for a typical day for a worker, and I don't want any date in these fields. If I write a SQL-statement like this "UPDATE CalendarProfile SET [Start_Time] = '08:00:00'", SQL-Server writes "01-01-1900 08:00:00', but if I write "08:00:...more >>

I have 4 dates: declare @PeriodDateBegin smalldatetime declare @PeriodDateEnd smalldatetime declare @BeginDate smalldatetime declare @EndDate smalldatetime Does anyone know a function that can give me the number of days that fall in a period? Example: set @PeriodDateBegin = '2005-01-...more >>

I have a SP which is as simple as create procedure SPName @Para -- Query 1 select field1, ... from view1 where field1 = @para -- Query 2 select field1, ... from view2 where field1 = @para Go But the view1 is a little bit complex. It nests 3 sub-views. Usually SP takes 1s to execute....more >>

Hi, Imagine table like this: CREATE TABLE SomeTable ( Id INT NOT NULL, Date DATETIME NOT NULL, xxx VARCHAR(20) NULL ) This table can contain multiple items that contain the same stuff DECLARE @now DATETIME SET @now = GETDATE(); INSERT INTO SomeTable(1,@now,'d...more >>

Hello, This is a followup to the EAV query help. After some changes, I came up with the following schema to get rid of that schema and make it less generic. I still am having trouble getting the output I need.(I don't have a lot of experience with complex (for me) queries.) I was hoping yo...more >>

It is possible to execute an Oracle stored procedure from SQL Server using DTS. However, is it possible to execute a stored procedure using a linked server (either by using OPENQUERY or a 4-part name (eg. EXEC MyLinkedServer..MyOracleUser.MyOracleProcedure) I haven't been able to successfully...more >>

Imagine table: CREATE TABLE SomeTable ( SomeId INT, SomeDate INT, Flag BIT, SomeText VARCHAR(100), ) GO DECLARE @now DATETIME SET @now = GETDATE() SET @later = GETDATE() -- a bit later INSERT INTO SomeTable VALUES( 1, @now, 0, 'demo1') INSERT INTO SomeTable VALUES( 1, @late...more >>

Hi, I have a table that many SPs use it. I need to rename this table. Is it possible that all SPs or Functions get updated automatically when renaming the table? Thanks in advance, Leila ...more >>

Two questions: 1) Can an OUTER JOIN, such as a LEFT OUTER JOIN be done on more than two tables and, if so, what is the syntax for it ? I want to do a LEFT OUTER JOIN so that all rows from my left table are selected which meet my where conditions, and where matching rows from more than on...more >>

How to Run Maintenance Plan immediately? ...more >>

Hi I'm working with SQL 2000 and I want to view the properties of Sa login by right clicking on it ,but when I did it ,at first a following message appearred before the properties window, 'Error 21776 : the name dbo was not found in the users collection. if the name is a qualified name use []...more >>