For some reason, the SQL server that I manage is not starting up. Long ago when I first installed it, it asked me what account it wanted the service to run under. I believe I set it to a domain account called sqlserver. I don't remember the password I set on that account long ago when I cre...more >>

I have the three server ready to go. The prinicpal is set, the mirror is set. I have a back up of the prinicipal restored on the mirror and then I have a third server that acts as the witness. The problem is I am getting an error message. I am getting this error message: \\\\\\\\\\\\\\\\\\\\...more >>

Hi I need help with some sql. I need to write a stored procedure which can select rows from a table based on certain parameters. But I want the parameters to be "optional". That is, sometimes I want to be able to omit supplying the parameters and the select should then treat it as a "don't...more >>

hi, I hope this is the right place to post this question ... My employer wants me to copy some data from 2 tables, put them into 2 new temp tables, and eventually put those data back. Those 2 tables contain some customer data and since DB is very badly designed, there is no field like "a...more >>

I would like to get information on anyone using database mirroring with SQL 2005. I am considering this as a disaster recovery solution and want to know the extent of it's use. I would like to keep 35 databases (approximately 700 Gigabytes) in sync that are separated by 1581 miles. Does s...more >>

In the Windows XP desktop taskbar, I had a convenient icon control for the SQL Server 2000 System Manager in the system tray. Is there an equivalent taskbar icon functionality available in SQL Server 2005 Standard and, if so, how do I install it? Thanks, Charax ...more >>

Is it possible to compact sql server 2005? How please TIA Guy ...more >>

Hi How can I make a datetime to default to current date/time? Can I set the 'Default Value or Binding' property to something to achieve that? Thanks Regards ...more >>

Hi all I use SQL Server express 2005 Sometimes I change things while I am at home and sometimes I do it at work. Whenever I do that I generate scripts to create the database again on the other place when I reach it. But I never figured out how to copy the content as well How do I do that? ...more >>

I have 2005 SSMS installed on my desktop, but not the database. I also have SQL Server 2000 installed on my desktop, but do not want to install SQL Server 2005 until I have learned a bit, so I can then upgrade my existing SQL Server 2000 databases to 2005. I would like to use a remote SQL S...more >>

I have a question related to uploading data from locally installed DB to web based application with MS SQL 2003. We have 2 products - one is web based and the other is installed which is basically an order management software. We want the ability to upload data from installed to web based, so...more >>

Dear all, In Sql Server 2000, I have deleted the data from a table by mistake, using the "TRUNCATE TABLE" query. Is there is any way to get back my data from the log file? Please help me. Regards, Thirumalai. ...more >>

Hi I want to convert all the text in ClientID field to upper case. Can someone tell me the T-SQL for this please? Thanks Vayse ...more >>

The lack of a simple DATE column type in Sql Server has been chafing me since we began our migration from Informix early this year. With help from Hari Prasad & Dr. Arnie Rowland's answers to our "How to query all records from a table for a date regardless of time" thread we discovered that...more >>

Ok, there's got to be an easy way to do this. Say we have a table 'test_table' with a 'hire_date' datetime column. SELECT * FROM test_table WHERE hire_date = '08/23/2006' against our old Informix database (the column was of 'date' type) would quickly and efficently, using an index on the ...more >>

Hi, I am using MSDE SQL server 2000 version on my Development servers. I am planning to purchase SQL server 2005(standard) version. I would like to know what is major diffrence between above version. Currently we are using basic replications and database for reporting purpose. My SQL ser...more >>

OK...first off, its my fault, I own it, stupid mistake. Now I have to fix it. I inherited an SQL server and was instructed to remove a db to make room on the crowded hard drive. I now know how I should have done it...but what I did was simply right click and delete the database. I cant find ...more >>

I currently have SQL Server Express CTP edition on my computer and want to upgrade to the SQL Server Express with Advanced Services. I know I have to uninstall the CTP to install the Express Advanced. One of my databases has extensive database diagrams and I want to make sure they will be th...more >>

Hi All, Is it possible to debug a stored procedure with SQLExpress ? I haven't seen any related item on the menu... TIA Gultekin. -- ...more >>

I have a stored procedure that has two parameters that have data types of REAL. When the value is passed in, the values beyond the decimal place is dropped and the the value prior to the decimal place is being rounded up. I need it to keep the original value as passed in. If I changed the para...more >>

I received an error message in SQL Service Management Studio that said: TITLE: Copy Database Wizard ------------------------------ The job failed. Check the event log on the destination server for details. ------------------------------ BUTTONS: OK ------------------------------ ...more >>

Hi I downloaded and tried to install the sp1. It went through once completely with 'SQL Server Native Client' left out pending restart. I re-ran the set-up, this time it did the client but on the second item 'Set-up support files' it comes up with 'The following unexpected error occurred: U...more >>

I'm working on an ASP.NET project and when a query is ran, some rows returned are NULL, which is causing my app to break. The data is pulled into my webpage as a string, which I'm converting to Int32 to do a number comparison for page formatting purposes. If the value is NULL, then the NULL ...more >>

I'm preparing a new server to replace an old server, and have scripted the restoration of all user DBs so that Data files will be on RAID 5 D: and Log files will be on a faster drive L:, but I would like to have all system and user data files in the same location and all system and user log fi...more >>

Hi, I am trying to determine a couple of books that will help me understand SQL Server 2005 from a few of perspectives: Optimizing databases, specifically from SQL 2000 - I have a recommended book Pro SQL Server 2005 Database Design and Optimization Developing SQL Server 2005 based appl...more >>

Using SQL 2000 for an ASP Intranet app. When this started 4 years ago, I created two fields of type varchar, size 5000 (they were description fields, so it was possible to have this many characters). I did this because of my inexperience. Now I know that for something this size, a text field w...more >>

I created a stored proc that does a query on a table with several datetime fields. The data was exported from an access database into an SQL2000 database. Several of the fields in the access database originally held just times, and not dates. When the data was exported from the access db to...more >>

When programmming a trigger with T-SQL to response to an After update event is the trigger executed on each record affected or say on a group of records. I think it could be either way. -Fried In RI ...more >>

A user needs to run SQL Profiler, how can enable him to run this tool without assign admin rights? or Any alternative way? Thanks. ...more >>

Hello, I used SQL Server Enterprise Managers' Export Wizard with destination ODBC driver for SQL to create a dts package in the structured file format. I entered the following dtsrun line (msde 2000 sp3) dtsrun /S servSQL /U sa /P thepw /N db.dts and received the errors shown. ...more >>

In Management Studio on the search tab I receive the following error message: Search Failed No search provider has been selected. How do I fix this? Thanks, Tom...more >>

I'm trying to restricted users view of report information based on 3 digit codes found in a misc field. The Misc filed is misc2 and might look something like this (001, 002, 005, 008) including the open and close quotes. Here are some of the things I've tried. USE Test SELECT brnId, Name...more >>

tried sp_info on a sql 2005 box and got Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'sp_info'. Has this SP been replaced by anything in sql 2005? -- George...more >>

Hi All, I'd like to take a copy of all sp's and functions on a database to a text file, by using tsql not the menu. I think there are tsql commands to do this, can you help me? Gultekin. ...more >>

To Whom Can Help: Could someone please tell me how to move all the data and everything else affliated with it from one SQL server to another cleanly installed SQL server? -- Thank you for your help! JYC...more >>

What are the best practices or procedures for defragmenting SQL data volumes and transaction logs? I would like to set this up as part of a scheduled maintenence plan. Thanks! ...more >>

I'm installing SQL Server 2005 Enterprise Edition. After installation I thought I should see the SQL Server Management Console, but it isn't there. What is going wrong, where can I find this MMC??? Marc ...more >>

The absolute rawest of newby questions :( How do I start SQL Server EXPRESS 2005? I have many folders and files installed under c:\Program Files\Microsoft Platform SDK and also under c:\Program Files\Microsoft SQL Server What program can I use to create a DB file? tia ...more >>

Hello, Probably an easy task, but I found it to be beyond my knowledge of SQL. I have two tables: Table1 num_abs name Table2 num_abs_plano tipo active table1.num_abs = table2.tipo My problem: make a join that will show all items from table1 regardless of being present in tab...more >>

Hello I have a table with over 40 million rows. I want to move one column several positions up. I try this in SSMS but it times-out after a short period of time (approx 15 seconds). I did set Query Execution time-out to 0 (Tools, Options, Query Execution, SQL Server, General), and I did ...more >>

I am experimenting with SQL 2005 Express and have created a small database to play with. I have a few tables (People, Departments, Classes - I work at a University) and would like to add some data. I am using MSSMSEmssesesmsessme studio. I added some people to the People table and am read...more >>

HELLO EVERYONE... I HAVE SQL2003 INSTALLED IN TWO SERVERS(ONE IS SBS2003 AND THE OTHER 2003SERVER).THE DATABASE THAT I WANT TO USE IN THE SBS2003. SO I NEED TO "REPLICATE"??? ONE DATABASE TO THE OTHER SO THAT USERS USE THE LOCAL DATABASE INSTEAD OF THE REMOTE AND THEN ONCE A DAY, THE REMOTE ...more >>

I have posted this across several newsgroups. I hope that this finds an answer in one of them. Hello, I have a client that is having this issue: Server 1 SQL Server Database FrontPage Server 2 IIS 6.0 with ODBC connection to database While running a query on the Enterprise Manag...more >>

Hi, I have a table 'A' with a column 'a' which has a certain records with 5 chars and another set of records with 8 chars starting with "xyz" (xyz + 5 chars). How can display the records with alpha sort on the 5 chars records first and then alpha sort on the 8 char records which starts wi...more >>

Hi, I have 2 databases, DB1 and DB2 that I need to backup and restore to 2 different names test1 and test2 which already exist, for training, on a weekly bases. I am getting ready to set this up as a job but there is one catch that I need some help with. test2 creates it's on connection to ...more >>

Hi, I have two remotely connected databases via internet connection, I need to generate reports from these database sources. But it takes a few hours to process. What is the strategy to get the best performance? Thanks. ...more >>

Need help with moving a SQL Server Express 2005 database from one computer to another. I used SSMSE to backup the database on the source server. Then on the target computer I created a new datbase with the same name and tried to restore the backup - it failed saying this backup is not for ...more >>

I have two lines of code to update a field. If there is a value passed the ASP runs the following line strSQL = "UPDATE Activities SET lastmodified = '" & strQty & "'" & " WHERE ActivityId = " & strID If there is no value, meaning its blank then it should run this line strSQLblank = "U...more >>

I have a server that shows up in the enterprise manager and I can connect to it and see the objects; however when I make a new local package in DTS, it is not showing as an available server. How can I fix this? Thanks. ...more >>

When I query using FOR XML, query analyzer always returns some kind of ID code prior to the query results, e.g.: XML_F52E2B61-18A1-11d1-B105-00805F49916B <Schema name="Schema7" xmlns="urn:schemas-microsoft-com:xml-data" xmlns:dt="urn:schemas-microsoft-com:datatypes"> <ElementType name="Nort...more >>