Sorry for the dumb question, but I am just new enough to sql that I can't wrap my little brain around this one. I have a system that I need to import data into and I need transpose a few rows as columns. A good example would be if in pubs. I needed the following results. Book, Author1_au_lname...more >>

Newbie needing help. I am using BULK INSERT to get records into a table. In the flat file, I have many ascii 163 characters. The sterling pound symbol =A3. After the insert, I read the value back using ADO and I get ascii 250 for this character instead. Where should I look to make sure thi...more >>

Hi all, I have a problem with a database on sqlserver 2000 ( 120 days eval ed) on Windows 2000. My database had been appended from another sqlserver 2000. But now I have problems to call a stored procedure. This sp is called by a VB6 application. First a command object ist created, a active ...more >>

I am not able to get detail information from what as changed from SQL Server 7.0 to 2000 from T-SQL commands, statements, syntax etc standpoint. any help, whitepaper, URL will be highly appreciated. Thanks ...more >>

I have a directory of files that I would like to upload with some data to a table so that I can store the files in the db. I'm not trying to parse files into rows, I want to stick the actual file in the column. Is there some kind of insert script, or bulk copy that I can use? I have about 150...more >>

Can someone point me at a website that might help me understand about replication and its parameters (e.g. jobs and schedules). We have SQL2005 on an SBServer 2003. We have a third-party database application that lives on the server. We also have four notebooks that keep copies of the appl...more >>

Hi, One of my application with around 20 tables was workng fine for quite a long time ...now it started giving error for users saying "Time out period elapsed prior to completion of the operation or the server is not respondig" My tables are not that big ..one of the tables have 100000+ reco...more >>

Hello, Is it possible to have Books Online 2000 coexist with Books Online 2005 on the same machine? I currently have BOL 2000 on my machine and when I try to install BOL 2005 side by side with it, it detects the older version and insists on 'upgrading' me. If I decline the 'upgrade', the in...more >>

I recently implemented log shipping and wanted to test that the shipped version of the database I was restoring to was operational. So, I detached it from Sql Server, made a copy, and reattached it under a new database name. Then, I created a new server login called "sqlaccount" that should ma...more >>

I have windows 2000 Server Service Pack 4 and SQL Server 2000 enterprise edittion. System has 4GB of RAM. Can I use AWE feature. Thanks. ...more >>

I'm trying to create a function that splits up a column by spaces, and I thought creating a function that finds the spaces with CHARINDEX and then SUBSTRING on those values would an approach. I get an error saying that the I have an Invalid column 'Course_Number'. Not sure why but I am very ne...more >>

Hi friends, i have to select values from the table consider with the following record: No HomePhone WorkPhone Mobile 20 23232 98327 the selection have to be done as: No DeviceType DeviceInfo 20 HomePhone, Mobile 23232, 98327 since there...more >>

Not the best at Sql is it possible to return multiple recordsets from a Stored Proc if so does any body have a example TIA MJ ...more >>

I have two tables. One for Payments and one for Transactions The tables are set up basically like this Payments Account Payment_Amount PaymentID 1234 $100.00 1000 1234 $100.00 1001 1234 $100.00 ...more >>

A new server has been configured where I work and the OS, SQL Server Data and Logs have all been put on a Raid 5 array. I challenged this, and got told this "is the best way of doing it in regard to performance" by a senior DBA. This server will contain over 40 fairly large databases, and is a p...more >>

Hi, I have the following code. Code Snippet Private Sub BtnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnUpdate.Click Dim a As DataTable = CType(DgvCnts.DataSource, DataTable) Dim changedRows As New ArrayList ' retrieve changed rows Dim ...more >>

Does anyone know if there is a simple way to get the results of a DBCC INPUTBUFFER() request into a table? I have a process for monitoring activity that will give me the results of sp_who2 into a temp table, and want to scroll through the active connections and get the input buffers into anothe...more >>

I already have SQL Server 2005 up and running on a server. We have a new program to install that requires a specific name for it's named service. How do you install another named service in SQL Server 2005, run setup again from the install CD? Thanks ...more >>

Hi, Could someone tell me how to create a basic table in SQL Server 2005 using Enterprise Manager? Thanks, Sabir Barkaat ...more >>

Hey everyone, We have a server that is running SQL 2005 but we don't know if it's full SQL 2005 or SQL 2005 Express. Can someone tell me how I can find out? We DON'T have SQL Server Mangement Studio installed. -- TIA, Clayton P.S.: I wrote an iTunes podcast tutorial and ju...more >>

I need at least Visual Studio 2005 Professional in order to install and use SSIS right, because you can only access SSIS via Business Intelligence For Visual Studio...is that correct? I have Visual Studio Standard, and it seems that won't do. Can anyone confirm? Thank you. ...more >>

Hi i want to access a CSV file using OpenRowSet function in SQL Server 2005. Anyone having any idea; would be of great help. Regards, Salman Shehbaz. ...more >>

wtf why would MS buy Yahoo.. they need to buy Oracle or IBM instead I mean what's more important.. paying 50 billion for 4 billion in revenue? or paying 100 billion for 100 billion in revenue? or even SUN I mean for christ sakes--- Search Engines aren't that important-- buy someone that wil...more >>

I know SQL 2005 will put its program files in C:\Program Files etc. How do I make SQL 2005 always put databases and related files (logs etc.) on the D:\ drive, which will be much bigger than C:\, with room to grow, etc.?? This is the SQL backend for a Windows SharePoint Services 3.x intranet...more >>

the following query returns the error: Cannot perform an aggregate function on an expression containing an aggregate or a subquery. Any ideas how to make it work? It's the second SUJ causing the error and i can see why but can't work out a solution. thanks in advance dan SELECT SUM(CO...more >>

I'm very new to SQL Server 2005, so please be kind. We had a vendor in and they loaded their software and the database that was created is sitting on the root (c:) drive. On this server we have another drive where the database should reside, is there a way to move this database to the correc...more >>

Hello, I'm having trouble creating a backup script to save all the databases in the database server. I have the following script but can't figure out how to get this to execute. As you can tell, I'm not a skilled T-SQL guy, nor a DBA. I'd like to create a single file for each db with n...more >>

Hello all, I am not a SQL guy, so a lil hep is needed. When I run the following in QA... SELECT TOP 10 SUBSTRING(C.CASE_TITLE, 0, 20) + '...' AS LinkText, 'Modules/HD/ViewTicket.aspx?ticket=' + CONVERT(varchar(10), C.CASE_ID) AS LinkURL, S.STATUS_TITLE + '-' +...more >>