You guys might have remembered I posted a similar message earlier this week because of the fast pace nature of this board I my response was shot to the bottom. Summary: I have a table with properties in it, and a property might be listed more than once, everytime the property attempts to ...more >>

I have a fairly heavy duty app that can use SQL2005, however I am getting some rather strange behaviour, if MSDE or SQL2000 is used, this doesn't appear to happen. Here's what happens: The VB6 application makes fairly regular calls on the database (only when the user requests data). At wh...more >>

Hi, I am tearing my hair out at the moment. I have a query that is returning a single comma delimited field, but I have to use dynamic SQL to generate it. i then need to assign that result to a variable. i dont see how to do this. This does not work: SET @sql2 = 'SELECT Reference F...more >>

Hi all, Anyone willing to look at a DB schema Diagram and critics it??? I did not want to send to entire group. please send email to sql_agentman at hotmail dot com Thank you, Lit ...more >>

Hi, I'm FTP'ing a .csv file across from a Linux appliance to import into a SQL Server 2000 database using the following BULK INSERT command in a stored proc: SET @sql = 'BULK INSERT tmp FROM C:\tmp\test.csv WITH (FIELDTERMINATOR = '','',ROWTERMINATOR = ''\n'',FIRSTROW = 2, MAXERRORS=0 )' E...more >>

Hi, If I have nested transactions ( whether good or bad ) can the outer transaction rollback a nested transaction? Tran A Tran B If Tran B commits can A rollback Tran B?? thank you, Lit ...more >>

hey all, Below is a vacation formula that determines vacation hours accrued from hire date. Given: 1. Pay Periods Earned is achieved at the 1st and 16th of every month. 2 pay periods/month 24 pay periods/year 2. Initial Days Vacation Allowed defined: A new employee is given an In...more >>

How can I find out if a SQL server is 2000 or 2005? ...more >>

Yesterday I got a message saying that you definitely don't want to have your file growth too large in SS 2000 because it locks up all writes during the growth time. And that makes sense. So if you've got a 100 G database, you don't want to set autogrowth to 10G for example. The person also ...more >>

This one doesn't work (i.e. doesn't return results): exec sp_executesql N'SELECT * FROM table_name WHERE field_name IN (@FieldNames)', N'@FieldNames nvarchar(18)', @FieldNames = N'''value_1'',''value_2''' This one does: exec sp_executesql N'SELECT * FROM table_name WHERE field_name ...more >>

Im trying to catch an error that MAY occur in a UDF if the value fails to be converted. But I get this error when i try to save. Invalid use of side-effecting or time-dependent operator in 'BEGIN TRY' within a function. According to MS TRY/CATCH is okay as long as Im not affecting any obje...more >>

Greetings, In SQL2005, I'm trying to get a list of all the SQL Modules (SPs, Views, Functions, etc.) that contain cross-database joins, along with the objects that they access in these cross-database joins. I tried the sys.sql_dependencies catalog view, but found that it only contains dep...more >>

Hi, I have a number of tables all with the same field name. I want to update all the records for that field name with the same value but only if the table has record in it. update table1 set field1 = 'myvalue' where table1 has records. Could someone please advise. Thanks Ch...more >>

All, Trying to do a simple SELECT on a table.column where the developer named the column after a keyword... SELECT A.DESC FROM dbo.Table A SSMS throws error "Incorrect syntax near the keyword 'DESC'." How can I get around this? Thanks. -- Mike...more >>

Our jdbc code throws the SQL State = HY010 Function Sequence Error every once in a while. It happens while we are running high volume tests. In other words many interations of the same code simultaneously. We know the code works, so what's different about high volume? We are using jtds wit...more >>

I have a DBA who has put no less than 30 of the statements below in a batch file. When he runs it, the system reboots itself. Any suggestions? sdeexport -o create -l mapbenchmark,shape -f benchmark.sdx -i sde:sqlserver:ServerName -s servername -D sdeservice -u username -p password...more >>

Is it possible for a table to depend on any object other than a user-defined function? I realize that other objects may be referenced by triggers, but those don't count here, triggers have their own dependency list, and triggers are said to depend upon the table for which they're defined (n...more >>

Hi, I have a table with one varchar and integer column table name:test Column details tvarchar-varchar(6) nvalue-int Data's in the table as below tvarchar nvalue 1 1 02 2 003 3 0004 4 00005 5 000006...more >>

Hi, This is in SQL Server 2000. I am trying to calculate the difference in years the age of a person from a predefined start date which has no time and the current date. Declare @StartDate Datetime Set @StartDate = '1/22/1986' Print @StartDate Declare @EndDate Datetime Set @EndDate =...more >>

DTS makes it simple enough to import a text file from the local PC (e.g., C:\MyFolder\MyData.csv) when running Enterprise Manager, but how, exactly (step-by-step), do I go about getting that same text file from a location other than the local PC using a scheduled DTS package? Here are two scena...more >>

Hi all. Every once and a while we get timeouts using SQL2005. Just out of the blue. Finding the correct table and running rebuild on all indexes usually fix this. Is it a god thing to do a rebuild every week or so as a maintenance plan? In online help I found something about "sys.dm_db_inde...more >>

Has anyone got a good method for representing view designs in business documentation? ...more >>

Hi, I am using C# to retrieve a lot of data from an SQL Server 2000 using the System.Data.ODBC.* objects (Odbc Connection, Command & DataReader). While executing I see how the memory consumption of my application steadily rises until it reaches the limit of my machine. Obviously so...more >>

Is it possible to an aggregate on an INNER JOIN element . For example , the sql statement below throws an error because I have a MIN, what i'm looking for is to pick a DISTINCT one in the JOIN Essentially there are 2 Markers with exactly the same value , this is returning 2 records .e ...more >>

anyone please help ! How can I return value Temperature in MS SQL when RowID is Maximun Example : RowID Temperature 5 1502 2 1580 6 1489 4 1402 1 1585 3 ...more >>

Hello there I have database which have full recovery model during yesterday someone mande restore on it from backup of beggining of the day and all changes were lost. I run from yesterday restore from time by log an hour before the user made a restore. and it stuck in roestoring for mor...more >>

I am not familiar with SQL Server but heard about Katmai somewhere in this NG. What's that about? Is he/she the father of SQL Server? ...more >>