I'm running SQL2000 Standard on a 2003 standard server. I want to upgrade to 2005. I have about a half dozen small databases on the system with very basic table structure and maybe 20 very basic stored procedures (select and insert procedures). Anyone know of any problems of just throwing ...more >>

Hi, I have SQLServer 2005 dev edition loaded on a windowsXP Pro machine. I installed it ok. I just attempted to load the Personal Web Site Starter Kit that comes with VStudio 2005 -- it loaded ok, but when I went to view the default.aspx page I got this error: ----------------- An erro...more >>

Can someone help me use the Replace function properly? I try this: SELECT REPLACE('<br />','<br />','vbCrLf'), * FROM Peart3Log This returns all the records, but includes a 'no name' column filled with vbCrLf. Theres a column called [post] within this table that has <br /> tags in it...more >>

Hello everybody How to dynamically find out and store the logical datafile and logfile name from a backup file of a database so that the restore statement of the database could be generated at run time. Gouri ...more >>

I am moving an Access db to SQL as a 'project'. How can I replicate Access's Primary key generation in SQL 2000? Example: EmployeeID, TestID, TransactionID that all have unique primary key numbers that are auto-generated? ...more >>

is there a sql update query or similar that I could type out and run on the fly somehow that would populate a specific field in all of the records of a table with the same value? Thx ...more >>

Is there a better way of doing this: SELECT * FROM PreGXSurvey WHERE dtsurvey BETWEEN CONVERT(DATETIME, '9/25/06', 1) AND CONVERT(DATETIME, '9/25/06 23:59:59', 1) I had to add the 11:59pm time to the end of the date range in order to get values from the select statement. If I exc...more >>

I'm using 2000 on a remote server. I'm having a problem when making a new dts package and putting in the server connection. If I use Remote Desktop and logon to the server I then use "Local" as the name of the server in the connection and it works fine. However if I run Ent. Mgr. from a r...more >>

After creating a table using Enterprise Manager is there a way to print the schema of the table? thanks, Mac ...more >>

it is pretty obvious what I'm trying to do but the query isn't accepted by Sql2005? SELECT Name FROM Users WHERE UsersID IN (EXEC dbo.ReturnDataByModule 'Groups',1200) ...more >>

Is it possible to run only 1 SQL Server 2000/2005 and set it up so that it displays specific databases corresponding to the user account logged in? ...more >>

I need to take data TO and FROM SQL Server to a old application Is it possible tooutput directly using a Select statement?? ...more >>

Hi all. I made the settings as indicated in the How to Configure a Windows Firewall for Ingegration Services Access books online help. 1. On the Exception tab I entered MsDtsSrvr.exe to the Add a Program list 2. Add a port: Set it for port 135 under TCP 3. Set Scope for My network Clos...more >>

I installed SQL Server 2000 on a PC which is on a domain "DOMAIN" and it uses Windows XP Professional. I used Windows Authentication Mode (instead of Mixed-Mode). SQL Server 2000 starts up successfully. Then I installed on a standalone PC which is part of a workgroup "WORKGROUP" (instead of...more >>

Hi, I got a table like this: datetime quantity status 10/30/06 12:01:01 50 ON 10/30/06 12:02:01 50 ON 11/01/06 08:01:03 20 OFF 11/01/06 08:02:03 30 OFF 11/01/06 08:03:03 10 ON 11/0...more >>

I have to move a database from one server to another and in the process I need to shrink the transaction log, cause it's over 180GB and wont fit on the other server at the current stage.. I have absolutly no clue on how to do this.. Is it even possible to shrink data inside a BAK file before ...more >>

Hi there, I have SQL Server 2005 Developer edition on my machine and as it's not something I use all the time I'd like to stop it starting on startup. So my questions are as follows: a) Am I right that I can do this by changing the Start Mode to Manual in Configuration manager? b) If...more >>

I recently downloaded SQL-Server Express and installed it on my desktop running XP. During the installation the program displayed a message indicating that it found traces of beta releases and could not complete the installation. I checked the software installed and I did not see any beta...more >>

I'm trying to export data from an Excel worksheet into SQL Server. I've heard that Bulk Insert or bcp might be the way to go, but I don't know anything about how to go about setting that up. If this would be the most efficient method for transfering data from Excel to SQL, could some please ...more >>

I was given a Sql Server 2005 .bak database backup and, as I know little about Windows databases, have set out to try and massage the data into a form that I can read into PostgreSQL, preferrably something like CSV. I've currently fumbled through an install of SQL Server 2005, restored the .b...more >>

This may be a case of the blind leading the blind. Sorry if this is an extremely basic question. I am fairly new developing ASP.NET 2.0 websites using VS2005. Our dba is fairly new SqlServer 2005. I am trying to access the data he has loaded in sqlsvr. He has set it up using windows a...more >>

Hi all! Well, i have a problem with the transaction log restore. There are every-week full database backup and 12 transaction log backups (2 backups for each day). When I'm trying to restore my database with restoring wizard from Enterprise Manager, full database backup restore is proceedin...more >>

Yesterday I was working on something in Excel. It got hung up because I was working on a .csv file and trying to add data which had color, then I wanted to delete it. The whole thing froze and I saw something that said HiddenFax Window.exe which could not close. When I went to task manager I s...more >>

I have a view with several tables....every now and then it won't open so I check each table in the view and there has been one that won't open so I have to copy it from a backup . Any idea as to why a table won't open when there's no maintenance done to it? Thanks. ...more >>

I have used Microsoft Access for several years and my company now has SQL server. I know that I can upsize my Access databases to SQL but I have learned this is not the best idea. What should I use to create the front-end to my data? It seems there are so many options and I want to spend wh...more >>

If a table has a char field with a length 5, is it possible to allow us to insert a longer string, but the field just takes the first 5 chars? For example, we use Insert Into ... Values ("HelloYou"), "Hello" can be inserted without an error. Is there an option in SQL server on this? Thanks...more >>

Hi I have to work with a database supplied by another company. Its just tables, no views. Unfortunately, they have decided to use @ as the suffix for the indexes, and # as the suffix for the other fields. This makes things a bit difficult for me. I'm going to ask them to change the field nam...more >>