Hi, Our school has an application in which : - Teachers enter comments through a web interface built in asp (not asp.net). - Comments are stored in a SQL server 2000 (in a nText field) - Comments are printed through a MS-Access 2002 front-end... Most comments are in English, Spanish or Fre...more >>

Hi, I have erronous white space at the end of my 'description' field within my 'product' table. I tried using the RTRIM function but it won't let me because it is a TEXTBLOB (text) field. Can anyone show me how to write a query that will update all my rows automatically? I'm using SQL...more >>

Hi, We have a requirement to run profiler continuously to find out the misbehaving applications/SQL in the dataserver. And we are not interested in running it from an individuals local machine. Also we want the profiler to start automatically whenever there are SQL Server/ Machine restarts. ...more >>

Hi Everyone, I'm working on a site that is running MS SQL 2000. They perform regular backups of databases and log files and in the event of a disaster they have a second backup server. At present they regularly copy the backup up files from the production server to the standby server. The p...more >>

Hi below is the code I am using. ------------------------------------ SET NOCOUNT ON DECLARE @emailid varchar(50), @rastype varchar(50), @message varchar(80) declare @allrastypes varchar(200) DECLARE email_cursor CURSOR FOR SELECT distinct Email FROM dbo.tblMaintCustomer ORDER BY Emai...more >>

Hi I need to produce an excel output from SQL that shows email - company name - producttype1, producttype2 (where the - denotes a change in column) basically i have a table the first line is the fields and the second and third are the entries email - companyname - producttype xx@xx.com - xx...more >>

in the market place that will run a query on multiple DBs across multiple servers? Without having to manually connect to each server? If so, can anyone provide a link for it. Thanks ...more >>

I can't seem to find a way to do the following: create table part_table ( col1 int, col2 datetime ) on psX (datename(week,col2)) I want to partition based on the week number of a date field. So if I enter in data like the following in my part_table: (1, 1/1/2007) should go into parti...more >>

Hi everyone, first time here, so I'm sorry if this has been covered already ages ago. :( I am trying to learn T-SQL and Stored Procedures and bought the book on these topics by Djan Sunderic, Publisher McGraw Hill/Osborne. I'm already stuck on my first Stored Procedure and getting error m...more >>

Hi, I am planning to automate a nighty restore of a DB on another server can someone point me in the right direction with the SQL script to modify the logical file names to the correct path and not the ones carried over with the DB?? i.e the database is to be renamed on the new server an...more >>

Hi, I would like to know how to modify the following selects so that - assuming that NewTable already exists - the result of the SELECT is appended to the existing table. If possible I need the appropriate changes for both the 2 syntax below. -1- SELECT * INTO NewTable FROM ( SELECT ...more >>

Never say never..... One of my applications loads a huge amount of data from a text file, sifts through and discards much of it, and rearranges what's left. Finally, it is added to similar data from many other files. For that last step, SELECT * is the sensible way to go. If you really do w...more >>

Hi, how do I do a simple formula, which will search a field for special characters and return a value. If it finds "%" - it returns 1 else If it finds "?" it returns 2 end If this is the incorrect newsgroups, please direct me to the correct one regards Jorgen ...more >>

Hi, another problem I have is that have compounded fields in my sql table. Example product@customer I need a simple function to return "customer", so it should return the value after "@", unfortunate "@" will sometimes be character number 6, sometimes character number 7 etc. regards...more >>

Hi, I have a database and want to store data in Spanish and English. To accompish this: 1. Do i need to create separate tables for both the languages like items_en and items_sp? 2. If I opt for the UTF16 charset what single collation setting can I use? Thanks and Regards Jackal Hunt...more >>

Hello, I am using ASP.NET 2.0 Membership services and to save some time I am not extending the Membership. I realized that I can create a table named "Users" and with a Trigger fill it with a replica of the aspnet_membership table (UserID, Email, Password) and then continue to use the other t...more >>

Hi, I'm a student and I have the following working example that troubles me (in SQL Server 2005): CREATE PROCEDURE dbo.CustomersOrderHistory ( @Firstname varchar(7) OUTPUT) AS SELECT dbo.Customers.Firstname, dbo.Orders.Orderdate, dbo.Orderdetails.Orderamount, dbo.Orderdetails.Orderpri...more >>

Hi, Am I right in saying that by default, an element of complex type in an XSD annotated schema maps to the table with the same name in the specified database. If so does anyone have any idea why my app runs with no errors, but doesn't add anything to the table in the DB. I was hoping to find th...more >>

I'd like to change query: SELECT DM.*, 'condition1', NULL FROM DM WHERE (condition1) UNION SELECT DM.*, NULL, 'condition2' FROM DM WHERE (condition2) to one SELECT like this SELECT DM.*, WasCondition1, WasCondition2 FROM DM WHERE (condition1) or (condition2) but how to fill in the W...more >>

Hi, I have installed a trial version of VC++ Express 2005 with the budled SQL Server. After creating a C++ Forms prototype, with some tables into a database file named Test1.mdb, now I want to make ODBC available this local database. What are the steps required to add and ODBC entry so any ODB...more >>

In a system I'm maintaining there is a Stored Procedure called dbo.MyStoredProcedure. I didn't create this - it was created by a developer who has now left. I don't know how the object came by its "dbo." prefix, but I think he created it in QA. Anyway, there were some performance issues (it ...more >>

Hi all, i have sql servr 2000 standard edition. robocopy is a step in one of the jobs. this step fails in the job where as when i run it from command prompt the same command exceutes succesfully. i have given the owner of the job as sa. acctaully wheni see the files have been copied to the se...more >>

My boss claims that there is a free SQL server runtime. Is this true? I was only aware of MSDE. But I believe the connections are capped at 5 in MSDE. If there is a free SQL server runtime, are there any limitations to using it (performance, connection count)? Thanks. ...more >>

Is it possible to create a link server in SQL Server without using the default system.mdw file? Any help is appreciated. Thanks. ...more >>

hi, i have a problem as a sql developer.i have never used DTS packages for sending data in SQL databases. but i used SSIS which is a new feature in SQL server 2005. so do any of you think SSIS is better now a days and mostly used compared to DTS. jittu.. ...more >>

hello I need some help. The following query works perfectly: ------------------------------------------------------------------ select * from tableA, tableB where tableA.num=tableB.order and tableA.num in ( select tableB.order from tableA, tableB where tableB.order=tableA....more >>

Hi, I've a small problem. I have a table in which one column is date. I want to count the records for statiscs in a temptable grouped by months lets say 12 months back. e.g. month 1 counts 164 rec month 2 counts 87 records and so on. I tried to solve this like this with a function SELECT C...more >>

Hi all... I would like to know how it is possible to make my problem below all in ONE query or stored procedure. I select some rows from a table where the resultset is one column with some values. Lets say 1, 4 and 7: row val 1 1 2 4 3 7 Then I would like these results t...more >>

Hi.. I would not like my customers to have access to any SQL code that is being packaged with our product and hence would like to encrypt it in some fashion. What's your recommendation on packaging/deploying .sql files? Would appreciate any feedback. Thanks, Sandeep Madduri. ...more >>

Hello! I'm migrating an IIS/SQL-Server application from Windows NT4.0 and SQL- Server 2000 to Windows 2003 Server and SQL-Server 2005. My problem is that it is not possible to connect local (IIS and SQL- Server 2005 are runnng on the same node) using ODBC. Running the applikation on a remote ...more >>

A full DB backup of one of my database takes around 3 GB. Half of this is index. All the indexes are in different filegroup. I am wondering if I can only backup the data. For Index I can always run the script to regenerate it. By doing this I can reduce the size of the backup file. Thanks ...more >>

Can someone put me on the right track? I have a .bak file from an MSSQL 7.0 database. I want to restore the database in SQL 2000 or 2005, but the restore fails with the error: "An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)...more >>

A co-worker recently quit the company, and all of his stored procedures and DTS packages are apparently under his name. Is there any way to change his account to another (ie administrator or SA)?? I am afraid to delete his account in fear all the stored procedures will be lost. (we have back...more >>

I must be doing some daft thing- In Management Studio Express I have Northwind, Pubs and a db of my own. I can create SQL select queries and get results back fine but when I try to do an insert, update or delete I get the message: (1 row(s) affected) - making me think all has gone well, however...more >>

I have a table t1 with two columns : c11 varchar(32) , c22 varchar(32) The data in the table is : '11', 'aa01' and on upto '11', 'aa50' : total 50 entries '22', 'b01' '22', b'02' '22', b'03' '33', 'c01' to '33', 'c40' : total 40 entries '44', 'b02' '44', 'd01' '44', 'd01' '44'...more >>

Hi I'm migrating from Access til MySQL. Works fine so far - but one thing is nearly killing me: I got the count of total records in a variabel - (antalRecords) I got the count for the Field Q1 where the value value is = 'nej' Now I just need to calculate how many % of my records have the val...more >>

Hi, We want to encrypt MS Sql Server data files - .mdf and .ldf with logged in user certificate and make sure that MS Sql Server service (running as Local System Account) can decrypt it. Is it possible to encrypt data files with a certificate that resides in logged in user's cert store and...more >>

Hello, I do maintenance on the Back end and have like 10 - 20 connections open...specialized scrips i run and they dont need to be stored proc's is there a way to kill the connection when the script is finished...from my client side..... not just disconnect...cause server still has the poo...more >>

Hi...I have a server that responds to web pages and back end processing....im not sure the best place to start to increase performance..... im a programmer..not a super dba but im pretty good... i have two servers at the isp site....was thinking of putting all the backen store procedures on on...more >>

Hi. I'm trying to build a query which would return TRUE or FALSE as 'IsRerun' depending on the matching status with another table, as follows (simplified query): SELECT ImportedPINS.PIN, CASE ManagerReport.PIN WHEN (IS NULL) THEN 'FALSE' ELSE 'TRUE' END AS IsRerun, FROM Imp...more >>

We have a blob in one table that is storing pdf files. I need to write a select query that will grab that column and write those *.pdf files out to a location on my hard drive. Does anyone know how that can be done? All suggestions would be greatly appreciated.... ...more >>

I got a Small Business Server 2003 running. It has 2 sqlserver processes. One of them is growing by 200mb every day. Does anyone have a clue to this. It's serving as a printserver, fileserver and exchange server. There is no specific use of the sqlserver. The antivirus is MCaffee ...more >>

I need to map several columns of data from one database to another where the data contains multiple spaces (once occurance of a variable number or spaces) that I need to replace with a single space. What would be the most efficient way to do this? I am using SQL2K. I was thinking a function sinc...more >>