Microsoft SQL Server Forum

Hi I have problem with scheduling tasks. I have one SP, where I decide to fire or not another SP and I prepare parameters for this new SP. The problem is I want to fire this new SP with delay. For example SP1 is executing at 4:00 PM and this SP1 makes SP2 to fire at 1:00 AM. Is it possible to create this programatically ?? Thx for any...

I am trying to find a select on sysprocesses that would list all the active logins. An active login is a login that has a TSQL statment being executed on the server, This didnt work to well! Any ideas. Thanks in advance. select sp.loginame, -- more columns from master..sysprocesses sp where sp.status not in...

My colleagues and I have not been able to successfully set up SQL debugging on a SQL 2000 instance running on Windows 2000. Is there a checklist posted somewhere? We have verified that the SQL Server is not running with System Account Credentials. It runs as a Domain Administrator. We have also verified that everyone has permission to run...

Hello: I've just converted my Access 2K db to SQL Server 2K and the conversion went smoothly. I created users, roles, views and forms and gave the users permissions to use them. I "THINK" I have done everything, but......you cannto update the form, view, or table. I get "Recordset Not Updatabale" when I modify a field in either. ...

Greetings, I have the follow table structure: CREATE TABLE . ( (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , NOT NULL , (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

Hello, I'm using SS2000 on NT4. If I run the following query, is it garanteed that the field "OldField1Value" will hold the value Field1 had before the query was run? UPDATE MyTable SET Field1 = 42, OldField1Value = Field1

I do a: SELECT * FROM xxx And Get: Date Place Sum A M 1 A O 3 A P 2 B O 5 B M 4

I have many tables and in those i require to change some data. Say from ARCA to ARCAEX. I am sure that the string is unique in the sense there will be no ARCAABC. So what do i do change by not manually needing to search in each table and the whole database and still can be sure that the changes have taken place. Please help Regards, Rajesh

hello, my problem is how to move data files drom drive c: to drive d: ?? -- MarcinS

Hi I'm interested in using the timestamp data type & I have some questions. As far as I can understand the contant of a timestamp column is a binary value. Is there any connection between that value and a valid date (as the word timestamp means) or is it a left over from the days when the timestamp value really was a datetime type (so it...

In meen. primary keys, NOT NULL, IDENTETIES...et.c I have to do a maunally, one time, building of a database. Sometables has to stay an some are to be exchanged. The foreignkey inforcemnt ill do for my self so everything is correct. I just need to be allowed to de thede task for a while. Is it impossible? Regards Anders

I would really appreciate it if someone could give me the answers or direct me to a place that would have the answers to the following 5 questions. 1. I need an example of SQL select statement. (table tblSource, fields A,B,C where C<100).. "is this an example that I have in ( )? 2. I need to list 3 table joins or is "inner, outer, left"...

Hi there How can I debug Stored Procedure? Thanks

Hello, I received the error message below when i'm trying to install SQL Server 2000 standard edition into a Windows 2000 Professionale workstation. Error : Microsoft SQL server 2000 Standard Edition server components is not supported on this operating system. Only client components will be

This is probably a stupid question, but here goes: I am trying to update a table differently based on what is in one of the columns within the table. For example, I want to set Fld1 to be "On" if Fld2 is "A", and I want to set Fld1 to be "Off" if Fld2 is "B". This is easy to do in two SQL statements, but I was wondering if there's some way...

I'm running a simple DBCC DBREINDEX ('myTable') and I receive the following error: "Server: Msg 169, Level 15, State 2, Line 2 A column has been specified more than once in the order by list. Columns in the order by list must be unique. DBCC execution completed. If DBCC printed error messages, contact your system administrator." I can...

I keep getting the following error message when I run a serie of SQL commands: Server: Msg 9002, Level 17, State 6, Line 15 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space. I have tried "dump transaction tempdb with no_log" right before I run the SQL command. But that...

Using SQL Server 7.0 Trying to change an objects ownership to dbo with EXEC sp_changeobjectowner 'AssignInvoiceNumbers', 'dbo' which gives the following error: Server: Msg 15001, Level 16, State 1, Procedure sp_changeobjectowner, Line 26

I have two tables: eg. a person-table (no nulls allowed), with an id and so on, and a person_course table (an intermediate table in a many-to many relationship between person table and courses tables), with two fields person_id and course_id. But I want to make ONE multipurpose stored procedure, which has ONLY optional parameters on all...

Is it possible to run SQL certain script from the client application ? thanx

I was hoping I can get some help regarding subject mater located at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp MyTable has 23 fields with 100,000 records. Field1 nvarchar 90 Field2 char 6 Field3 varchar 8000 Field4 nvarchar 200...

Hello -- I'm trying to get SQL Server 2000 on a Windows 2000 Server to be able to query an Active Directory. We've got two domain servers one Win2000 and one Win2003. However, I'm having problems: I've run the following query to setup the linked server: sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject',...

I have set up a server with a publication of a very large database. A backup server needs to retrieve the data and do some massive calculations (which isn't really relevant). On the backup server I've created a subscription to retrieve the database but I get the following error: Message: The process could not retrieve file...

Hi: Anyone has a detailed procedure description about how to setup a standby server? Microsoft makes it sounds very easy which are more complicated. How to handle system databases, does standby server need to be exact hardware as the primary one? Thanks in advance,

I forgot to add this question to my last post. Can someone help me out? Question: Say you have a drop down list based on a SQL statement, want limited by the values in another control on the form - how could this be done? Thanks again for your help