Hi everyone! How can I do to debug a Stored Procedure in SQL Server 2005 from SQL Server Management Studio? I looked for the Debug... option when I right-clicked the SP but it seems that in SQL Sever 2005 doesn't not exist. Thanks. Jaime Lucci ...more >>

In SQL 2000 I could write SELECT filename FROM sysdatabases WHERE name='MyDB' and got the physical file name with its path. But in 2005, I get empty string when I use the query in c#. But it works when I use it in the Management Studio. -- Mike...more >>

I have stock data files to import into a SQL table. Here's a line from one of the files: QQQ 19990311 51.43750 51.71850 50.31250 51.31250 90108.00000 Each column is separated by a tab and the import wizard has no trouble understanding the data but, of course, it wants to import everything ...more >>

I hope this is the right group. In enterprise manager we had the option to right click the table and choose, TOP or Query or All to open the table. Where did that go in SQL 2005?...more >>

why I can not add a folder to my project. Message will show "Access to the path ... is denied". This folder include some sub ffolder, I store some.sql files in this folder....more >>

Hi, is it possible to set a "connection string" to use a default schema. instead of me having to prefix tablename with schema name in the query. so, if I don't say a schema name it uses the default schema (not .dbo). Thanks Nalaka ...more >>

Hi I have a VB6 program that talks to SQL Server 2000 database. The Connection String is as below: Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME & ";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source=" & M_SERVER When the program is idle...more >>

Ok this is a BIG annoyance. When I type Select * from table in one of the SQL Query Tabs and then open the Query Designer it auto expands my query to show all the fields. Example say my table has 30 fields when view it will expand my query to read select field1, field2, ...more >>

in sql I use "select top 3 from......order by (tablename) desc,that can give 3 datas but i want third data to my program So i use other function: SELECT TOP 1 'answer'=AAA.A FROM ( select distinct top 3 'A'=month FROM dataTable where month < '200511' ORDER BY month DESC ...more >>

I am a .net programmer working for a small company. This company would like me to write up recommendations on what needs to be considered in managing a sql server database. There are 3 programmers that use sql server 2000 and everyone does their own thing so far. Is there any URL that will p...more >>

Hi, May I know how to commit changes made to the database table that I opened in sql management studio while leaving the window showing table content open? I can see a cell modified message at the bottom after I make changes, but there is no way to commit the changes. Previously in SQL 2...more >>

Hi everyone! How can I do to copy the data and the indexes from an existing table on a database to a new table in another database? I've tried with select * into base1.table1 from base2.table2, but it only copy the data and not the indexes. Can I do it by code? I'm trying to avoid the use...more >>

Hi all, I have install the client tools on my machine. At the first view it works fine. I have got access to databases, can work but after a unknown time, I got a SSPI-Connection Error when I try to do something. Only a restart can fix the problem for a while. What can I do to avoid the ...more >>

I have created one user named dbUser and gave different database access to that user now I want to find out which database and it's objects can access to that user through query analyzer, any query or idea how ? ...more >>

If I install enterprise manager on a machine, How do I limit specific access to certain databases with in the MMC?...more >>

Hi there, right now i'm working with a VB6 project that connects to a SQLSERVER 2000 using a System DSN. I discovered a problem that, i hope you can help me. The problem is that, when i try to save a record with a date field - the date saved in database is 2 days more that the typed date. ...more >>

May I know the minimum system requirement in order to install SQL Server 2000 with 64 Bits. I am trying to install it on a Intel® EM64T machine, but it appear to be failed. Is it any way for me to install SQL server 2000 64 bits on this machine?...more >>

Hi All, We have various processes running symultaniously but no two processes will access the same record and each process is in a seperate transaction. The problem is with SQL Server Database Locks. i.e. if we access any query in two different transactions then one is getting success and t...more >>

The redist can be found here http://go.microsoft.com/fwlink/?LinkId=54583 See also http://blogs.msdn.com/mwories/articles/dmofaq.aspx GertD@SQLDev.Net Please reply only to the newsgroups. This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for...more >>

Just wondering a few queries about the differences between programming SQL for MS Access, and programming T-SQL for SQL Server. 1. Is it possible to use the same general SQL statements/commands from a ASP page that was used with a MS Access DB, for a SQL Server DB? (Basically can you progra...more >>

Hi I'm trying to install a software and at the end of the installation two windows pop in the first one is an ! Alert yellow in color that contains 'Microsoft SQL Server Desktop Engine the instance Name is invalid' and the second one is an X Error red in color ' Iris set up was unable to s...more >>

Après avoir installé le sp3 de sqlServer 2000, mas applis clientes n'arrivent plus à se connecter, j'obtiens le message suivant : DB Library : Unexpected EOF from SQL Server Il s'agit de vieilles applis en objectView. Quelqu'un a une solution ? Merci ...more >>

hi..I am running DBLIB (sample application of SQL Server) between 2k and 2k3. Well seems working perfect..but want to know whats going on in the Database..I think some DB configuration (like DB connection or Table creation) is required to see the effect of executed/commited transactions..need s...more >>

Hello everybody, I try to run our VB6 client-software from my win2000 pc with SQL2005 Express. The client uses ActiveX SQLDMO. Wenn the client try to connect to the SQL Server an error is raised: [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Serv...more >>

Ok I have been trying to get use to this new interface for SQL server 2005 for a few weeks now and honestly I am halting ALL of our migrations to SQL 2005 because this tool is so bad. For the record the back end DB is nice however the interace for this thing sucks. My main compaint is the re...more >>

Hello, I have a Microsoft Access front-end for a SQL 2005 database. The Access front-end was in SQL 2000 and worked perfectly. When I migrated it to 2005, I relinked the database and I can view the information, but I am unable to add anything to the database. All of the Add Record functi...more >>

Hello I am running SQL Server 2000 with SP 4 on Windows Server 2003 Enterprice Edisction. I receive several notifications with the following: Error: Message not found. Insertion strings:Error: 17805, Severity: 20, 3 Invalid buffer received from client. I want to create a SQL Profiler tr...more >>

Can any one why I am facing the following error.. bcp pubs..authors out 'c:\Testing.xls' -c -S{local} -Usa -PDbPass [Microsoft][ODBC SQL Server Driver]Syntax error or access violation Thanks ...more >>

hello, 1-I want a detailed step by step tutorial for installing SQL server 2000. 2- I want to install two SQL servers 2000 on the same machine, how could i do that? (i mean will there be any change in the installation to the second server?) 3- I want to know how to connect between these t...more >>

hi..i am trying to see TIP communication using msdtc sample applications (dblib: equipped with SQL Server) between w2k & w2k3. | w2k |------------------| w2k3 | My query is abt TIP...i couldn't find any check box or option to "Enable TIP" in Win2000. How can i enable TIP and see...more >>

I want to search the value by specific match but I couldn't... can any one let me know.. select object_name(id) from syscomments where text like '%PresetVal%' When I run the above query it gave me 100 stored procedure but when I go one of them then I see the text contains PresetValues bu...more >>

Hi, I am looking for a way to recognize differences between two sql server databases. Also preferably auto generate scripts to synchronize table differences etc. Can you please recommend some..... Thanks Nalaka ...more >>

I want to use only float datatype but the problem is that it return more than two decimal, I want to minimize to two decimal points? I don't want to use decimal datatype.... I only wanna use float..... The result should looks like 152254.45 but now it's giving me. 152254.45123232363 ...more >>

With SQL Serve 2005 what version of MDAC is needed for named instances? Anything else need upgrading? Thanks....more >>