Anyone know how to query sysobjects & syproperties showing the table, field name, and field properties (specifically the description)? I have so far: SELECT * FROM sysproperties sp INNER JOIN sysobjects so ON sp.id = so.id SELECT * FROM syscolumns sc INNER JOIN sysobjects so ON sc.id =...more >>

Witam! Czy jest mozliwosc przeprowadzenia replikacji w SQL2000, bez uzywnia DOMEN z AD na Win2000/2003 Server?? Niby konfiguracja dystrybutora, wydawcy i subskrybenta przechodzi na LOCAL SYSTEM ACCOUNT mimo "local sql server agent is using the local system account, which causes replication betw...more >>

1. If the TempDB Database is deleted from MS-SQL Server what will happen..? 2. How to insert a not null column in an existing table with records..? 3. If a table is deleted, what will happen for the Stored procedures and Views, which that table reffered..?...more >>

Hello all I am developing a CountrySelector control (which I would like to share with anyone), but I am quite a newby in this custom control area. You can find it at: http://home.kabelfoon.nl/~juliusd/vbnet/CountrySelector.vb Some questions I have are: - In what event should the items be...more >>

I have the following table structure. group1 group2 group1_result group2_result 'One' 'Two' 3 2 'One' 'Two' 3 1 'One' 'Two' 2 5 'One' 'Two' 4 1 'One' 'Two' 0 5 I need to sum up the number of times 'One...more >>

I have two SQL query that I would like to make in to one, if possible Here is the first one: (Query4) SELECT rooms.DESCRIPTIO, rooms.ID, bookings1.DATE FROM bookings1 INNER JOIN rooms ON bookings1.ROOMID = rooms.ID WHERE (((bookings1.DATE) Between #4/3/2004# And #4/9/2004#)); And the secon...more >>

I need to parse SQL statements directly and extract each segment individually. Is there a way reference the Microsoft SQL Parser directly from VB.Net? Thanks! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi, I want to restore my databases from the old SQL Server installation into a new installation of SQL Server. My new installation of SQL Server has different data path from the old installation. In addition, the data owners of some databases in the old SQL Server installation are not dbo. I ...more >>

I have a SQL database with an Access front end. In the database I have a read only and a read write role. When a read only user opens the database I want all the fields on the form to be locked so that the user will not try to change data and get an error from the server. Right now I am doin...more >>

Hello, I have a following SP I want to add an extra field "ranking" that just increments the row number. Another feature would be: if several users have an equal totalvalue, they should have an equal ranking number. the rankings following users would have to be adjusted as well. thanks SET QU...more >>

Hi! I have a large table in SQL Server 2000 with a datetime-column 'dt'. I want to select all rows from that table, excluding days which fall on holidays or weekends. What is the best way to accomplish this? I considered creating a new table called "holidays" and then selecting all rows (sort ...more >>

Is there a way to call an Oracle Procedure using the MS OLD DB Provider for Oracle object in a SQL Server 2000 DTS package? If it can't be done this way, is there another way to retrieve data from an Oracle database using an Oracle procedure to a SQL Server table? Also, can parameters be passe...more >>

Hi all, I just start using SQL Server for my project. I have some questions related to set operations. Suppose I have two tables, Table A and Table B, as following. TableA TableB ======= ======= --------------- --------------- | ID | DATA ...more >>

I have access tables which are linked to SQL database by ODBC connection. By using Access, i can easily see my table contents. but when i am using ASP, i con not. I am getting this error message Microsoft JET Database Engine (0x80004005) ODBC--connection to 'SQL ServerMYDATABASE' failed. wi...more >>

How do you create a new table from a SELECT statement of another table using MS SQL Server. This is part of a distributed database topic for university. Unfortunately I can only seem to get the new table created in Oracle and not MS....more >>

Hi, I have a question in SQL Server 2K, I use SQL Profile to trace, and find Stored Procedure was auto recompiled, like this row in the trace: SP:Recompile 15 1680 76 2004-02-27 16:01:11.610 How can I stop the auto recompile. Thanks Harold...more >>

Is there a stored procedure installed by sql server 2000 that I can call and just pass in the name of a new database and have it create the database for me? If not, how do I do it in sql? Thanks....more >>

Something strange is happening to our SQL Server DB (2000). The tempdb transaction log file continues to grow (quite slowly) for no apparent reason. We have it in simple mode, and I have tried a manual checkpoint command and manual shrink (of the log file only). There are no unusual SQL's (la...more >>

Dumb question perhaps, but hey. SQL Agent on sql2k, client sp3a, server vanilla. In EM Agent Icon Status does'nt show. Server running status doesnt show till explicitly connected. Agent has both start and stop menu options enabled, and no green arrow/red square (Green Arrow, Red Square ... ...more >>

Hi, I need manuals, tecnical papres, instalation guide, etc about how to install one cluster sql server 2000 64 bits with windows server 2003. It`s posible a need one document step by step about this Thanks, RaulGZ....more >>

I have a client that has a server running Windows 2000 Server. another company has installed MSDE (version unknown) on this server. I need to install SQL 2000 on the same server. Will the two coexist peacefully? Tia CruznOz *** Sent via Developersdex http://www.developersdex.com *** ...more >>

We can find a lot of recommandations about how to secure a SQL*Server configuration. Does anyone have scripts to do it ? Any advices or links are welcome...more >>

I am trying to use the haversine function to find the distance between two points on a sphere, specifically two zip codes in my database. I'm neither horribly familiar with SQL syntax nor math equations :), so I was hoping I could get some help. Below is what I'm using and it is, as best as I ca...more >>

i am using sqlserver 2000, and i was wondering how do i go about setting the query time out. is there a way to configure the query timeout for a specific user id?...more >>

Hello everybody.. Is there a way to fix the SQL Server 2000 installation when the Server after the server has been disjoined form its old domain and added to a new domain with a different computer name too? Sounds like a joke, but stuff happens. TIA -arifi ...more >>

I have two tables in my DB for an e-commerce app. This allows for 1 order to have multiple products. I want to select the OrderID from the Orders table but only when all the corresponding records in the OrderDetails table all have their Despatched value = 0. Can anyone offer any help please? Sim...more >>

I have a database that is used to store a lot of data. We load the data on a daily basis, several thousand records per day. The Log file is not needed, so whats the best way to delete the records in it and reduce the size Thanks Derrick ...more >>

COuld someone tell me if its possible to get hold of stats about all Databases on a SQL Server. The sort of things I would like are Name of DB Location of DB Size of DB Location of Logfile Size of DB Owner Users Authorised to access the DB Is there somethi...more >>

Hello, What could possibly cause data in the SQL server database to be removed, except being deleted manually? We had a couple of situations where data in certain records disappeared although the records were still there. The data is entered and editted through the web interface in ASP. The w...more >>

Dear all, Sometimes I happened the require that the number of input parameters of SP is not fixed, Can sql T-SQL handle the array (dynamic array)? Does anybody ever used an array name as the input parameter to call the SP? thanks, Robert...more >>

In Access 97, I am trying to attach to a table in my SQL Server 2000 db. I use File/Get Data, which displays all the SQL tables including the one I can't attach to. (I can attach to all the other SQL tables.) But, when I select that table I get a message that tells me the name is invalid. ...more >>

Hi, I've got what I think (probably incorrectly) should be a simple SELECT : Two colums with data like col1 col2 1 50 1 51 2 50 2 51 3 50 3 54 I'm trying to bring back items in col1 that have values of both 50 and 51 ( and potentially m...more >>

Hi all, How can get the primary key string from the given table name? i know it should from system tables of "sysobjects, syscolumns, and sysconstraints", but when i execute the statement like that: select a.name from syscolumns a,sysobjects b,sysconstraints c where a.id = b.id and b.name ...more >>

I have a SP that returns the information I want but it returns it in 2 separate queries. Example: Query 1 Name, Number, Class Row 1- Mike Phillips, 154AA, AA and Query 2 Time, Manual Row 1 -12:45:22,0 Row 2 -13:04:56,0 What I want it to look like is: Name, N...more >>

Hi all I need to add data from two Excel sheets (both on the same workbook) to an existing table in my SQL DB. The problem is that each sheet holds different fields for the same record, though the records are sorted by row numbers. (I had to split the fields to different sheets because Excel ha...more >>

Hi all-- I am trying to execute the following query in MS SQL Server 2000. SELECT 1 AS Tag, NULL as parent, 'x' AS [A!1!B], NULL AS [C!48], NULL AS [RepurchaseDetails!49] UNION ALL SELECT 48, 1, NULL, 'y', NULL UNION ALL SELECT 49, 48, NULL, NULL, 'z' ...more >>

Hi I received the below error when trying to run an update from one SQL Server to another. I can insert and select. I cannot delete or update. The permissions have been changed to allow the linked server user to carry out everything, the linked servers are working but we cannot change the ...more >>

I have just tested 3 queries using QA. The complete test information : ------ CREATE TABLE agls1 ( fyear char(4) NULL , fprefix char(3) NULL , fvcno char(20) NULL , fdate datetime NULL , fid char(15) NULL , fiddate datetime NULL , fdesc char(60) NULL , facc char(12) NUL...more >>

I have a table that i want to query and group the records by the month, what SQL stanment would i use? Somthing like this? apart from i know that the "Group BY (MM/YYYY)" wont work !:) Select Date,Name FROM Table Group by (MM/YYYY) Does this make sense? Willa...more >>

Hello All, I have a SQL Query with multiple correlated Subqueries in it. When it gets executed it runs rather slow due to the size of the QT table. Does anybody have any suggestions how to alter this query to make it run faster, or any index suggestions to assist it with. Query is as follow...more >>

Hi all I am implementing a stored procedure which needs to recursively call itself until specific condition is reached, Could anyone give some advice about that? Thanks a lot Robert Song...more >>

Hello, Easy one for the SQL experts. I have a simple table. For the example let's say it looks like this: CREATE TABLE doc_exb ( column_a INT, column_b VARCHAR(20) NULL) Now I want to alter this table and make the column column_a a float instead of an INT. How do I do that? I cannot DR...more >>

Greetings, Our former SQL Server 2000 DBA backed up everything in a single disk file. By everything I mean, full backup, differential backup and transaction logs. See below for details of how the backup is currently set up. When I did 'view contents' of DBBackup, I saw it contained the ...more >>

I have a large table that I recently purged a year of data from. However, the table size in sp_spaceused hasn't decreased as much as I would expect. (there are no text or large object columns on this table, BTW) Running sp_spaceused on the table shows the following. rows ...more >>

We are running into problems on our development environment with extra parameters being added on to a stored procedure call. Instead of the expected stored procedure call, the trace shows something like this: declare @P1 int set @P1=NULL <<expected stored procedure call>> , @P1 output, <<rep...more >>

I am trying to set up a production and test machine on a LAN. The LAN is behind a firewall. Machine 1: Production machine. with SQL server (Server name Prod) Machine 2: Test machine. With SQL server (server name Test) trying to register Prod sql server in Test Sql server via Ent Manager. ke...more >>

I have created a crystal report connecting an OLAP cube .But once i try to view a report it took around 15 minutes and finaly gave an error like "cannot retrieve data from cube".I want to know why it is and how can i create a crystal report for OLAP CUB....more >>

If you are using my lock-monitoring procedure aba_lockinfo, there is now a new version available at http://www.sommarskog.se/sqlutil/aba_lockinfo.html. I recommend that you replace your existing version with this one. Functionally, there are only minor difference, but the older version did no...more >>

Hello - I'm using the following syntax: WHERE pages.ParentID=0 AND CONTAINS(pages.regionID,'#request.thisRegion#') ....and I get the folowing error: [SQLServer JDBC Driver][SQLServer]Execution of a full-text operation failed. A clause of the query contained only ignored words. I'm tryin...more >>

Hello, Forgive a newbie's question ... Can I access SQL Server and the databases and tables within using windows script? If so, could someone point me in the right direction? Regards, Bob ...more >>