When i try to start SQL 7 on my Windows 2000 server i get the following message. An error 1053 (The service did not respond to the start or control request in a timely fashion.) occurred while performing this service operation on the SQLServerAgent service. I know this is vague. It happene...more >>

I have a table with two fields: idnum (index) full_name I'm trying to design a query, or set of queries, that will let me identify the records with the "lowest" (i.e., first in an alphabetical sort) full_name, by first letter of full_name. In other words, if the data looked like this: 1 A...more >>

Greetings, Using SQL Server 2000 SP4 64 bit edition, I am trying to update a partitioned view on one server from another. Here are the details..... Server A (Where Insert Query Runs From): insert into archiveLS.archive.DBO.archive_View select * from #buffer (NOLOCK) where recordnum > @...more >>

TableA TableB Name ID_A ID_A MoreData AAA 1 1 111 BBB 2 1 222 CCC 3 SELECT * FROM TableA LEFT JOIN TableB ON ...more >>

Hi Does anyone know if SQL Server 2005 Compact edition supports T-SQL Stored procedures?? Thanks ...more >>

Hi at all, first post in this NG (i usually walk around .net programming ng :P ) I've decided to write cause I have a strange (Strange for me.. I'm a beginner with sql server). well...too words....i go directly to question : I have 2 sql server installed on 2 identical machines (same cpu...more >>

Hi I have a date column.I want to convert this date to integer.Similarily I want to convert current date to integer and find the difference between these two dates Please let me know regarding the same. Regards Usha ...more >>

Hi all, I have a DTS Package which imports data from a different server. this job is scheduled twice a day and at times the scheduled job fails with an error... Not all times, only some times the failure occurs. Description : MSHSRMNSUKP0056 (SQLSERVERAGENT[208]) - Action=Please see Ops Doc...more >>

I have a very simple query: -- ============================================= -- Author: ######### -- Create date: ######## -- Description: -- ============================================= ALTER PROCEDURE [dbo].[###########] -- Add the parameters for the stored procedure here @quoteid in...more >>

Hi - I've recently installed 2005 and I would much prefer BOL etc in the old format (CHM ?). Is this available anywhere ? Failing that could anyone tell me : 1. How can I arrange it so that I never see anything else but the internal help. I've tried turning off 'online' but the search functi...more >>

I am trying to create a view that creates a mailing list from two different tables. The t-sql code executes successfully but when I try to open the view I get this error message [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type vchar to float. Here is the t-sql code I ...more >>

I am new to SQLServer 2005 but not to relational databases. I am puzzled by the behavior of views. I can use the view in Visual Studio or open it in SQLServer Management studio and the virtual table displays correctly except for sorting (ORDER BY in the SQL statements). Joins and filters all w...more >>

Hi, I would like extract in a document (.doc, .txt, .cvs, .xml or also) the complete list of all user that logins to my SqlServer 2000.... that is I need to know for each user to which databases accedes. For example, the user TOM WHITE accedes to the database [SCHOOL], [NEWS] and [JOB] with r...more >>

So, I have a primary database performing log shipping to a secondary database. The logs are being backed up shipped and restored onto the secondary.. NOW WHAT? Trying to test the effectiveness of the solution, but have not found a single article on how to promote or activate, etc the secondary...more >>

On an ASP.Net 2.0 appliaction, I use ASPNETDB.mdf in the project's App_Data subdirectory for forms authentication. This works fine inside Visual Studio 2005. When I deploy the application to an IIS server on the same computer, I cannot open ASPNETDB.mdf. I get the usual message: ...more >>

Our DBA has just left our company and I am covering for the meantime. I have some very basic SQL server skills and have been asked to change the sa password on all SQL installations/instances (we have a SQL Cluster environment as well as stand alone SQL installations). What is the best way to ...more >>

A few times a day we get a dramatic increase in the number of user connections on our database (sometimes 4 to 5 times as many according to perfmon). Here is some additional information... - from the time the number of connections starts to increase to the time it drops back down to a "normal...more >>

Hi, I wanted to know if there is a way to modify the system tables in SQL Server 2005, and if yes a way to audit these actions. I tried selecting from the system tables (using a DAC connection), it allows me to do so, but the profiler doesnt report on this action. Table queried on :...more >>

i want to create an asp script. it can do the task below. 1. check if the mytable is exist? 2. if exists drop mytable 3. create my mytable. my question how to check if mytable is exist? please advice an asp script. or anyone can tell me how to create a procedure which can create a table , th...more >>

when I drag&drop a script into QA when a connection is alredy established, automatically QA starts new conn on same db. I'm not able to gain same behavior with SQL 2005 Management Studio because the script is entered in edit mode with no Run available. Am I wrong ? No hope ? Best regards paolo...more >>

I am new user to SQL and I am trying to create a sub query. I keep getting the following error Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. My queries work seperately but when I put the...more >>

Hi all, I'am completely helpless regarding a mistake that occured yesturday. The problem was that I've restored a Database over an existing one, and force it to overwrite, but I did not noticed that I was doing it in the wrong database. Let me explain it with a little sample: DataBase1 ...more >>

Am I correct in thinking that a catalog is structurally identical to a database in everyway? The only thing that distinguishes a catalog from a database is that a catalog stores information about databases, not user data. Thus, the "master" database on a server is the catalog for that server. ...more >>

Heres a mind twister for you all that I cant figure out yet.. Backend: Ms sql 2005 Example: DECLARE @TABLE TABLE ([COLUMN] DATETIME) INSERT INTO @TABLE([COLUMN]) VALUES('1/1/2007') INSERT INTO @TABLE([COLUMN]) VALUES('2/1/2007') INSERT INTO @TABLE([COLUMN]) VALUES('3/1/2007') INSERT INT...more >>

Hi Everybody, I had created a stored procedure wherein i had passed the parameter contains(tablecolumnname,searchstring) It is working very fine except if the search string is carrying "-" character. Let me explain the problem. if the parameter is ((contains(col1,'"abcd*" '))) then it will ...more >>

Is there a way to create a relationship between the views in a database. More like a Primary - Foreign key relationship like you would do for Tables. ...more >>