I have a sql server installed on my machine and when I run the stored procedure it gave me the result in 1 min but when I run the same stored procedure in to different box it gave me the result in 20 min and that machine has a higher configuration of mine machine, can any one guide me which ...more >>

I am trying to create user in SQL Server 2005 Express Edition but I was failed to do so. here is the error. TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Create failed for Login 'wt'. (Microsoft.SqlServer.Express.Smo) For help, click: http://g...more >>

Can anyone guide me about Microsoft SQL Server 2005 Unleashed book ? Thanks ...more >>

Hello, I got the following error message when I was trying to debug a stored procedure. Pleaser review the error message below: Server: Msg 504, Level 16, State 1, Procedure sp_sdidebug, Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on QAIMGSQL01...more >>

I perform a DROP COLUMN and it works fine. Yet if I do it while in transaction the column doesn't get dropped and I get no exception. Any ideas as to why that would happen ? I'm using ADO & MSSQL 2k Regards, Danny ...more >>

Hi all I'd like to drop a column which has a default value. This fails as the default value object is stored in SysObjects. So that needs to be deleted in order for drop column to work. Doing this manually works fine, but doing it programatically doesn't as delete from SysObjects fails with th...more >>

hi i spend more time to write the code, like VB6, VB2005, SQL Stored Procedure code. any one know good Application to Automaticaly read Database (Access or SQL), then write VB Code and Stored Procedure (if this allication free thats good :) ) -- Tarek M. Siala ...more >>

Hi, I am installing SQL server 2005 Evaluation version on win 2003 server (SP1 is there). I have selected all the services to install. But, the osql.exe is not getting installed in the folder C:/Program Files/Microsoft SQL Server/80/Tools/Binn folder. Could you please let me know the problem...more >>

Hi, How can I increase the number of files query analyzer keeps in the file menu under most recently used files? Is there a setting for that? Thanks in advance, Rick...more >>

How can I use Query on a client connected to one server when the query pulls data from the connected server and from another server. Now we get an error when the query attempts to read from the other server. If we run the query directly on the first server, it pulls from the other server w...more >>

How do i bring a copy - MDF - file into my new MSSQL 2005 computer? I know how to bring a backup - BAK - but I only have the MDF file. Thanks, Raul Rego NJPIES ...more >>

hi i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and run SQL Statement? -- Best Regards Tark M. Siala Development Manager INTERNATIONAL COMPUTER CENTER (ICC.Networking) Mobile: +218-91-3125900 E-Mail: tarksiala@icc-libya.com Messenger: tarksi...more >>

hi i working on VB6 + SQL2000 i have table called (tblBuffer) and want do something in my application everytime table added new record (its like trigger in SQL) thats mean if someone add new record to this table, this table call my application to do some event. now i made small monitor (w...more >>

I'm running a OpenRowset query getting data from MSAS (MSOLAP). The query returns column names such as '[Time Period].[BTG][Measures].[FC]'. I need to create an alias for this column. How could I do it? I tried '[[Time Period].[BTG][Measures].[FC]]', '[[Time Period]].[[BTG]][[Measures]].[[FC]]...more >>

When I try to install SQL Server 2000 Desktop Engine, I get the BPsetup error that says "Unable to Create a login instance." Then when I click ok it says "Unable to Add system server role." Then when I click ok it says "Unable to add login and grant access to database." Then it aborts setup. ...more >>

I have a form that I want to have use a disconnected recordset. The disconnected recordset works fine, but I am unable to update or even type in the textboxes. When I try I get a "Recordset is not updateable message" My intention is to have the recordset reconnected and for it to do a batch ...more >>

Good afternoon! I am a complete newbie when it comes to SQL, so please be gentle! We have a mission-critical application that runs on a WINNT 4 SP6a/SQL 7 SP4 PDC (This was setup several years ago - way before my time). There are three clients that use this application - but they use it a...more >>

Is anyone able to explain why I'm getting very different performance as reported by SQL Profiler for the same query when executed from 1) ADO.NET and 2) SQL Management Studio. I'm accessing SQL 2000 from a web service using .NET2 and Enterprise Library. Two particular queries have the fo...more >>

hi i working on SQL2000, and want to make "Stored Procedure" that's working every 5 mibute, without making any calling. how i can make that ? -- Best Regards Tark M. Siala Development Manager INTERNATIONAL COMPUTER CENTER (ICC.Networking) Mobile: +218-91-3125900 E-Mail: ...more >>

Is there any one let me know, in the stored procedure I am creating temprary table and droping table at the end, when single user access it is working fine but when simultaneous user access of that stored procedure it giving error like #Temp table is not exists... any idea ? Thanks ...more >>

How can I create a Setup.ISS file for SQL Server 2000 SP4 client tools? SP3 came with sql2kcli.iss, but SP4 does not. I have been unsucessful in capturing an ISS file during an install as the documentation claims will work. Am I missing something here? It should be easy. Thanks!!...more >>

Can we install SQL 2000 and SQL 2005 at the same box, any url available to install two instance - SQL 2000 and SQL 2005 at the same box. Thanks ...more >>

I have a C# client application that uses SQL Server as a backend. It works fine on my development workstation. But when I moved it to another test workstation four out of the five winforms worked fine but one doesn't. The one that doesn't can open the connection and return the server version a...more >>

How come when I make a SQL Server login that login can't be used to login from my C# application (OLEDBConnection.Open()) or the properties menu wizard. Randy ...more >>

A third-party application we have to use requires the installation of the Client Network Utility on clients workstation. Is there any way to install this piece of the Client Tools without running through the standard SQL Server setup routing that prompts for the CD-Key? Thanks, in advance, ...more >>

I want to insert "489d68bf-baa1-415d-94c7-a8e56b-609c61" in a column in sql server . The data type of this column is varchar (100). i am getting the folloing error - incorrect syntax near '68bf'. I think it is not accepting the '-'. How can i get a work around for the '-' so that the above val...more >>

Are there any issues connecting to a 64 bit backend SQL Server database installed on a separate server using a 32 bit client on the client machine? We are creating client software on a 32bit machine and need to know if there are any code hcnages required to access 64 bit SQL server. Thanks...more >>

Hi! I would like to make a video surveillance system and: 1. for a client to connect to the server and watch "real time ", I request a password and username.What should I do? Create a database which stores that information about a client. (I don't know how should I do this ). What do I need i...more >>

hi all, i m new on Sql and i have a project related to C# and Sql. i have to do a project which must work on LAN, and there must be only one database file on main computer(Server Computer) and other computers(client computers) must connect database on main computer. i m preparing my proje...more >>

Hello, I have installed SQL2005 developer edition on a laptop (2 GB RAM), VS2005 on another computer. The database is quite small (nearly no data or some test data). The performance is still really bad: xxx each time you open the server explorer in VS2005 and you use "show table data" (tak...more >>

I wanna copy all the stored procedures from one database to another database throug stored procedure, is there any ways? Thanks ...more >>