db backups made using Sqlserver 2k Enterprise Mananger do not have a file extension. The restore program in Sqlserver 2k5 is looking for files with a ..bak extension. Can someone please explain step-by step how to 1) make a db backup in sqlserver 2k that can be restored un 2k5 2) how to use sq...more >>

I am a naive user. We have a database where some of the tables are duplicated. One version of the table is owned by dbo, the other is owned by "test_admin" How do you get a table owned by "test_admin". When would you deliberately choose to have a table not owned by dbo? Is it ever safe ...more >>

I have an HP Pavilion laptop running Windows XP Home Edition with SP2.Can I run SQL Sever2005 Developer Edition on this machine or do I need XP Professional? I also want to run Report Services and see that it requires IIS to be installed. Does IIS come with the Developer Edition or do I have t...more >>

How to restore a sqlserver2000 db backup to sqlserver2005? Thanks, Keith ...more >>

How can be create a updatable view whit DISTINCT clause? TIA Dan ...more >>

Hi How can I move a sql 2005 db (data and all) to sql server 2000? I have made the mistake of developing on sql server 2005 and now found out that production server is still 2000. Thanks Regards ...more >>

Please help. I'm trying to migrate a 2k database to 2k5, and must be doing something wrong. Using the SQL Server Management Studio Express CTP database Restore function, I was unable to navigate to the SQLServer2K backup file location, so I copied the 2k backup into the SQLServer 2K5 backup fo...more >>

According to Programs | Micrsoft SQL Server 2005 | Configuration Tools | SQL Server Configuration Manager, I have instances of SQL Server (SQLEXPRESS), and SQL Server Browser running. I see no other evidence of these programs, and there doesn't seem to be a menu item similar to Enterprise Mana...more >>

How can I 'Port' a SQL:Server 2000 database to SQLServer 2005? Thanks, Keith ...more >>

Hi I have two sql server 2005 dbs on server A. I need to copy all items (tables, view, sps and so on) from the two dbs into a single db on server B. The added problem is that server B is SQL Server 2000 so direct copy is perhaps not possible. How can I achieve this? Thanks Regards ...more >>

Hi all, we are a small company developing software for doctors. We are using SQL Server 2005 Express. We have registered ourself to distribute that version of SQL server. So it's not a problem for single workstations. But we must support small practices too and they need a small network s...more >>

I am developing a database on my desktop using Developers Edition of SQL Server 2000. The database will ultimately be sent to my client to run on his db server. I would like for a specified employee at the client to be able to modify data, add records and delete records. I understand that...more >>

Hi everybody I'm supporting a developers team and for testing reasons I have to provide them with a copy of one of the files in the production database (SQL server 2000) very often. The whole database is restored in the test environment now and the only data that change very frequently and ...more >>

1) We have a trigger which applies further changes to the inserted/updated records. Is this fundamentally bad or an acceptable practice? 2) We suspect that one version of such a trigger is causing deadlocks. Interestingly this does not seem to happen if we use a cursor. See two versions bel...more >>

Is there a query command that will detect whether or not a table row has any foreign key entries that would prevent deletion? Thanks, Keith ...more >>

List authors name and state of author with a "415" phone exchange (first 3 digits)....more >>

Hi, The SQLEXP service is not running and when i try to start it,i get the following error, ERROR:The request failed or the service did not respond in a timely fashion.Consult the event log or other applicable error logs for details. Any help on this would be appriciated. Regards, S...more >>

Hi, I have a simple query, that worked fine until I realized I made a stupid error. I need to update one table with the value from another table. So I used this query: Update p1, p2 set p1.value = p2.value_ch Where p1.exam = p2.code The problem is that, on very rare occasions, p2.val...more >>

Hi, I have a simple query, that worked fine until I realized I made a stupid error. I need to update one table with the value from another table. So I used this query: Update p1, p2 set p1.value = p2.value_ch Where p1.exam = p2.code The problem is that, on very rare occasions, p2.val...more >>

This is my select statement SELECT * FROM Attachments inner join attachmentlinks on Attachments.attachment_Id = Attachmentlinks.attachment_id WHERE object_type = 'emp' I need to update attachments table and set visibleindividual = 0 where object_type = 'emp' Problem is that object_t...more >>

hi, I need to 1) delete all stored procedures from a database 2) replace a common text string in all stored procs is it possible? ...more >>

Hi all, I receive the following error while try to connect to local database and the error pops up,as soon as i open the SQL Mgmt studio. Any help would be really helpful. Thanks in Advance, Shyam TITLE: Connect to Database Engine ------------------------------ Cannot connect to X...more >>

Hi I have SQL 2005 installed on my laptop, just for development work. I only want SQL to manually start - how do I do this? At the moment, I'm going into SQL Server Management Studio, connecting and then stopping the service. Thanks Vayse ...more >>

The following command works great on all of my SQL Instances EXCEPT on new boxes with new SQL2005 installations: use master restore filelistonly from disk = '\\sqlcluster\SQLBackups\ASG-GP\VE\VE_db_200603210200.BAK' I run the script with Domain Admin priviledges and the SQL Logs tells me ...more >>

Installed SQL 2005 Developers Edition including SSIS...when running the new Import and Export Wizard all of the data sources come up in the Data Source dropdown box except for Flat File Source :-[ How can I get the Flat File Source into my new installation for text file imports? Thanks!!...more >>

Hi there We are running SQL Server 2000 Standard Edition (SP4) on a box with 4GB RAM running Windows Server 2003. I have set the Boot.ini switches ("/3GB", "/PAE" and "USERVA=3030") as directed. I have also run sp_configure to enable AWE and increase the minimum and maximum memory set...more >>

I'm looking into getting some type of DBA certification for SQL Server. Should I take the MCDBA exam track for SQL Server 2000, or look more into newer certifications such as the MCTS: SQL Server 2005? My office currently uses SQL Server 2000 for all our database needs. We have over 10 app...more >>

Hi Guys. I am looking for some book recommendations for transact sql, preferrable encompassing sql 2005. I am writing some HTAs that will be querying sql databases. The quieries i will be using will include some joins, unions and inserts. I have only looked at books online sofar and want...more >>

can not restore through Transact-SQL when i use: RESTORE DATABASE MyDB FROM DISK = 'c:\MyDB.bak' I get: "Exclusive access could not be obtained because the database is in use." even database is not in any use thanks ...more >>

If I use backup a sql server 2000 database using Enterprise Manager, can I restore it to different sql server 2000 instance? If not, what is the best way to move a database to a different server? Thanks, Keith ...more >>

Hi, Create ENDPOINT AWProduction STATE = STARTED As HTTP ( PATH = '/ADVENTUREWORKS', AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR), SITE = 'SQLLaunchPc' ) FOR SOAP ( WEBMETHOD 'GetProducts' (NAME = 'AdventureWorks.Production.Get...more >>

Hello all, Our small business is going to need SQL Server for a couple more people and we do want to try to be ligitimate, so I have a few questions about licensing. We have SQL Server 2000 Standard w/ 5 CAL's. Does this mean we can install Server and Client Tools on 1 server and Client T...more >>

How can I start sql server 2005? Before installing sql server 2005, I installed studio .net 2005 and this created, in my Windows Start menu, a folder called "Microsoft SQL Server 2005" with only one subfolder ("Configuration Tools") and a bunch of shortcuts under this last folder. I'm almost ...more >>

Hi, In MS online books for SQL Server 2005 express it is written that (in my words) there is a possibility of port number confusion when connecting to the server if MSDE is installed and the MSDE sp3 is not installed. How to know the last service pack installed? When googling for MSDE s...more >>

Hi, I installed SQL 2005 express on my server (XP Pro) and followed the (Rick Byham) instructions (link) to create a fixe port in order to remote access the server/database. I am still unable to connect to the server (i made a small program which connect very well locally but not remotely) ...more >>

I have a query/view in which I want to omit anyone whose signup date is ON or AFTER 1/1/2005. The field is formatted as smalldatetime. How do I write that in a WHERE statement?! ...more >>

Hello All, Now correct me if I'm wrong, but the log file should not be growing if the Recovery Model is set to Simple, correct? I have a DB that is set to Simple Recovery Model and the log file is growing. we switched one of our other (much larger) DB's to Simple, because we were doing a lo...more >>

Hi, This might be an easy one for you experts. I have two tables. Table A Id, Name,City .. etc Table B Id, FirmId, IDfromtableA, etc I am doing a join table to get the firmid on table A Select * from A Inner join B on a.id = B.IDfromtableA Now .. here is what I intend to do....more >>

Hi, My application is currently running with an Oracle database at backend but now I want to deploy it with MS SQL Server for a client. Can anybody tell me what I should do? I am very new with SQL Server. My application uses sequences that I cant find in SQL Server commands list etc. pleas...more >>

I have a table with 3 columns, and need to update the 4th column to be the sum of those three columns. How can I do that? When I do the following query, I get an error saying you can't use an aggregate in an update statement: Update tblNumbers set Total = Sum(col1, col2, col3) Thank yo...more >>

how i grant to user who has no write permission a temporary permission for a writtnig job like add a new user? thanks ...more >>

I use sp_addrolemember 'RoleNmae', 'UserName' but when i click on user's properties i get a messege "error 21776: the name was not found in the users collection" and user has no permit what is wrong? thanks ...more >>

Is there a SQL Server utility that will create the sql code to re-populate a table? Thanks, Keith ...more >>

Does SQL Server 2K provide a way to enter command line SQL similar to that provided with mySQL? Thanks, Keith ...more >>

Using the SQL Server 2K Enterprise Manager, how can I get a printed copy of the table structure for a database. I just need the info that is shown in the 'Design Table' dialog box. Thanks, Keith ...more >>

Hi, I have installed the SQL 2005 Dev Ed.Once i had installed the SQL 2005,i tried to find for SQL Mgmt Studio,but to my surprise,i do not see the SQL Mgmt studio in my start->Programs. It is something wierd. Could someone help me in this regard.Any stpes of action would be really helpful....more >>

I am using query analyzer to change the value of several fields -- i want the field to be changed to a NULL. What do I use to indicate this in my SET statement?? SET main.billed = [null] ???? ...more >>

I have to tables, Dealers and Data. I'm sure this seems redundant without knowing the details, but I need it to be done and can't figure it out. Each dealer in the Dealers table has 2 IDs, D_ID (primary ID) and S_ID (secondary ID). The Data table has multiple records for each dealer, and th...more >>

I am getting an error whenever I try to start the sqlserveragent. This started happening about three days ago. I have not made any changed to the computer users or permissions and it is a test environment on a local computer. The error is: The dependency service or group failed to start err...more >>

Hi I'm working for an online university, and we are currently in the process of redesigning our portal website. We were thinking of using a single database to store content, quizzes, and assignments coming from multiple courses, as well as user accounts and security. The reason for this, is th...more >>