SQLServerCentral / SQL Server 2005 / SQL Server Express

Last time when did the SP run

UDAY MANDAVA — Tue, 29 Apr 2008 02:49:25 GMT

Hi,How can we know when did a stored procedure was executed

Time data last modified in SQL Server 2005 Express?

JoeM — Thu, 15 May 2008 18:35:34 GMT

How do I determine the last date/time that any data in a database was modified?I would like to do this in T-SQL running in SQL Server 2005 Express running under windows XP or Windows Server 2003.Hopefully this is easy and I am just too dumb or ignorant to search for it successfully.Thanks,Joe M

How to convert SQL Svr 2005 db to Express 2005

Bobby Wilson — Mon, 28 Apr 2008 15:08:09 GMT

I'm a SQL Server newbie coming from Oracle. Could someone please give me a high level start on how to convert a small 2005 db to Express 2005. I've read this forum and am familiar with and have the DTSWizard...but I'm missing something.thanks

SQL Express with Excel

ramadesai108 — Tue, 11 Mar 2008 11:41:44 GMT

Hi All, Does anyone knows how to connect to Excel from SQL Express?Thanks.

SQL server (standard edition)

myrezti — Fri, 09 May 2008 01:53:56 GMT

I'm the newer migrate from MScsess database to SQL Server, but after i read the tutorial there's any kind of SQL Server. So i with my team decide it to use SQL Server 2005 standard edition. But i've already looking for the cd in my country(Indonesia) but can't find it. So my be someone there can tell me which web site i can download for free becouse i'm just student fron Indonesia University. And also is there condition that for my hardware that SQL can running well. Tks:blink::blink:

Difference between SSRS and the Express version

jschroeder — Wed, 07 May 2008 14:44:37 GMT

Can anyone who is using SQL Server Management Studio Express with Advanced Services perform the steps as laid out in:http://msdn.microsoft.com/en-us/library/aa337471.aspxIf so, does your UI match the screenshots in the link, or did you have to perform other tasks in order to accomplish the steps in the link above? I need to be able to assign browser and publisher roles but cannot find where to do so.

Restoring database

boyfriend-alex — Tue, 06 May 2008 02:41:48 GMT

Hello everybody.I'm trying to restore the database in SQL Server Management.By the way the following message is shown.Can you help me?you want to see the error screen and then click the following link.http://rapidshare.com/files/112916387/error.bmp.html

No transaction is active.

find.roshan — Mon, 05 May 2008 12:56:56 GMT

Hi all,I m trying to get record from one server to another using Commit and Rollback feature in the Sql Server and getiing error message--OLE DB provider "SQLNCLI" for linked server "SERVERNAME\SQLEXPRESS" returned message "No transaction is active."Msg 0, Level 11, State 0, Line 0A severe error occurred on the current command. The results, if any, should be discarded.below is my sql blockBEGIN TRANBEGIN TRYINSERT INTO [SERVERNAME1].[DATABASENAME].[dbo].[TABLENAME](PurchaseByUserID,price,purchasedate,affiliateID,LicenseeID,debittype)SELECT PurchaseByUserID,price,purchasedate,affiliateID,LicenseeID,debittypeFROM [SERVERNAME2].[DATABASENAME].[dbo].[TABLENAME]WHERE Convert(smalldatetime,purchasedate)>=Convert(smalldatetime,'2/14/2008 00:00:00') and Convert(smalldatetime,purchasedate)<= Convert(smalldatetime,'2/14/2008 23:59:59')COMMIT TRANEND TRYBEGIN CATCHRollback TRANEND CATCH

Error 26 - error locating Server/Instance specified.

cp — Tue, 06 May 2008 10:13:26 GMT

Hi there. I've built a windows forms app using vs.net 2005, along with a sql database via sql server express 2005. I need to move this application & data to another computer. So far, I've done the following: 1. Used the installation wizard in VS.NET to create a package for : - .NET framework 2.0 - sql server express 2005 - other app depencies. - application itself. 2. I've successfully installed all the components above. Also manually installed SQL Server Express management Studio on the target machine. 3. loaded up all my existing data onto the target machine by restoring a backup from the source machine. 4. edited my configuration file so that it reflects the new server name.When i start my app and then try to request to see the data, i get the error that i've listed above in the title of the post. The error message also suggests that i should check to ensure that remote connections are enabled on my database, which i've done. I've also started the "SQL Server Browser" service.But i'm still getting the same error message. My connection string looks like: <add name='TerritoryManager.My.MySettings.territorEConnectionString" connectionString="Data Source=[b]YOUR-16EFCDA[/b]\SQLEXPRESS;Initial Catalog=territorE;Integrated Security=True" providername="System.Data.SqlClient" /> The bolded part is the only thing i changed, as it's the new machine name. I have no problems viewing the database via SQL Server Management Studio. Any suggestions would be appreciated. Thanks.

Gettign the output of the stored procedure to a query

Jaya Chitra — Mon, 05 May 2008 00:20:42 GMT

[b]Dear All,[/b]I have an store procedure which will return the file type rights of the user with one column "FileTypeID" with multiple rows.Now i have an another requirement in another stored procedure which will have to take that "FileTypeID" and based on that it has to retrieve the documents in the DB.For this I need to know how to assign the output of the stored procedure to "IN" clause.For e.g., [b]SELECT * FROM Docs WHERE FileTypeID IN ([file types to which the user has the rights which is retrieved from the previous stored procedure][/b]Can any one help in this regard?[b]Thanks a lot in advance.[/b]

SSE 2002 on SBS 2003 Standard R2?

tharbin — Mon, 05 May 2008 15:25:51 GMT

Has anyone here brought up SSE 2005 on a SBS 2003 R2 Standard edition? Any gotchas? I have installed SSE 2005 on a number of systems but I need to bring it up an a SBS standard edition. It is for a very small, and temporary, project so it would not make sense to upgrade them to Premium Edition. I'm pretty nervous about it because I don't have SBS here to do a test install and I will have to do the install through remote desktop since the server is in a different state.

Add a primary key and foreign key using SQL serv mgmt

David Sapp — Sun, 04 May 2008 18:41:54 GMT

I am using SQL Server Mgmt Studio Express 2005 and I have the following tablestbl_Styles with columns StyleIDtbl_Material with columns MaterialID StyleIDThis is an existing database that someone gave to me. tbl_Styles was already there, tbl_Material is new, I just added it.I want to do the following:1. set tbl_Material.StyleID to be a foreign key so I can use it to link the two tables. I want to query tbl_Styles and tbl_Material to find the materials that each style contains.2. I want to set tbl_Material.MaterialID to be the primary key for that table.3. I want to check to see if tbl_Styles.StyleID is the primary key for that table.How do I do this graphically? thanks

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.

SSRS on Sql Express

jschroeder — Tue, 08 Apr 2008 14:02:19 GMT

I am working on Sql Server 2005 Express with Advanced Services and trying to set up the ability for users to view reports from their desktops. BOL is very unclear about if this is possible, and how to do it. The SSRS portion is installed on the same server as SQL Express (of course), it is installed on the Domain Controller, and all users are trying to connect remotely.When a user navigates to the URL, the title block comes up without any of the links, and the user who is set up as the admin gets a "insufficient rights" error when using the BI Dev Studio to "deploy" reports to the server.Only the Network Admin account gets more than the title block on the report URL.Am I running into a "features block" or a permissions error? Also, the BOL talks about setting up users in the predefined roles ("browser", "publisher") but I have been unable to find these roles listed anywhere in the software (I am aware that I can only use the pre-defined roles in the Express edition). Again, BOL isn't clear on where that is.Any guidance would be appreciated.

Installing SQL Server 2005 on Windows Server 2003 - Running Under Qemu

Muhammad Javed — Wed, 30 Apr 2008 00:14:55 GMT

Guys,We are using Qemu to emulate windows server 2003 in Linux environment. We installed .NET framework 2.0 and IIS 6.0 on the virtual machine but,when we try to install SQL Server 2005 on windows server 2003 running under Qemu. SQL Server 2005 setup.exe ends up even before starting the installation and in the application log we can see the following error.NET Runtime version 2.0.50727.42 - Fatal Execution Engine Error (7A05E2B3) (80131506)Please note the .NET framework 2.0 was successfully installed on the machine before we started SQL server 2005 setup.We have been using/installing SQL Server since a long time but never faced this kind of issueWe were wondering that if there is any limitations SQL Server to install on the windows server 2003 that is running under qemu.Any help would be highly appreciated.Muhammad

Access 2003 Project with SQL Server Express 2005

jwellington — Mon, 28 Apr 2008 17:12:28 GMT

Hi,I am using Access Project 2003 with SQL Server Express 2005.When I go to design a new view within Project I get the following message:'This version of Microsoft Access doen't support design changes with the version of Microsoft SQL Server your Access project is connected to. Your design changes will not be saved.'Is there something I need to do to get the full functionality between these two program versions?Thanks

Identity field jumps large blocks of values with new records

kdmerkle — Fri, 25 Apr 2008 07:37:28 GMT

I have an Access 2007 adp file with forms that are bound to a SQL Express 2005 database. The Partner table has a PK field cleverly named PartnerID and it is an int identity(1,1) type. There are currently 1705 records in the table but the PartnerID is up to 17064. It occassionally skips ahead large blocks of values when creating new records. Here are the values:124567891011121314151617181920212223242527282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613081309131013111312131313141315131613171320133513601361136213631367136913704102410841094113501250135014501850215022502350245025502650275028503050315032503350345035503750385039504050415042504350445045504650475048505250535054505550575058505950605061506250635064506550665067506850695070507150725073507850795080508150825083508450855086508750885089509050915092509350945095509650975098509951005101510251035104510551065107510851095110511151125113511451155116511751185120512151225123512451255127512851315132513351345135513651375138513951405141515051515304530553065307530853105311531253135314531553165317531953205321532253235324532553265327532853295330533156095610561156125613659465956596659765986599660066016602660366046610661166126613661466156616661766186619662066216622662366246625662666276628662966306631663569076908690969106911691269136914691569166917691869196920692169226923692469257622762376247625762676277628762976307631763276337634763576367637763876397640764276437644764676477648764978037804780578067807780878097810781190129013901490159016901790189019902090219022902390249025995999609961103571035810361105351053610654106551065610780107821078410785117621185611857118581185911860118611186211863118641186511866118671222412283122841238912390123911239212972129731297412975129761297712979129801298112982129831303613037130381303913040130441304513046130471304913562135631356413566135671356813569135701357113572135731357413575135761357713578135791358013581135821371613717137191472114722147231472414725147261472714728147291473014731147321473314734147361473714738147391474014741147421474314744147451474614747147481474914750147521475314754147551475614757147581475914760147611510015103151041510515106151071510817055170561705717058170591706017061170621706317064I know that the users are not creating, then deleting thousands of records at a time. I know it doesn't really make much difference with respect to data integrity, but the customer is a little annoyed, and I'm curious about what's causing it. Or, at least, I'd like to get some guidance on how to go about querying the transaction log to figure out to troubleshoot the issue.TIA

Is there a way to easily calculate the number of years between two dates.

martin.goodrich — Wed, 23 Apr 2008 09:44:37 GMT

Hi,I am a real newbie to SQL server and I would surely appreciate some assistance.If for example I have a Date of Birth and I need to calculate the number of years between this date and a given reference date is there a nice simple piece of SQL that may yield this?Really up against things and would be grateful of any assistance.Best regards,Martin.

SQL Express for Sharepoint anyone?

Richard Buchner, Chicago — Fri, 05 Jan 2007 09:04:00 GMT

Hi all,

Is anyone using SQL Express as the database for Sharepoint Portal Server 2003?

can you use full text search?

Thanks

Attached Database viewed in read only mode

mbm — Wed, 09 Apr 2008 03:38:22 GMT

Hi, i am trying to attach database which i had detached earlier, now i can able to attached the same but it is displayed in ready only state and not allowing me to do anything with it . Even i stopped the relevant services and delete the database and again try to attahced the previous version of the same (as backup is not working because of some issues with OS, i detached the database and keep it as its backup for time being).Any idea????

Message: Timeout expired

SriSun — Wed, 16 Apr 2008 09:28:46 GMT

Hi All, My clients (C# code) get Timeout exception when they try to download data and insert them into tables through the stored procedure (SQL Server Express).Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)From client (C#) side they have applied infinite wait option, still they see this error 1-10 times.Can any suggest? what should I do in SQL Server Express box to fix this problem.Thanks,Sri.

Linked Servers in stored procedure.Switch statement?

JeremyVnc — Mon, 07 Apr 2008 08:30:25 GMT

Hey guys, I've been working on this stored procedure that basically copies everything from one set of tables on one computer to a database on the network. The catch is is that I'm dealing with multiple linked servers to do this with. I only want to move records to one computer at a time though (user specified). Here is what I'm looking at:[code]CREATE PROCEDURE usp_SyncTables (@NewVersion char(10), @Line int, @WaitDateTime datetime, @StationId int) ASDECLARE @TransName varchar(20)SELECT @TransName = 'Sync'BEGIN TRANSACTION @TransNameif @Line = 1Begin DELETE [LinkedComputer1\SQLEXPRESS].Test.dbo.Codes INSERT INTO [LinkedComputer1\SQLEXPRESS].Test.dbo.Codes SELECT * FROM Test.dbo.Codes UPDATE [LinkedComputer1\SQLEXPRESS].Test.dbo.Version SET WaitingVersion = @NewVersion, WaitingDateTime = @WaitDateTime WHERE StationId = @StationIdEndelseif @Line = 2Begin DELETE [LinkedComputer2\SQLEXPRESS].Test.dbo.Codes INSERT INTO [LinkedComputer2\SQLEXPRESS].Test.dbo.Codes SELECT * FROM Test.dbo.Codes UPDATE [LinkedComputer2\SQLEXPRESS].Test.dbo.Version SET WaitingVersion = @NewVersion, WaitingDateTime = @WaitDateTime WHERE StationId = @StationIdEndelseif @Line = 3Begin DELETE [LinkedComputer3\SQLEXPRESS].Test.dbo.Codes INSERT INTO [LinkedComputer3\SQLEXPRESS].Test.dbo.Codes SELECT * FROM Test.dbo.Codes UPDATE [LinkedComputer3\SQLEXPRESS].Test.dbo.Version SET WaitingVersion = @NewVersion, WaitingDateTime = @WaitDateTime WHERE StationId = @StationIdEndGOCOMMIT TRANSACTION SyncGO[/code]Sorry for any syntax errors. This is my first stored procedure with transaction. What I'd really like to do is just make a variable passed into the stored procedure called @LinkedComputer and just use that variable in the sql command strings. However, I get errors with that. Here are my questions for the elite SQL guys:[b]1. Is it possible to pass a variable for the linked computer name?2. Is there a switch statement I could use to do the above code based on @Line3. Is there a better approach to this that I'm not thinking of?[/b]

SQL Server 2005 Express on XP SP 1

hgottfried — Mon, 28 Apr 2008 10:37:23 GMT

I have to install for a class I'm taking SQL Server 2005 Express. However it required SP2 for XP.I can not install that since I'm using my company computer....Short of buying a new PC, is there another version?

SQL server 2005(Standard version) Data export/import wizard

Tech99 — Sat, 26 Apr 2008 12:04:16 GMT

Hello,I am trying to export data from access (Access 2002) to Sql server 2005(standard edition--SSMS) When I run the wizard and click finish I just see table created. I can not import data. I got error message saying--//Error 0xc0047fe: Data Flow Task: The product lever is insufficient for computer “Data Conversion 1”(41)//When I click preview button all the data shows in that pop up window but not in the physical table which created by wizard. How can I check the SP version of SQL server 2005?ThanksI appreciate it.

Import and Export Data in SQL Server Management Studio Express (Ver. 2005)

Harshana — Tue, 18 Mar 2008 00:23:30 GMT

How I can Import and Export Data using SQL Server Management Studio Express in SQL Server 2005 Express Ed. ?

downgrade data from sql server express edition 2005 to sql server 2000

jeevanr — Wed, 23 Apr 2008 23:38:31 GMT

Good Morning Everyone...Due to some problems i have to change my database from MS Sql Server Express Edition 2005 to Ms Sql Server 2000? Can anyone help me to solve my problem? One more thing is that the tables in express edition contains primary keys, foreign keys, views....In one table there are attachments too... regardsjeevan

Restore a SQL Server Express 2005 database to SQL Server 2005 Enterprise edition

pbyrum — Fri, 18 Apr 2008 13:50:49 GMT

Can you restore a SQL Server Express 2005 database to SQL Server 2005 Enterprise edition? Seems like you can't. I tried it and errors are produced. Any thoughts?

Import Access Data to SQL Express 2005 DB

pbyrum — Wed, 23 Apr 2008 14:44:44 GMT

Hello,I have a SQL Express 2005 database. I have several Excel spreadsheets, all with well defined column headings. I have been using Access 2003 to import the Excel 2003 spreadsheets to Access and then trying to export the data to SQL Express. The problems is that Access imports the data to an existing table with errors. It converts a string of numbers to scientific notation. Any ideas?

Message Box In sql server 2000

computersprogrammer — Fri, 11 Apr 2008 16:37:29 GMT

hi friends this is my first participation here in bref i have create a trigger on my table named customers the question is how to shwo the number pf lines on this table at every new added line this is my triggerCreate Trigger Add On Customers For Insert asdeclare @number intSelect @number=count(*) from Customers' here i needto show the message i have used messageerror but it blok the user and don't allow to him to add other new line and print it don't show the message i am so interestion on this message plz help me friends and thank you.

error

Austin_123 — Mon, 14 Apr 2008 14:02:46 GMT

Hi, i am using sql server management studio 2005 to connect one of our database from sql server 2000 and every time i try to open a table in a database i receive this message for past two days"Unspecified Error (ms visual database tools)" And i can't open the table. Any one can help me? What could be this problem?Thank you.

how to join two tables having no common row and no primary key in any of the two table

jitendrapatil2006 — Mon, 14 Apr 2008 01:15:57 GMT

Hi friends i am new to this forum and i using sql server 2005 express edition i am haivng two tables 1st one having coloum names as "starting_ date, ani,diled_digits,rounded_dur,actual_dur,cost" and 2nd having coloumn name as " countryname,code,rate/min" so i want to query this table . i want countryname and code from 2nd table and starting_date, rounded_dur, cost from 1st table but the problem is i don't have any primary or foreing key defined in any of the table so how to do this please help me..... you can send me the reply on my email id[email] jitendrapatil2006@hotmail.com[/email]

Get Difference from rows on different tables.

gtan018 — Wed, 16 Apr 2008 09:46:54 GMT

Hello everyone,I'm using Sql Server Express and have created two tables. I need help on getting the difference(sum +/-) from two rows on different tables. Is this possible?Example: Table1 has 1,2,3,4,5 and Table2 has 2,3,4,5,6 and I would like to calculate the difference from Table1 and Table2.Please advice.

Starting Out in SQLS Express 2005

Lester Vincent — Sun, 13 Apr 2008 01:38:23 GMT

Hi people. I have previously posted in SQL Server 2000 several times, but now starting to get into 2005.Briefly, problems are this: -Main database is to support a maintenance contractor who receives work from Govt Dept. That is under way, now in SQL 2005.Second database, to be written for my client's subbies's use will be in SQL Express format, with lots of SPROCs copied from the main database.I have downloaded installation files for SSE but need to do the install where I currently run SQL 2000. The SQL 2000 is automatically opened at Workstation Start-Up.I need to refer to both SQL 2000 and the new SSE database on the same machine.Question: -Will the proposed SSE Install over-write anything already on the SQL 2000 instance?Can the two run separately but on the same machine without conflicts?Any help before I do the install would be appreciated.Regards,Lester VincentSydney

Transfer/copy 2000 database to 2005 with 2005 Express

Al Kaufman — Fri, 11 Apr 2008 08:10:42 GMT

How do you transfer/copy a 2000 database into 2005 using 2005 Express? The Help system describes an approach where you right click on the database, choose Tasks and then choose Copy. Copy is not an option under Tasks on my system. Is it possible that Express 2005 does not contain this feature? If not, how can a 2000 database be converted to 2005? If so, how can it be done?Thanks,Al

My second (or more) stupid question(s)

John — Tue, 08 Apr 2008 12:21:57 GMT

Hello, all...I am having trouble connecting to my PROJ001.MDF database.I can connect from within MS-WebDeveloper, but NOT with SQL-Server-Management-Studio. This is very puzzling to me. It appears the SQL-Server-Mgt-Studio is requiring that the database appear in a single folder named C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.[b]My first question is[/b]... do all Sql-Srvr/Express MDF files have to reside in the same folder -- namely C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data??My local server-name is PC2007JOHN\SQLEXPRESS.[b]My second question is[/b]...do I configure a local-server like this with NAMED-PIPES or TCP/IP or shared-memory?More information about my folders....My PROJ001.MDF is located in a folder consistent with web-developer source folders (unless I have that wrong, too, but it is working OK from the WebDeveloper source-code).I am running ASP.net and SQLExpress on my single computer. I have the MS-WebDeveloper installed that allows me to create web-pages with ASP and VB-code. Under that environment, the 'source-code' resides in the c:\...MyDocs...\HTML\Proj001 folder. With the ASP-convention, the DATABASE resides under Proj001 folder in the Proj001\App_Data folder -- thus I put a PROJ001.MDF file in this folder.Not only does SQL-Server-Mgt-Studio have trouble connecting, MS-ACCESS upsizing wizard can't seem to export to an existing MDF.I have an existing MS-ACCESS mdb that I keep trying to upsize to the PROJ001.MDF, but although it appears to succeed, the exported table(s) do not appear in the PROJ001.MDF.[b]My final question[/b]...what is the releationship with CONNECTIONS, INSTANCES and MDF-files???Thanks, in advance...John

Connect to Informix 7.1 CMS database

dmorri18 — Thu, 10 Apr 2008 05:54:56 GMT

Hi everyone! I'm EXTREMELY new to sql server. I downloaded SQL Server 2005 Express with the hopes of converting all of my Access databases to sql server databases. The first thing I need to do is connect to our CMS (I work in a call center in the telecom department). I use Access to connect to it using ODBC, and the connection string looks like this:[code]ODBC;DRIVER={OpenLink Generic 32 Bit Driver};UID=ilumifi;NoLoginBox=No;FetchBufferSize=30;ReadOnly=No;Host=19.92.60.34;Protocol=TCP/IP;ServerType=Informix 7.2;ServerOptions=;Options=19.92.60.34;Database=CMS;Server=OpenLink;[/code]I've entered this in the Query window (correct term?) and it of course does not work. I'm hoping it's just the syntax. I recorded me connecting to our CMS database using Excel, then I just copied and pasted the connection string. Can anyone help me out with this? I've been googling this for the last few days and I can't seem to find any help with this. A few people pointed out www.connectionstrings.com, but I can't get that to work either. Thanks for any help!Dave

Newbie question

jon — Thu, 10 Apr 2008 04:29:25 GMT

Hi.I am having problems understanding the order in which SQL Commands are executed.This came about when I wrote the following script.If not exists(select * from sys.databases where name = 'IPPBxCdr') Create Database IPPbxcdrGo If not exists(select * from IPPxCdr where name = 'Users')CREATE TABLE [dbo].[Users]( [UserID] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Users_UserID] DEFAULT (''), [Password] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Users_Password] DEFAULT (''), [Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Users_Name] DEFAULT (''), [EMail] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Users_EMail] DEFAULT (''), [AccountType] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,)GONow I was under the impression that these commands were executed in a top to bottom sequence, so in other words Ia) first check to see if the database exists and if not creates it.b) the check if the table exists and if not creates it in the database i just created.Some reason I get an error message saying Invalid object name?Anyone care to shed a light on what in the name of heebie jeebies im doing wrong?

Confused over SERVER terms?

John — Wed, 09 Apr 2008 13:37:52 GMT

Team...I am actually confused over the terms SQL-Server, SQLExpress, MASTER, default, server and instance.I am having trouble getting MS-Access table-data exported / upsizing to an existing SQL-server/Express MDF database.I installed SQL-Express and I have SQL-Server on my computer.I installed 'Microsoft SQL Server Management Studio Express'.The server seems to be ..mycomputername..\SQLEXPRESS.There appears to be a master.mdf in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data as well as model.mdf, msdbdata.mdf, mssqlsystemresource.mdf and tempdb.mdf AND JOHN1.MDF, JOHN2.MDF and JOHN3.MDF -- these john-mdfs are my attempts at doing things.I have "copied" JOHN1.mdf to my ASP-source-folder c:\..mydocs..\ASP-PROJECTS\PROJ001\APP_DATA folder.MSSMSE does not seem to want to connect to my APP_DATA\JOHN1.MDF. It only wants to connect to the databases in the MSSQL.1\MSSQL\DATA folder not to any other folder in ..mydocs..\..anyfolder..\..anyname.mdf.Being used to MS-Access, I can 'double-click' on any MDB file and ACCESS opens the database and I can 'see-and-do-things'.But when I 'double-click' on any MDF-file, Windows complains that there is no application for this file-type -- 'huh?' bizarre.I feel lost with SQL-server, DSN(s) , exporting/upsizing from MS-access.I think I am missing a crucial piece of knowledge that has eluded me.Any help will be greatly appreciated.Thanks...JohnPS :cool:-- I created a thread about cannot export from MS-Access in the MS-ACCESS forum.

Reporting Services

sqlrebel — Wed, 30 Jan 2008 11:06:47 GMT

Does reporting services work with SQL Server Express?

Can't Create New Service Broker in read-only msdb

Undebtedly — Thu, 27 Mar 2008 12:16:09 GMT

We're trying to install SQL Server 2005, and getting the following error message:------SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server] Cannot create a new Service Broker in read-only "msdb".. Refer to the server error logs and Setup logs for detailed error information.------I have looked through the error log that the user sent, and I don't see anything obvious. At least, not obvious to me. Anybody have any hints what's going on?Steve