I'm using the store procedure below to drop and recreate all my views. It works fine if the string is <=4000 char. I tried to change data type for @text parameter from nvarchar(4000) to varchar(8000) but the error still occur. Question. How can I do to refresh (drop and re-recreate) all view...more >>

Hello there On the place i work with they always used references in all the database for better checking, design ect.. Now when they need to load huge amount of data the reference has slow the performance in 50%. It is obvieous because when the sql check valid data it reduces performance...more >>

Hi All, I am trying to delete rows with duplicate values in the 'nId_mail' column of a table and keep at least one of each nId_mail. I have tried several delete statements posted on this website but none worked for me... not sure why! When I group the columns, I don't get any rows with havi...more >>

I need to get the STATS_DATE on all indexes in the database, table by table. The procedure is being created in the [master] database and it returns correct information for tables in [master]. However, it returns NULL as the STATS_DATE for all other databases. When I switch the database cont...more >>

I was thinking of removing the ADO command timeout values in a VB Application that uses SQL Server 2000 Standard as the backend. Users have complained about timeouts making their life difficult. I have watched the server and noticed very occasional blocking (once or twice a month) during hea...more >>

Using SQL Server 2000. I have a trigger (update,insert) that copies the current record to a change log table. I want to delete the trigger, but when I try to do that, Enterprise Manager hangs up and I have to end the process. Do I have to take the database offline before I do this? I've even...more >>

I have to pull sets of data (users of my client application will pull sets of data) from a table where the different sets are distinguished by a data column. Example: one set containing 2100 rows were inserted on 2007-08-29 14:03:06.887 another set was inserted on 2007-08-29 13:45:37...more >>

Any suggestions for best book on performance tuning ... ...more >>

What is meant when someone refers to a SQL Server Instance??? Does that refer to a SQL Server??? I'm pretty sure it's not a Database. Does it refer to a SQL Server within a bigger server??? For instance...we have a SQL Server called DEV and then within that we have WEB, APP, and REPORTS.....more >>

I am trying to select a set of records into an XML result. To do this I have the following query: SELECT [CODE] '@a',[DESC] '@b',[RATE] '@c',[ALT_CODE] '@d', [CHANGE_DATE] '@e',[CHANGED_BY] '@f',[EXTRA_ASC_1] '@g',[EXTRA_ASC_2] '@h',[EXTRA_ASC_3] '@i', [EXTRA_ASC_4] '@j',[EXTRA_NUM_1] '@k',[...more >>

I want to create a string using the week number and year of a date. For instance, if i have a date of 1/3/2007, which would be week 1 of 2007, i want to create a string that says 'Wk1-2007'. i know it's basically 'WK' + CAST(DATEPART(WK,'1/3/2007') AS VARCHAR) + '-' +CAST(DATEPART(YEAR,'1/3/200...more >>

Is there any literature/documentation about "best practices" when using MS-Access with SQL Server? ...more >>

Hi, Is it possible to use a if or iif in a check constraint or should I use a UDF? Thx ...more >>

i have a problem in sql. there is table of employee in which one column is empid and another is manager_id. and one wants to go to the hierarchy that is emp->manager->manager- >...->root. so how to find that one? ...more >>

MSDE, SQL Express When my customers install our software, i would like them to go thru a "registration" process, that, in part, will create a record in a single record table that identifies the computer that database is installed on. Then when the workstations first login to the database, ...more >>

I have this requirement to pick up the last record based on date and time. For example here are some sample records - 701,1,2007-08-03 00:00:00, 1899-12-30 15:28.000 701,1,2007-08-03 00:00:00, 1899-12-30 21:28.000 701,1,2007-08-04 00:00:00, 1899-12-30 21:28.000 701,1,2007-08-04 00:00:00, 189...more >>

Hi, I've written a trigger that inserts data into Table B if it doesn't already exist in Table B when data is inserted in Table A. The trigger works perfectly for single inserts, but seems not to work at all for multiple inserts. The data is still inserted into Table A, but the trigger does...more >>

Hi. We are having a weird performance issue with a query launched thru SqlDataAdapter from C#. Data adapter executes parametrized queries using sp_executesql, and the query that is concerned is pretty complex and uses a LIKE clause like this Blah LIKE '%' + @Name + '%'. When we launch the ...more >>

Is anyone using this tool to generate reports? General Comments on usage? TIA Sam ...more >>

Dear All Please help in this ,it is very crtical and very urgent.I am using SQL Client in Vb.net Compact Framework 2.0 to connect SQL Server 2000.It is working fine with English collation (SQL_LATIN1_General) but same code gives error with Arabic collation. Error was Plattform not supported ...more >>

does anyone knows if theres a way to correlate session to the objects it uses? ...more >>

I was wondering if someone can explain the following. I am trying to optimise a query and can't figure out why SQL Server is behaving is a particular way. To begin with I am calling two DBCC statements to make sure i've no cache. In the example below I am doing a simple EXISTS check. If ...more >>

Hi, I have a .Net 2.0 windows app that connects to a SQL Express DB. I have 2 Clients using it fine. It accesses stored procs to update data. The clients use integrated security. data source='SQLSERVER\SQLEXPRESS';initial catalog=tbrPData;integrated security=SSPI The problem is on ...more >>

Hi, I have a table with following data Tablename:test Pr dt vs_val 11 2007-08-30 12:57:12.143 1 11 2005-06-11 00:00:00.000 2 12 2005-06-11 00:00:00.000 2 14 2005-06-11 00:00:00.000 2 11 2007-08-30 13:24:42.600 1 11 2005-06-11 00:00:00.000 2 15 2005-06-11 00:00:00.000 ...more >>

I have a database (full mode) that has not been used in a very long time. I have detached the database and moved the mdf to a DVD. Is is necessary to aslo have the original LDF if I plan to reattach later on? I figure SQL Server 2005 can just recreate a new LDF. ...more >>

Hi, We are developing our C#.Net 2.0 applications using the SQL Server 2000 as our database server. We didn't do anything useing the Lock and Unlock so far, and our application runs seems fine, but I'm not sure. Given on this situation that Client A and Client B and Client ... are using our ...more >>

Does MS SQL Server have a system stored procedure or something else that is similar to Windows API GetLocaleInfo? We need to do some country specific processing inside the trigger. Thanks Alex ...more >>

Hi all, We have a client/server application that has been running fine at 30+ customer sites, except for 1 location. The client application is written in Visual Basic 6 and the database server is SQL Server 2000 Standard 32 bit. This particular location has 50 workstations running our appli...more >>

Does anyone know which table the synonyms are stored in, I would like to be able to list with all details quickly without using the Ma agment Studio? Paddy ...more >>