SQLServerCentral / SQL Server 2005 / SQL Server Express

Any Debugger for Sql Server 2005

mandarcoolkarni31 — Wed, 04 Nov 2009 23:05:13 GMT

Hi everyone ,Please Help me i want any debugger for Sql Server 2005 for Procedure.Because i have lots of procedure and i want to Dubug the procedure.waiting for Positive rply.

INSTALLATION AND INSTANCE NIGHTMARE - PLEASE HELP!!

andi.keep — Mon, 02 Nov 2009 22:44:24 GMT

To cut a long story short, I was hapilly using SQL server express 2005 along with VWD 2005 until I ran into a problem. I then decided to uninstall my 2005 suite and go for 2008 (SQL server express and VWD).I seemed to be having numerous problems installing the SQL server express 2008 edition, namely the fact that I found the installation center hugely over-confusing. All I really wanted was an installer like with most programs.So after several hours of browsing the net and trying to install SQL server express 2008, I decided to give up and reinstall the 2005 suite again!Now, when I run the installer it says there is a SQLEXPRESS instance already installed as part of the 2008 package, even though I deleted the whole 2008 suite through the control panel.So basically now I cannot install the named instance SQLEXPRESS because somehow my machine thinks its already installed. Of course I could create another instance but It has been bugging me for so long now I want to get rid of the 2008 instance for good.Any ideas why this is still here and how I could manually remove the instance somehow?Thanks very much for your time.Andi.

SQL Server Express Named Instance problem

FreeHansje — Tue, 27 Oct 2009 08:40:04 GMT

Hi,Today I am confronted with a (to me) peculiar situation:A developer has installed SQL Server Express 2008 on a virtual server. He could not connect from a remote desktop to the named instance(servername\sqlexpress), but he CAN connect to a 'default' instance: servername. I started to look into this, haven't done anything with the Express Editions. I logged in to the server, wher the instance should reside. I checked services and sauw an SQL Server instance running named SQLEXPRESS. Browser and SQLagent where running as well. I opened SSMS for Express and tried to connect to the named instance: succesful! Then I logged in on the PC which is used to connect to this instance and tried to connect to the NAMED instance servername\SQLExpress. Nothing. I pinged to the server and this was succesfull. Tried connecting again, nada. I then tried to connect to a default instance: servername, and lo! I had a connection. I was flabbergasted: I switched back to the server and saw the NAMED instance in SSMS, while on the PC I was connected to a DEFAULT instance. I checked services again, but no, only a NAMED instance service was running for SQL Server.On the server where I had a connection to the NAMED instance I tried to connect to a DEFAULT instance and lo! I created a succesfull connection to the DEFAULT instance as well. So I had 2 instances running, it seemed. I checked SQLServer properties and Object properties, and they seem similar. Databasefiles are in the same DIR, same logins, etc. Next I checked configurations with Surface Area tool and see only the SQLEXPRESS settings, which are correct for remote connections via TCP and Named Pipes.What am I missing here? On the (virtual) server I can connect to a Default and a Named instance, from a remote desktop I can only connect to a Default instance. Is the default instance actually the named instance? The developers are, understandingly, a bit worried: they don't know if what they see on Default is The Truth.

-2147467259 - [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation

Mark Story — Sat, 16 Jun 2007 06:23:00 GMT

I Have SQL Express installed on 17 ships. Each ship has a VB6 Client application using OLEDB to connect to the database on local machine. Other workstations on network also connect - we think without error. The error above is thrown on 4 of the 17 ships. The workstations acting as the file server are supposed to be identical (Windows XP).

We have been assured that all poer save settings on LAN Card and motherboard have been disabled.

If I google on this error, I get over 100 hits going back several years ! Ideas to fix have included turning off connection pooling and using TCPIP instead of Named Pipes on client workstation where database server and application are running.

Any other ideas on what could cause this, or why 13 machines are OK, but 4 are not ? Thanks.

OSQL Bulk Insert

fahamed — Wed, 28 Oct 2009 04:30:56 GMT

How can I insert data from a pipe deli text file into a SQL table using OSQL. Please don't recommend BCP as I have used it before and want to try the OSQL for many reasons.I have got this osql statememnt for selecting dataosql -UMyUser -PMyPassword -SMyServer -dMyDB -Q"Select * From User_Table"But how can I insert data from an external text file into the same table. It has two columns User_Name, User_Codetext file sampleTest1|AX123Test2|BX321help please....

BCP Command with Parameters

fahamed — Thu, 22 Oct 2009 03:35:06 GMT

How can I execute a Stored Procedure with parameters through BCP command.I have the following BCP statement and does not work.bcp "exec MyDB..Letter_UPDATE @UserName @JobNumber" in "'TEST','123456'" -SMyServer -UMyusername -PMyPassword Stored Procedure name: Letter_UPDATEParamters :@UserName, @JobNumberPassing Data : "TEST", "123456"All my other BCP commands are working fine, this is the only SP which has parameters and it is killing me. I hope it is a simple solution.......Help me......

SQL Server Express 2005 - Single User Mode sets automatically

darren.gould.email — Fri, 23 Oct 2009 05:38:44 GMT

I have an installation of SQL Server Express 2005 where the mode is being set to single user mode automatically. I can restart the server and everything will work and allow multiple users to login. When I look at the Master and all the other database settings they are all set to Multi User. Any ideas on why the server is taking place. I have the same setup on about 20 other machines with no issues.

Server Not Found

agmowbray — Thu, 22 Oct 2009 15:27:59 GMT

I have a VS2008 application and a database on SQL Server 2005 Express installed on the SQLEXPRESS instance on the local computer (same computer running the application). Until about a week ago when I had 18 security updates installed by Microsoft everything was working fine but now I cannot connect to the database getting a "server not found or not accessible" error (Named Pipes Provider error 40 - Could not open a connection to SQL Server). I can connect to the database from SQL Server Management Studio and can get a connection to the database from within VS2008 without problem but the application will not connect. I have resorted to Integrated Security and am using this connection string: .ConnectionString = "Data Source=AGM_T3500\SQLEXPRESS;Initial Catalog=MAPS;Integrated Security=SSPI"This connection string works both in the Server Explorer in VS2008 and in Management Studio. What would make it not work from the application?I have SQL Server configured for both Windows and SQL Server authentication and have the server configured to allow remote connections.Any suggestions will be most appreciated.

SQLEXPRESS 2005 Open Connections

SQL Kid-1137444 — Thu, 15 Oct 2009 18:21:39 GMT

Hi Guys,I am running a C#.Net appI have two options1. If i run a single query by opening a connection and running a query and then close the connection it is taking 3 seconds.2. If i open the connection and keep it open and run all my queries using the same connection then the response is instantaneous. ..less than 1 second. I can go with option 2 which gives me the best response time but I need following answers:(a) How many connections can i keep open in SQL Express(b) What type of performance hit will i take by keeping multiple connections open - I need specific answers of hardware penalties(specifica lly speaking RAM) given that SQL Express utilizes only 1GB of RAM.Appreciate your responseThanks

Scheduling SSIS packages

wannabe dba — Thu, 22 Oct 2009 08:42:08 GMT

I need to create an SSIS package on a SQL SERVER Express instance.Is it possible to run the package using TSQL or schedule it to run using OSQL or cmd?

SQL Server Express Connection Issue

Jack C Wang — Wed, 21 Oct 2009 06:52:43 GMT

Hi,I would appreciate if anyone can provide any suggestion to my simple issue. I was trying to set up SQL Server 2005 Express as a database server (connecting by a couple of computers). After many researches, I finally can connect to Express remotely from other computer via SSMS manually. However, if I was trying to connect it from my application. I got timeout error. In both approaches, I am using a new user account that I created on the server. Here is my connecting string: connstring="Server=EHRDBServer\SQLEXPRESS;database=EHRMS;UID=EHRApp;pwd=appsql;integrated security=true"I have gone through steps to set up Express to support remotely connection. I believe this must be a simple question and I just couldn't find the solution.Thanks for your times and comment.Jack Wang

Copy database using SQL 2005

cute_lhen05 — Fri, 10 Jul 2009 01:12:55 GMT

Good day,I am having a hard time copying the database using sql 2005; I already logged in as db owner; i am getting error code 1073548784. i used the 2nd option:use the sql Management object method;thanks!

Running SQL script using SQLCMD and export to CSV file

grc1uk — Thu, 08 Oct 2009 04:06:31 GMT

HelloI have a script that has been written to obtain some data from our SQL Express instance. the script works with no issues. However i need to automate this. I was going to automate this using a SQLCMD -S then call the script which is saved on the server. I dont thing this is going to be an issue, the issue is the results. how can i get these to be exported to CSV file?Can someone let me know the code or the commands needed to obtain this?RegardsGarethgrc1uk@yahoo.com

Testing Functionality on A New Installation

randythesofaking — Fri, 09 Oct 2009 18:48:28 GMT

Hello Forum.I have installed SQL Server 2008 on a network and it seems to be installed with no problem. I was sure to specify it as a Network Service account.But other programs that should be able to access the database are unable to connect.What steps should I go through to ensure that the database is up and running correctly?

The application failed to initialize properly (0xc0000005)

abodesi — Tue, 29 Sep 2009 23:28:14 GMT

i often get the following error when i try to open sql server management studio The application failed to initialize properly (0xc0000005), Click on OK to terminate the applicationsometimes after several attempts it starts but sometimes i have to reinstall sql express edition. for a few days it works fine and again i gives this errorplease help to resolve this issue

SQL 2005 Express Server will not start up in configuration manager

monsieurmark777 — Thu, 08 Oct 2009 07:23:01 GMT

Hi all,I hope this finds you well.I have what can only be described as a disasterous scenario. I have spent months on building a database using microsoft sql server 2005 express, on a vista laptop.I started the server using the configuration manager. All of a sudden, the manager cannot start up the sql server (but the sql server browser seems to be running fine).Any thoughts? I have exhausted the permissioning possibility... if I re-install will it lose all of my data?With my best,Mark

Retrieve databases if the server will not start

monsieurmark777 — Thu, 08 Oct 2009 11:21:13 GMT

Hi all,This relates to my previous post, after many, many, many hours of trying valiant suggestions on google, I have decided to give up trying to get my Vista laptop to work for me, permissions-wise.Would anyone happen to know how I would go about retrieving databases in from sql server express 2005? My Vista machine has gone doolally and I cannot start the server through the sql server configuration manager. I wish to put the databases I worked on, on another PC which is running the full-blown sql server 2005 (not the express version).Any ideas?With my bestMark

SQL 2005 Reporting Services set-up problems. Help!

bobh0526 — Fri, 09 Oct 2009 09:24:39 GMT

Hi all,My first post here. I have been having a terrible time getting SQL Server 2005 Reporting Services running on my PC with SQL 2005 Express. I have posted this message to other forums and no one has been able to help me. Here is the scenario:I have a PC with the regular version of Visual Studio 2005 and the regular version of SQL Server 2005. Please note, these are not the Express versions. Everything works perfectly in this environment. To create new Reporting Services projects, I click on Start, Microsoft SQL Server 2005, and then SQL Server Business Intelligence Development Studio. This all works perfectly.Now to my problem. I have another PC and I want the same exact scenario if possible, so that I can create SQL Server Reporting Services projects but using the Express versions of SQL Server 2005 and / or Visual Studio 2005. Presently, I have only loaded SQL Server 2005 Express and I can build databases correctly. But I notice that when I click Start, Microsoft SQL Server 2005, there is no option for SQL Server Business Intelligence Development Studio.So how do I proceed? I assume I need to download and install Visual Studio 2005 Express, right? I looked for links to site where I can download VS 2005 express but can not find any. Everything is VS 2008 only. I am totally lost here and any help would be greatly appreciated!Thanks,Bob

VB.net 2003 in client cannot connect SQL Server 2000 in server

andrikaunang — Sun, 04 Oct 2009 23:27:50 GMT

hi,I am sorry if my english is very bad, but i will try to explain my problem.I have 1 laptop and 1 PC. I have installed VB.NET 2003 in my laptop(OS : Windows XP), and SQL Server 2000 in my PC(OS : Windows XP).I have been trying to connect SQL Server from VB.NET but it's not working.I have tried to get connection string from oledbconnection(<new connection>).The first step at provider tab, i choose "Microsoft OLE DB Provider for SQL Server".The second step at connection tab, i choose "PT-000FA4DAEDE3" which is server name in my PC.The third step at connection tab, i choose "use Windows NT integrated security".When I press the drop down button to select database on the server, error message is showing.The first error message : "[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied."The second error message : "Login failed. Catalog information cannot be retrieved."I have tried to choose "use a specific user name(sa) and password(********)" and it's not working too.I have ping from laptop to PC and PC to laptop. Both of them success.I have disabled firewall from laptop and PC.I still newbie in VB.NET 2003 and SQL Server 2000.I don't have experience in networking.I have search other website for a solution, but i have no luck.Thank you for your attention. ^^

Collation problem

priest Ivan Delic — Fri, 02 Oct 2009 08:47:38 GMT

Hi all!I posted few times about different issues, but this is new for me.About 4 years ago I've created a database Library in Access, transfered it to SQL Server, using Upsize Wizard. Everything worked fine since...At beggining, let me say that I have 4 tables: BasicData, Books, Members, Loans.Since I live in Serbia I put database collation to be SQL_Latin..., hoping that by using some converters I could convert some letters to Cyrillic. Few days ago I realized that this is not such good idea, so I decided to alter collation into Cyrillic_General_CI_AS. I right-clicked database, and on Option tab I tried to make collation to be Cyrillic_General_CI_AS. I've got a message like:Could not alter collation to Cyrillic_General_CI_AS, because database object Members.MemberFName has the same collation as database. That object is column of table Member.Problem is that object Members.MemberFName is dependeing by collation with database. It is asking me to remove dependency and then try to alter database collation.Please advise me how to remove dependency of object from whole database.Sincerely yours,priest Ivan Delic, Serbia

passing the stored procedure name a key for the hashtable

anu1krishna — Mon, 28 Sep 2009 22:38:47 GMT

hi all,here ihave a query [color=#RED][/color]string query=declare @locationid int ,@locationname varchar(100)select * from table1 where locationID=@locationId ,Locationame=@locationnamethen i have LOcationDataset ds=new LocationDataset();ds=(LocationDataset)sqlutil.GetCache(query);basically this GetCache() mathod listing the sql query in hashTable with the key as "query"hashtable ht=new hashtable();so they are using the sql query as key for hashtable now i need to replace this direct sql with the stored procedure i can do this but i cant pass the only name of stored procedure as key for hash table can any one suggest me what i can do instead.

edit view in a datagrid

mhh12 — Mon, 28 Sep 2009 16:50:31 GMT

I am putting together a web site that includes a SQL Server Express 2008 file.I use VWD 2008 Express and SQL Server Management Studio 2008. It is not designated as an Express version. I have a number of tables and have developed a view between two of them. I have a web page where I want to add, edit and delete records from the second table. The first table has two columns- a UID column and a use name column. The second table has a UID column that relates the two tables. The other columns are a Use name column, a DID column a NID column and a NID name column.Why, when I click on the GridView tasks button and go to configure datasource, accept the connection string, go to the next form and check "specify columns from a table or view" and select K-Use K-UseUseSet, the name of the view I created, and check all the columns- UID, Use, DID, NID and Name, why when I check "advanced" do I find the items "Generate INSERT,UPDATE AND DELETE statements" and "Use optimistic concurrency" shaded out so I can't select them and therefore can't do the Edit and Delete commands in the Gridview?Yes, I know the GRidView doesn't do adds. I have to use a DetailsView.What am I missing?Try not to give me any pages from MSFT. They are usually very optuse and talk in terms I don't understand. My background is Access and I have had very good results with it. The file I am presently working on came from Access.Specifically, I'd like to know what to click on to make this sort of scenario workable. Essentially, the question is how does one add, change and delete records when the table to be changed is a relation of two or more tables in a view?

Installation Error "MOF-Syntaxerror" on SQL Server 2008 Express

geraldschade — Sun, 27 Sep 2009 08:46:18 GMT

On my PC with Windows XP SP3, near the end of the intended installation of ms sql server 2008 express edition, the following error inhibits finishing:"Ein MOF-Syntaxfehler ist aufgetreten" ("a MOF-syntax error has occurred"), presumed that "MOF" means "MOF", whatever this shall be.At this moment, the other window with "installation status" has been working at the highlighted item "installation satus", the last one before the end.The progress bar ist at 4/5th filled up and below it the text "SqlEngineConfigAction_install_configurationrc_Cpu32" appears.If I click at the question mark of the error message window, I am asked to allow the following information to be sent over the internet:linkID 20476Produktname Microsoft SQL Server (=product name)Meldungsquelle setup.rtl (=message source)Meldungs-ID 50000 (=message id)Produktversion 10.0.2531.0 (=product version)EvtType 0x0A2FBD17%401211%401After allowing the information to be sent, I get a HTML page in my browser saying:"We're sorryThere is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information."Repeated trials after rebooting my pc, after deinstallation of the installtion trial, during different wheather and on odd and even dates and so on didn't change the behavior.Can anybody give me a reasonable idea how to approach the problem (if a reply comes faster than within a week, I won't be able to reply instantly).With kind regards an thanks in advance, Gerald Schade

Advice needed

marleyathome — Thu, 24 Sep 2009 08:19:51 GMT

I'm planning on creating a web application which allows people to create, complete, edit and delete risk assessments on various subjects i.e. manual handling, fire, COSHH etc.I'll be creating the database with SQL Server 2005 Express Edition and the application with Visual Web Developer 2008.Now my question - Would I also be able to create an application for a mobile device such as a mobile phone which the assessor can use to complete the assessment after which the details are sent to the database? or would I have to use SQL Server Compact Edition. Or do I need both? I hope this question makes sense.Any advice would be appreciated.Marley

SQL Server Express and SSMS

S Hodkinson — Thu, 03 Sep 2009 08:11:29 GMT

We have one application which uses SQL Server Express which sits alone on its server. I was trying to connect to the server using SSMS but got the error that the SQL Server Express server did not allow remote connections. I have been on to SQL Server Express server, checked that remote connections were enabled which they are (Surface Area Configuration) and checked that my login is a sysadmin on that server.However I still get the same error (does not allow remote connections) when I attempt to connect using SQL Server 2005 client tools. As this is the only SQL Server Express application that we have I am a bit stumped. What am I doing wrong

Unable to connect to server

as400 — Wed, 23 Sep 2009 05:39:10 GMT

I have a number of SQL 2000 databases in use and can connect with no problem. This is the first SQL 2005 Express that I need to use. The database is loaded, and I can access using SQL Mgmt from the local server no problem. But when I attempt to connect from anywhere else, using SQL Mgmt Express, Query Analyzer, ODBC, or any other method, I get connection refused. Its not a login issue, AFAIK, I have mixed mode authentication set and tried using both Windows and SQL logins, but everything fails. Using default instance SQLEXPRESS. (Is that required to connect?)My guess is I have a setting somewhere I need to enable ? Suggestions ?*****************************************************MESSAGE:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

JOINS

sam.marsden — Tue, 22 Sep 2009 06:41:14 GMT

Hi guys!Back again!!I have a slight issue with a join not working....One datetime field i have is "2009-09-22 13:26:54.333" Lets Call it DT1.The other is "2009-09-22 13:26:54.000" lets call this one DT2.The issue i have is that i want to join T1.DT1 to T2.DT2 on the fields above which wouldn't normally be a problem if they were the same.The issue i have is that DT2 atways records the ms as ".000" and DT1 always records them properly.Everything up to the ms should never duplicate so what i was hoping to do was join them as follows:[code]JOIN inserted ON (convert(varchar(20),T1.DT1,113) = convert(varchar(20),inserted.DT2))[/code]But the join is not working...Any ideas??

SQL QUERY RESULTS IN FORMATTED TABLE

sam.marsden — Thu, 10 Sep 2009 08:19:33 GMT

Hi Guys, You've always come up trumps before so i'm hoping you're going to be able to help me this time. Not sure if i'm out of my depth here or not so here goes.....[code]CREATE TABLE [dbo].[SCCall] ([Call_Num] [int] NOT NULL,[Call_RDate] [datetime] NOT NULL[/code]What i would like to do is query the above table and have the results displayed in a table somehow.I would also like to colour code the rows of the table based on the value of Call_RDate compared to GetDate() egif Call_RDate is one hour after GetDate() then have the row red, two hours them orange, three then greenI would also like the results to auto update / refresh at a time interval of my choosing if poss...If anyone has any ideas i'd be really gratefull for your help, also please let me know if you want any more info as even I don't understand myself sometimes!Thanks in advance

detach multiple databases using sp_detach_db

smokinphoenix2000 — Tue, 29 Apr 2008 18:27:36 GMT

All I'm trying to detach multiple databases with the sp_detach_db. All the databases (about 20 of them) have a similar name like LM_04302008. I was hoping to detach all of them in one shot by using a wild card (%) but its not working. How can I detach 20 databases in one shot with one query? I'm a rookie at this and have not found anything on line to help. Any help is appreciated.

SQL Server Database mail

suunil — Mon, 14 Sep 2009 07:05:53 GMT

Hello,I am trying to configure Database mail with SQL server 2005 (express) on 2 different machines. I was able to do it on one of them & the mails are going fine. On the second machine though, the emails are not going & when I do " SELECT * FROM msdb.dbo.sysmail_event_log" I get the following error --> The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2009-09-11T18:38:23). Exception Message: Cannot send mails to mail server. (The length of the data should be a multiple of 16 bytes.). )Thanks for your help!!RegardsSuunil

Getting 'Failure Audit' server errors from MSSQLSERVER

jrbraddick — Fri, 11 Sep 2009 10:43:36 GMT

Here is a message we're getting in the application server log. Any ideas to the source of the problem would be greatly appreciated. Event Type: Failure AuditEvent Source: MSSQLSERVEREvent Category: (4)Event ID: 18456Date: 9/11/2009Time: 11:17:19 AMUser: N/AComputer: SERVERDBDescription:Login failed for user 'sa'. [CLIENT: 61.160.217.23]For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Data:0000: 18 48 00 00 0e 00 00 00 .H......0008: 09 00 00 00 53 00 45 00 ....S.E.0010: 52 00 56 00 45 00 52 00 R.V.E.R.0018: 44 00 42 00 00 00 07 00 D.B.....0020: 00 00 6d 00 61 00 73 00 ..m.a.s.0028: 74 00 65 00 72 00 00 00 t.e.r...

SQL Database help.

devin-1155829 — Thu, 10 Sep 2009 13:26:02 GMT

I am in the process of making a Asset Management system for the IT department at my work. I am getting really close to having it done but the one thing that is causing me some issues is that when I am updating/deleting a record that has been entered it needs to update other records in other tables. So I guess what I am hoping that some one can help me do is come up with some way to update all the records that are attached to each other but happen to be in different tables.If I posted this in the wrong section please forgive me as I am new to this site.Thanks in advance.

EXPRESS and MSXML

ruchika thapa — Wed, 22 Jul 2009 08:47:36 GMT

I can't install sql EXPRESS and error says about MSXML. There were several suggestion to UNINSTALL MSXML 6.0 sp2 then install express gain. Will Uninstalling MSXML effect other microsoft product since MSXML are included with various Microsoft products, such as Microsoft Windows, Microsoft Internet Explorer, Microsoft Office, and Microsoft SQL Server?

Lock Request time out period exceeded

Rahul-765886 — Sun, 06 Sep 2009 08:59:23 GMT

I have application in VB 6.0 and for database i am using SQL Server 2005 Express Edition. Database is located on main server. While opening tables from SQL server management studio i am getting messagebox [b]"Lock Request time out period exceeded"[/b] . When i click on OK button , after few seconds the table gets open. Can somebody help me about this problem. Does it require ServicePack 2 or 3 (SP2 or SP3). Or it's database problem ? Or i need to do more settings for SQL Server 2005 Express Edition. Please refer to the attached image. I image i am opening "Locationwise_Stock table". Thanxs. [URL=http://img186.imageshack.us/i/sqlexpresserror.jpg/][IMG]http://img186.imageshack.us/img186/3870/sqlexpresserror.jpg[/IMG][/URL]

FDHOST launch

mhh12 — Sat, 05 Sep 2009 10:29:59 GMT

MSDN has a very nice description on how to launch FDHOST. This is what you have to do if you want Full Text Search to work in SQL Server 2008. However, it does not fit my computer settings. I do as it says- Start/All Programs/ Microsoft SQL Server 2008/Configuration Tools/SQL Server Configuration Managerand at that point I don't have SQL Server 2008 Services and right clicking anything does not give me MSSQLFDLauncherI have SQL Server Configuration Manager (local) SQL Server Services SQL Server Browser Stopped SQL Server (SQLEXPRESS) Running SQL Server Agent (SQLEXPRESS) Stopped SQL Server Network Configuration Protocols for SQLEXPRESS Shared Memory Enabled Named Pipes Disabled TCP/IP Disabled VIA Disabled SQL Native Client 10.0 Configuration Client Protocols Name Order Enabled Shared Memory 1 Enabled TCP/IP 2 Enabled Named Pipes 3 Enabled VIA Disabled Aliases nothingright clicking produces the following alternatives: Open Refresh View Export List Properties New AliasAs far as I can see there is no way to start FDHOST from the SQL Server Configuration Manager.So how do I start FDHOST? Or where do I find MSSQLFDLauncher and how do I start it? MSSQLFDLauncher is the Service Account for Full Text Search.

Datetime / Date

sam.marsden — Tue, 01 Sep 2009 09:51:26 GMT

Hi again, I have a field which is a datetime vaule and i would to show it ion a different format....2009-09-01 00:00:00.000 is how it appears now010909 is how i would like it to appear..... any ideas??Cheers guys!!

sql problem

dheerajbaghel — Thu, 03 Sep 2009 01:39:08 GMT

i want that user should enter the data in a textbox. and this data should be store in the sql database.pleas help methanks in advance

Database Mail in SQL Sever 2005 Express

Riz Gulamhussein — Wed, 26 Aug 2009 16:29:22 GMT

Hi,I've seen some posts in this forum mentioning Database Mail and SQL Server 2005 Express in the same sentence. My instance of SQL Server 2005 Express doesn't have a "folder" for Database Mail under the "Management" folder. Is this an add-on?Thanks!Riz

SQL Server Express Send Mail

robert.johnson2 — Wed, 22 Jul 2009 14:01:40 GMT

As everyone knows, SQL Server Express does not have a SQL Server Agent nor does it have the innate ability to send an email based on events or triggers.My question is, has anyone successfully built a SP or Trigger that will send an email to one or more individuals based on either an event occurrence or a data update in a table from either SQL 2005 or 2008 Express? If so, can you explain how to do it?

about unique key

raaz66 — Thu, 27 Aug 2009 06:14:05 GMT

I have a column in a table which is declared as unique key.i have to pass null values more than one times.How can i pass null values?Please guide me