Where is it, it does not appear in any of the menu items I show in my sql server management studio. Where can I find it? Thanks for any help. Bob ...more >>

hello -- I'm trying to help a colleague enhance a dynamic Web-based query tool. The query hits a database with records of disease reports. Each record has county, race, age, disease, date of report, etc. Currently, after running a query, the user always has to start from scratch to build a ne...more >>

Hi, If the leaf level of Clustered Index is the actual data page, is that necessary to reorganize the clustered index? I undstand the non-leaf and root level but should not be at the leaf level. Am I right? Thanks Ed...more >>

I am trying to create a UDF that involves the use of sp_xml_preparedocument but I get the following error when I attempt to use the UDF: "Only functions and extended stored procedures can be executed from within a function." which I think is a totally misleading error message seeing as sp_xml...more >>

Hi, I don't know if I missed anything. I have 2 member tables and one partition view in SQL 2000 defined as following CREATE VIEW Server1.dbo.UTable AS SELECT * FROM Server1..pTable1 UNION ALL SELECT * FROM Server2..pTable2 CREATE TABLE pTable1 ( [ID1] [int] IDENTITY (1000, 2) NO...more >>

Hello. I'm trying to turn on the READ_COMMITTED_SNAPSHOT mode of SQL Server 2005 programmatically from C# by executing SQL statements. The general idea is as follows: turn on single user mode to force all .NET db connections held in the pool to be closed, turn on READ_COMMITTED_SNAPSHOT mode...more >>

I have this function, which likely needs to change: ALTER FUNCTION [dbo].[GetAllUsers_test_fn] ( ) RETURNS TABLE AS RETURN ( SELECT * from users ) I'm trying to get a dataset out with this vb.net code: Function GetAllUsers() As DataSet Dim cmd As New SqlComman...more >>

Hi, I'll need to create a stored procedure for purging a *huge* EventLog table. Since EventLog table is huge, will I need some special techniques to speed up the "DELETE" process, or prevent the system from getting frozen? FYI, my stored procedure for purging is as follows: CREATE PROCED...more >>

I'm working with SQL 2000. TABLE A/Column1 varchar(30) which contain titles such as: 0599899 0505000 I want to return those titles where the 3rd character is <=5 ...more >>

Is their a reliable way to tell why a trigger fired? For example if I write a trigger for Insert, Update, Delete on a table with NO PK or identity column, can I in the trigger code identify whether the trigger was fired for either the Insert, Update, or Delete action? In Oracle you would do:...more >>

Hello All, I have three tables: Students, Assignments, and Scores. Students: ( STUID int, --primary key LNAME varchar (20), FNAME varchar (20), Teacher int ) Assignments: ( AssignmentName char(20), --primary key AssignmentDate datetime, --primary key Teacher int, --primary key Topi...more >>

Hi, I would like to convert a normal date of : mm/dd/yyyy format to a julian date. We use an ERP system that holds values as julian dates. to convert from julian date to normal date we use: SELECT CONVERT(VARCHAR(10),(dateadd(dd, 732646 - 693594, '12/30/1899')),101) -- Returns Calendar ...more >>

I've created a table to capture the output from DBCC SQLPERF on SQL 2005 and I'd like to have a date timestamp in that column. However, when I execute the DBCC statemnet, it errors out giving me the error that there are not enough values to insert into the table. Would anyone happen to know of...more >>

Does ADODB ignore the SQL configuration regarding AdHoc access? I tried running an OPENROWSET from Query Analyzer against a non-local XLS file but it returned an error saying the provider did not give any more information about what happened. Then, I did the same within ADODB. It worked. No ...more >>

Hi, I am new to SQL server. I am creating a database for a small company using SQL server 2005. I need to know what can I use as a front end to make a user interface so that other people can have access to the data base and can search the database?...more >>

Hi There, Is there any way to find out a field has been used in the past, are currently being used by someother procedure I'd like to change field type to int to varchar, it seemed to be not being used anywhere, but just want to know more details which process using the field and when it wa...more >>

Can anyone how to use a query to parse a name column and extract the name as separte values. The data is currently stored as one column in the format Lastname, Firstname MI (ie: Smith, Roger E). Thanks. Mike C....more >>

hey all, i have this view and i just want to list the fields involved so i can paste into my word doc for documentation purposes. Can someone please show how this can be done? thanks, rodchar...more >>

Hi Group, This is my probelm, I have a SQL view which holds prices to 2 decimal place in the Management Console they are displayed to two decimal place i.e. 1.99. However when I run an ODBC report the values are all to mutiple decimal places i.e. 1.9900000000000000000. I have been told th...more >>

Hi, I have some VC++ code that effectively polls until the database status is 'online' using a simple "SELECT DATABASEPROPERTYEX(mydb, 'status')" query command in a while loop. Id like to change this to some event-driven model, but the OleDB documentation isnt helping out much. Is there ...more >>

http://alesrarus.funkydung.com/images/troll.jpg :P -:) ...more >>

Even though I have a couple of small SQL applications running, I have minimal experience with SQL. My current experience consists of C# code using classes and methods from System.Data.SqlClient name space such as SqlConnection, SqlCommand and SqlDataAdapter. I am starting on a new adventure and...more >>

Today I had a problem with one of my tables. When I was doing some testing I typed directly into one of the columns (in SQL Server Management Studio) and received an error "string or binary data will be truncated" - which stopped me being able to change or even delete data in any of the column...more >>

I'm a bit puzzled how I can make a subquery more efficient. Here is a simple example of what I'm after: SELECT em.Name, tr.DistanceTraveled FROM Employee em, (SELECT SUM(distance) AS DistanceTraveled, EmployeeID FROM Trip GROUP BY EmployeeID) tr WHERE em.ID = 123 AND tr.Employe...more >>

Hello! Is there a way or a tool where I can test queries in which I use paramteres like select * from tab1 t where t.f1 = :myparam1 Thx in advance, Fritz ...more >>

Hi In my UDF I have an inline table @msTotals ( market_space nvarchar(50), totalHours float) INSERT @msTotal (some function ) -- so far so good. I need to use an item from this table SELECT m.columnName AS Name1, m.columnName2 As Name 2, ...more >>