I have a table which could be created with this DDL CREATE TABLE [tran_detail] ( [ticket_number] [int], [open_number] [int], [tran_date] [datetime] , [product_name] [nvarchar] (255) ) I need to compare product_name values between consective dates (the tran_date value) but I'm stuck...more >>

I use SQL Server 2000. My database is 1912.69 MB with no available free space. My logfile is 1 MB. The size of all tables and indexes add up to 200 MB. I have no diagrams, two views, fifty stored procedures, six users, ten roles, no rules, no defaults, no user defined data types, no user def...more >>

In enterprise manager under 2000, I could open a table, view the SQL, then run a stored procedure that returned data from a 2 table select statement and edit the data. It kept me from having to build and interface for specific updates. I try the same trick from 2005 and the cells are read onl...more >>

Hello, can anybody tell me how much faster a 64 bit SQLServer is in comparison to a 32 bit System at similar periphery and costs. Are there any documented tests available? Thanks Tobias ...more >>

Hello, When I type my transact SQL code (or copy it from another database) into a "New Stored Procedure..." window, I can only save it as a .SQL file. Why doesn't it let me save it as a stored procedure within the database? After all, that is what I chose to open... the "New Stored Procedure....more >>

Hi Everyone! I'm relatively new to MS SQL Server, and I have a pretty basic question, which I want to make sure I understand correctly. When I'm designing a table in Enterprise Manager, I use Char and VarChar data types. As I understand you should set their length to the smallest size possi...more >>

I have a Stored procedure that outputs 3 columns. Sometimes I only want a specific column though. Is there a way I can limit output to a specific column using a SQL query that executes the below procedure? It is a query running from Microsoft Excel's import date feature, so I only want a singl...more >>

When I launch the Database Engine Tuning Advisor from SqlServer 2005 I get a C++ runtime error to the effect that attempting to initialize the CRT twice is a no-no. I presume "CRT" refers to the C Runtime Library. And I presume this error shows that this supposedly release-quality applicatio...more >>

Can someone explain why SqlServer2005 returns the following query very quickly (i.e., under 1 second): SELECT link_text, idnum, ts FROM bd_content WHERE parent_id = 0 AND idnum <> 1 but takes almost 20 seconds to return the following query: SELECT link_text, idnum, ts FROM bd_content WHERE ...more >>

I have just installed (hopefully) SQL 2005 Professional, as part of the Visual Studio Professional setup. I already had SQL Server 2000, and SQL Server espress, installed as part of Visual Web Developer. I chose a full installation ( so that I would get the sample databases, etc...). I chos...more >>

Greetings, I am having some trouble with a trigger. This is my first attempt at creating a trigger so any help would be great. The function of the trigger is, on the insert of a row to check the value inserted into to column VEH_REPAIR_CODE. If that value is not 19, send an email to the value...more >>

Working with three tables: Contacts, Invoices, Payments. Want a query to return two columns: Contact Name and Net Amount Due (netting both the invoice amounts and the payment amounts into one number). The following Union query gets close, but it still returns two rows for each contact, one th...more >>

Can SQL 2005 ent & SQL 2000 ent co-exist in the same testing server box ??? Thanks ...more >>

Hi guys, When searching a full text catalog, I would like to allow inflections, but I would also like to require that *all* words (or inflections thereof) be included in a match. FREETEXT() is inherently inflectional, but I do not know how to require all tokens to be matched (because it dis...more >>

A customer has asked me to improve the performance of a system I did for them many years ago. I would greatly appreciate informed opinions on whether SQL Server would be a good candidate for this. The system was originally based on Microsoft Access 2 (later upgraded to 97) and was used only in...more >>

What are people using to deliver a sql server app without revealing the contents of the stored procedures? In general, do they just remain free text? I know there is an encryption option, but it seems that a client could intercept the commands used to create the stored procedures during the in...more >>

Can somone refresh me on the t-sql syntax for grouping where clauses sql statements. I have a table in this format: fname (varchar) | lname(varchar) And I have a list of names, ie: Joe Bloggs Jane Doe Jon Doe I want to select all records except these three people from the table. I...more >>

When we change the Domain Administrator password our SQL 2000 server fails to login using WIndows authentication. It works fine after we change it back to the old password. This happens even if the password has been changed for a week. Does anyone know why this would be the case? Thanks. ...more >>

I have a C#.NET application (although I'm not sure that the language matters) that inserts files into an SQL server database. The files have started to get large, so we get the error message: Length of text, ntext, or image data (292800) to be replicated exceeds configured maximum 65536. f...more >>

Example: I have a table in the following format: ID | LoginTime | IPaddress 2 | 12/05/05 | 255.255.255.255 3 | 12/05/05 | 132.123.123.123 2 | 12/06/05 | 255.255.255.255 3 | 12/06/05 | 132.123.123.123 2 | 12/07/05 | 255.255.255.255 3 | 12/07/05 | 132.123.123.123 I'd lik...more >>

Recently the test instance of a database takes well over a minute for the first update. After the first update, all updates occur in a reasonable time frame. I've searched newsgroups without success for an answer to this problem. Does anyone have any ideas why the first update of the day takes...more >>

Hi, I have SQL 7 server with 4 Gb of log file. I tried to run backup log with TRUNCATEONLY and DBCC SHRINKFILE and nothing seems to happen. I had also tried to backup log and shrink from Enterprise Manager and it didn't help. I see that the real usage in this file is 1.5% but seems that i...more >>

When I run an sp_who2 to examine blocking spids, in the cmd (command) field I will see something like "SELECT". Is there a way to get further details, such as the full SQL statement or procedure that is running on the spid? ...more >>

Hi All I have another problem. Does anyone know a simple method (SQL or Stored Procedure) to create a table by copying another one? For example, in DB2 I can do this: CREATE TABLE SCH.FOO AS (SELECT * FROM SCH.BAR) DEFINITION ONLY Thanks Andre ...more >>

Configuration: Windows 2000 Sql Server 2000 Quad CPU Problem: I have a DTS update operation that takes many hours to run. The process is monthly, and for that process speed is not an issue; however, the database server hosts multiple databases, some with applications that do in...more >>

Evening. Has anyone performed a updating view to Oracle 9i with MS-SQL server, which comprises of several different tables. Basically the idea is to join some information from several tables to one view in MS side. If this can not be done, it could be also done by creating the view in Oracle si...more >>

Hi All! I have to change with a scheduled process some tables' schema. I was thinking of dropping the table and recreating it into the new schema. But I have a big problem: I don't know which is my table's original filegroup, and some of my tables aren't into PRIMARY filegroup. I absolutely ...more >>

Hi, I'm making a simple application which will store different items (in a SQL server 2000 - MSDE database). Each item has a unique ID in this form: [max 2 characters][max 5 characters] / [max 4 characters] / [max 1 character] / [max 1 character] an example: AZ12345/1234/1/A or A ...more >>

i've got a view with records like this: [patientID] [patientName] [diseaseID] 1 john smith 1 1 john smith 2 2 jane smith 1 it's based on a one to many relationship (1 patien...more >>

I have a DTS that import from Excel in SQL server table some records. If i run the DTS from EM all OK! I want to run the DTS in a Stored Procedure with this command: EXEC MASTER.DBO.XP_CMDSHELL "DTSRUN /S SERVER1 /U sa /P password /N UPKG_IMPORT_EXCEL I have an error -2147467259 Failur...more >>

Hi I have a question on indexes - using SQL 2000 developer. My aim is top make Selects as fast as possible. Select Sum(fld), Max(fld2), etc etc >From Table WHERE TranDate> jan 2005 -- Always have date filter and TranDate < sep 2005 and ShopID in (1,3,5,7) -- Not always filtering on ...more >>