Hi, I am looking for a document/white paper that gives me a perforamance comparison between SQL Server 2005 Vs SQL Server 2000. We are looking to migrate existing code(without any changes) from SQL 2K to SQL 2K5 and client is looking for performance improvement figures. I am sure many of yo...more >>

hi everybody, I was writing an app to get snapshot backup of mssql server databases using VDI interface, VDC_Snapshot command was successfully issued by the interface(database was in frozen state), then I was trying to read the .mdf and .ldf files in the data folder of the mssql server insta...more >>

When I run this: SELECT ROUND(CONVERT(decimal(10,7), 000002025/100.00),3,2) I get this: 20.2500000 Is there a way I can trim the trailing zeros at the end to get 20.25 without having to resort to string functions? -- obelix "Whether you think you can or you think you cant you are rig...more >>

Hi all, I'm a linux user that is doing some programming against a sql server 2005 db . I am using a shell on linux created via odbc and tds that gives me access - I'm used to the shell from other db's . I'm trying to install a sp I found that creates a dump from the db to 'insert into' statem...more >>

Hi, I’ve the following error message: ---------------- ALTER TABLE [dbo].[AnagraficoAutomezzi] ALTER COLUMN [CodiceXTrascodifica] varchar(10) Go Server: messaggio 4929, livello 16, stato 1, riga 1 Cannot alter table ‘AnagraficoAutomezzi’ because it is being published for repli...more >>

How can I concatenate column values (not row values) in Transact-SQL? Thanks. Pere. ...more >>

I am moving a database from SQL Server 2005 to SQL Server 2005 Express running on a laptop for a demo. I have the database tables and data copied, but am unable to copy the stored procedures. How do I do this? Thanks, Mike Ober. ...more >>

I just migrated my website from a Windows 2000 Server SP4 to new server running Windows 2003 Server Web Edition SP1. Now, I am getting many "SQL Server does not exist or access denied" or "Timeout expired" errors when trying to establish a SQL connection from the site to the SQL server (Win...more >>

I've got two tables. One with rows of all the projects and another with forecasted hours against those projects. How can I return results for all projects that don't have any hours forecast against them? CREATE TABLE [dbo].[EPKP_PROJECTS]( [PROJECT_ID] [int] NOT NULL, [PROJECT_NAME] [...more >>

I want to update current status based on the difference btwn current record count and the most recent record count of the same sourceid and group. the status will be based on wethere the difference btwn the two records is greater or less than a given value e.g < 5 then status is passed else fail...more >>

Hello All, I am having trouble outputing a sql query directly to a text file. This executes but does not no file shows up? What am I missing? select * into [Text;Database='C:mike.txt'] from Current_NCP order by line_number Thanks ...more >>

I am looking for ways to make sure that my log files, i.e. the overall size of the ldf, can be limited to the least amount possible. Isn't it true that the only way to do this in a "legitimate" way is to do more frequent log backups? ...more >>

I have a parameterized INSERT in ODBC (VC++ 7.1 program). I have a column that is set as NOT NULL with a default value of 'A'. When I set the column to NULL on insert, it fails with a 'Cannot insert NULL into column XXX' error. Is there a way to force the parameterized INSERT to use the def...more >>

I want to tune tempdb database . I increased the size of the tempdb transaction file, and also rewrite my reports queries, reindexing but some of the reports taking 3 - 4 hours Is there anyway i can improve my tempdb database and queries?...more >>

I am using SQL 2005 and Visual Studio 2005. I have two T-SQL Stored Procedures: InsertInvoiceMasterRow InsertInvoiceDetailRow Question: Is it possible to create a transaction that will rollback without using ADO.NET *transaction* from client? Here is an example of what I am trying to do...more >>

Hi there! Still pretty new to sql server. Just wanting to know if there is a way to run many .sql files at once. Ive looked at some other threads and people have mentioned things like sqlcmd and osql and stuff like that. Never worked with command lines for running files. Is there an easier ...more >>

Hello everyone- I'm putting together a report that I really only want to pull data from one main table and join on lookup (lu) tables. I have my query in running condition but I just found out that I do not need to subquery a different table...instead I need to subquery the same table. ...more >>

Hello All, Is there anyway to get records back of "6" or above on nvarchar field? Example: 1A,7B,9S,21F,12D,4W,3Q,33 I'm trying to select only with "6" and above: 7B,9S,21F,12D,33 Thanks, Walter ...more >>

Howdy, I'm trying to do a simple select statement as seen below. SELECT * FROM CAUSERS WHERE dtCreated = 10/1/2006 this returns nothing. I have one record in this table where the dtCreated equals '10/1/2006 10:58:00'. How do I filter by the date? if I specify in the select statement dtC...more >>

Hello all, i have 2 tables that hold dates. I need to pull the date from one table and over wite it in another table. the primary key in Table A exists in table B but in a one to many type setup. can anyone give me a query that will preform this task. Here is what I have so far. Upda...more >>

I have a need to send event alerts to employee cell phones when certain records are added. My intent ins to use SMS messaging. We have an internal SMS gateway that I've just been granted access to, but I can't find any way to successfully send the message. I found some SMTP-based suggestion...more >>

Hello, We have a .NET application that ran in 2 to 4 minutes with SP3a but has slowed to 1 - 1.5 hours since installing SQL Server 2000 SP4. We have not been able to find anything to point out the possible cause(s) for this. Any pointers or suggestions would be appreciated. There hav...more >>

Does anyone know if there's a way, using SQL Server ODBC Bulk Copy extensions (bcp_bind, bcp_sendrow, bcp_batch, etc.) to determine exactly which row/rows were not imported if an error occurs (like a Violation of Primary Key, etc.) With SQLBulkOperations it can be done with a status array, ...more >>

Hi, I have a situation where I want to insert or update or return error depending on how many records we can find in the table. If 0 then "insert"; If 1 then "update"; if >1 then "return error". Thinking about multi-user concurrently operating on this table, I don't want that the same record...more >>

I've a stored procedure that exits without warning and without error when it's called from within a trigger that was called by another stored proc. Here is a quick explanation (for disembiguation purpose): Stored procedure A creates a record in table B Table B has a before insert trigger th...more >>

I backed up a database from one server and now I'm trying to restore it to another. Both servers are SQL Server 2005. When I try to enter the path of the backup file as the device restore from, I get this error: Operating system error5(Access is denied.). I have tried giving the user unde...more >>

Hi: I need to troubleshoot a query/stored procedure performance issue on one of my client's production servers. The issue is my client prefers that we dont run any profiler (GUI) trace or server side trace on the production server. They want to know if it is possible to trace query perform...more >>

Hello all, I need to put an IF ELSE around the below code of containerid == 0 or isnull, but I just can't seem to get it, can anyone help please? and ContainerApprovals.ContainerID in ( select ContainerID from dbo.fn_RegionContainers(@RegionID) ) and Thanks, JY...more >>

Hey, its been a long time since I've been working on MS SQL server. It's good to be back, but I have a backup/restore question. I have a customer whose production db and test db are on the same physical server. We want to copy the the production db over to teh test db for more relevant testin...more >>

Hi, I have a situation where i want to count the number of forms input into a database by each user, but am unsure how to do this in SQL without passing each users name one by one as a parameter. The database design is not ideal, and the users name is stored in the forms table i.e: Form1...more >>

Hey All, I need to have some very involved things happen on a trigger, which inlcudes some external file maintenance when a table is updated, like exporting to a file (can be done with sp_makewebtask) and posting to a message queue. Because of the permissions needed to do the sp_makewebt...more >>

If you are having problems with the warning "Warning: The join order has been enforced because a local join hint is used" being returned from your stored procedure causing your calling code to error, then here is a possible solution. Create Function that uses the INNER LOOP JOINT hint and ...more >>

I'm studying for the SQL MCTS 70-431 exam, and found this question in a practice exam: "You are moving a SQL Server 2005 database named Timesheet to a new database server. The Timesheet database is used by the TimeEntry application. You need to minimize the amount of time that the TimeEntry ...more >>

Hi, I am using SSIS to migrate from a flat file source to a database. In the source file there is timestamp but the source column expects a smalldatetime, is there a way to covert between these two types? Thanks ...more >>

Hi I want to Turn Caps Lock off when I start my Application If Caps Lock option is on. Can anybody help me. Kindly do tell me about it. ...more >>

Hi, I have a question that I wonder if someone might be able to help me with... I have an application which handles real-time financial data from a third party source. The data comes in via events which are fired on an arbitrary thread, and I then take the data, generate update commands f...more >>

I have a list like this 1 999.00 2 999.00 3 999.00 4 123.45 4 123.45 5 29.23 5 34.21 already ordered by the second column, how do I say just give me the group of items which the max number of ColumnB? so only the items with 999.00 would come back no mater what th...more >>

Hi All, I want to know whether SQL server will put a page lock for an update on a single row. Also I need to know whether a record can exist in two pages (Eg: an update on a single record can effect two consequent pages). This is really urgent so a quick response in very much appreciated....more >>