I am having a problem with a customer. The app we are supporting was developed using Client-Side queries that select * from views. Those views are built using other views. (yes, layers of views) The performance isnt all too bad, about 300 milliseconds per request. The optimizer loaded up ...more >>

I need to subtract two types of subtotal, SUM(Subtotal); if the type=1 or type=2. For example, (Sum(Subtotal) if type=1) - ( Sum(Subtotal) if type2=2) I need to do this in a single query if possible, please. Table Schemas: There are 3 columns ID, Subtotal, Type: ID Subtotal Type 1 9...more >>

Hi, I have a server with MSSQL Server installed there in which I've deployed my DB. I've also deployed an app (programmed with C# in .net) which access that DB. Is there any chance to access that DB without installing the SQL Client? It is very urgent. Many thx....more >>

Introduction: I want to put database based asp.net web site on a windows server. For the asp.net files there is a free framework that will run the asp.net files on the server. The Question: Is there any free PROGRAM that can run the .mdf and .ldf files on the server? And what is the name ...more >>

I have an Update statement in a stored procedure, and I want to capture the number of rows affected for returning to the caller. If this was a simple Insert, I'd use Scope_Identity() to get the Identity. But in this case I want the count of all updated rows. Thanks. ...more >>

I have 1 SQL2000 setup with multiple instances. Have problems connecting ODBC on a NT4 to a named instance. It can connect to the default instance though. Tried both ServerName\instance name, and IP address\instance name. Network connection is fine, can ping to the SQL Server. Connecting by T...more >>

I am in need of a little help. I need to write a query to total up some search results. Here is a same of the data. l_id l_include l_path 664 test Support 665 test Support...more >>

Hello all, I appologize in advance if I posted in too many, or the wrong newsgroup. A client of mine contacted me earlier regarding an issue they are having with their MS SQL server. They use SQL mostly for timeclock entry for employee's entering and leaving the building during the start ...more >>

We changed from sql 7 to 2000, crissis mode. One use with a laptop keeps getting the error when connecting to the sql server. SQL 2000 latest, mixed mode. Laptop xp pro latest, mdac is latest. I looked up sql server 26000 and 18452. I was not able to resolve the problem. Still an untruste...more >>

Hi All, Newbie question for you all, sorry. I'm currently migrating my DB's to a new SQL 2000 server and am wondering if there's any way of centrally changing the ODBC settings of all my workstations? I really don't want to have the support guys visit each machine in turn and do this manu...more >>

Hi, I wanna create the trigger on one table that contains one image field but when I declare that image variable in trigger, it gave me an error that I can't define image datatype into local variable. Is there any way I can write the trigger to do the auditing of the image field as well? ...more >>

Is there any way to embed the desired connection isolation level in a SQL OLE DB connection string? I saw that the property "Isolation Level" exists on SQL OLE DB connections but couldn't find a way to get this into the connection string (extended property didn't work) For 3rd party produc...more >>

Hi, We recently had a new environment created. The servers were all installed as separate instances on the same physical machine. For my first instance INST1 When I execute the following query exec getMyData '1964-11-19' in query analyser everything is fine from my (ASP) website everyth...more >>

I would appreicate if any one can let me know how I can findout the database user password. I don't wanna change the password, I have a system administrative rights in SQL Server, is there any way to findout that. Thanks ...more >>

Greetings, We've recently migrated our database from SQL Server 2000 to SQL Server 2005. Most of this migration has gone well with backup/restore, and a few post steps... One last issue remains, I'm trying to run a stored procedure in 2005 that calls an extended stored procedure that wa...more >>

I have to sum(NoWidgets) produced GROUP'ed By Station. The Widgets Produced are in a subtable of the Widget Stations, so it works for the most part by doing this: Select Sum(NoWidgets) From WidgetData Inner Join StationData GROUP BY Station Where I run into problems is when I want to sum ...more >>

I am getting an error whenever I try to start the sqlserveragent. This started happening about three days ago. I have not made any changed to the computer users or permissions and it is a test environment on a local computer. The error is: The dependency service or group failed to start err...more >>

OK, I have 2 fields: LastName and FirstName. I need the syntax that will provide me the following: LastName + ',' + Firstname However, the field has a max length of 20 characters. So, if the last name is greater than 18 charaters, then I need it to provide the following: left(LastName,18) + ',...more >>

Hi I'm working for an online university, and we are currently in the process of redesigning our portal website. We were thinking of using a single database to store content, quizzes, and assignments coming from multiple courses, as well as user accounts and security. The reason for this, is...more >>

I work for a company which uses local Access databases at 15 different locations through-out the country. If I want to extract data from these databases, I have to import the tables from the respective servers or create linked tables to those servers. The data connection is not instantaneous...more >>

Is there any way I can encrypt the stored procedure and that only I can only decrypt it none of other user can do? I can't use Ecryption reserve word becuase that can also be decrypted through third party tool, is there any other way I can encrypt my stored procedure with my own key or like...more >>

I have installed the server for sql 2005 but I cannot find the SSIS (new = Enterprise Manager) to view the interface to run queries, etc. ALl I see = is the SQL Server Configuration Manager, is there something I'm missing? = =20 Thanks ahead of time!...more >>

I'm trying to use a asp.net page (aspx) using SqlDataSource to connect to a remote SQL Server 2005. I keep getting the following error: provider: Named Pipes Provider, error: 40 - Could not open a connectio I don't know why my sql client is using named pipes, it should be using TCP/IP? He...more >>

I would highly apprecite if any one guide me regarding CPU %, I check in the task manager the CPU % goes to 100 and when I run the Profiler to findout the query which query taking longer time then I didn'd find any query, when I saw the Profiler all the SPs taking 0% CPU usage... what would be...more >>

I have a Windows 2003 Server, what my plan is to compress sql server backup file every night and ship in to different SQL Server Server, the question is, is there any builtin zip/compress facility in windows which I can use it for this purpose. Thanks ...more >>

Is there a SQL command I can use in a select statement to retrieve the week of the year. For example a command of Year('01/08/06') would return 2006. I am looking for a command like Week('01/08/06') to return 2. I cannot find such a thing. Thanks. ...more >>

I have a server that contains Domain Controller, Application and Database Server and that has 1 GB of RAM, right now when I see the memory in the task manager > Performance option, the available memory is showing 2%, is that memory is leaking or we don't have enough RAM, how I can identify the...more >>