Search DaniWeb - mssql2005

MSSQL transections 13 Years Ago by M.Waqas Aslam hello ! how are you all , hope all of you are in great state of health and peace , well i have some questions , 1- WHAT IS MSSQL TRANSACTIONS . 2- where we use it. 3- Advantages /Disadvantages 4- Any imp information or point which you think it is imp to know about MSSQL TRANSACTIONS . as i am not good in mssql so please use simple language… mssql walkthrough 17 Years Ago by aasahi Hi, I'm a newbie in MSSQL. But i already tried using mysql. How can I create a database in mssql. I mean what would be the first step. I had installed Microsoft SQL Server 2005 along with Microsoft Visual C# Express Edition. The following are the tools found in Start>Program Files>Microsoft SQL Server 2005> Configuration Tools: - SQL … MSSQL Mirroring two servers 14 Years Ago by gvwiberg Hello I'm working a website that is going to be very,very critical. For now, there is one MSSQL 2005 database online. I'm trying to figure out how to setup mirroring for two MSSQL Servers. (Like two mirrored servers) I understand that you can setup a mirroring like "Server", "Server backup" and "Witness" and the … mssql question 13 Years Ago by ZER09 can any one tell if there existing database administration tools like mysql workbench but for mssql i know about sql management studio, but there is other one who will manage mssql other than SSMS? I will appreciate for any help will come. thank you. MSSql 2000 Unable to insert into database 17 Years Ago by kokkee hi, i am using vs.net 2003 and mssql 2000. currently my db size is 2.5gb including DB transaction Log File. For (.BAK extension) is 1.55 gb. May i know how to expand or improve my DB because when it reach the size (2.5GB). i will always get error message : Unable to insert into database. So, i need to purze my DB record to avoid it to have… MSSQL charindex HELP ! 16 Years Ago by yorks Hi all I am pretty new to MSSQL and have a problem. The solution is probably very simple but I cant find it :) I have a database field ZIP, I also have string with consists of a number of UK part postcodes eg 'S10 S11 S7 S17 S8 S3 S30' I want to perform a SELECT check if the database field ZIP is in the string. I have used CHARINDEX as… MSSQL long text problem 16 Years Ago by LeMa50 Well, I'm new here but you can halp me also. I have pretty big problem. I need to store large text (more than 8000 charaters) in variable inside of procedure and then execute that query with EXEC command. Problem is that varchar supports up to 8000 characters and text and ntext cannot be declared inside procedure. Is there any way to do this?… MSSQL 2005 Express Restore Backup Issue 17 Years Ago by oracio Hello, I recently bought a new server and I'm trying to move the MSSQL database from the old mssql (MSSQL 2000) to the new system MSSQL Express 2005. I made a .bak file in the old server and restored it succesfuly in the new server. the thing is that it created a new schema and took the old db user which doesn't exist in the new server. and … Re: MSSQL 2005 Express Restore Backup Issue 16 Years Ago by zenocide [QUOTE=oracio;428705]Hello, I recently bought a new server and I'm trying to move the MSSQL database from the old mssql (MSSQL 2000) to the new system MSSQL Express 2005. I made a .bak file in the old server and restored it succesfuly in the new server. the thing is that it created a new schema and took the old db user which doesn't exist in … Re: mssql connection problem 16 Years Ago by R0bb0b [QUOTE=php2sheik;698050]i want to connect mssql(microsoft sql server 2005), when i connect the following error displayed. why this error mssql_connect() [function.mssql-connect]: Unable to connect to server: note:in my system mssql 2005 is not installed..i connect server which is in another system connected through LAN. if i connect the … mssql connection problem 16 Years Ago by php2sheik i want to connect mssql(microsoft sql server 2005), when i connect the following error displayed. why this error mssql_connect() [function.mssql-connect]: Unable to connect to server: note:in my system mssql 2005 is not installed..i connect server which is in another system connected through LAN. if i connect the sqlserver 2005, is it … mssql connection problem with PHP 16 Years Ago by php2sheik i want to connect mssql(microsoft sql server 2005) using php, when i connect the following error displayed. why this error mssql_connect() [function.mssql-connect]: Unable to connect to server: note:in my system mssql 2005 is not installed..i connect another db which is in another system connected through LAN. if i connect the sqlserver … MSSQL server remote access over VPN and direct 16 Years Ago by ciki022 Hi and greetings to all members, I have MSSQL server 2000 instaled on XP SP2, and I am accessing him over internet and VPN connection, router and ADSL operational, and it works well. Now I added, on remote side, another computer, conected to LAN with first one, and I want to simultaneously connect with both computers to MSSQL server, but that … MSSQL datetime format 16 Years Ago by akronymn I have an mssql database that I need to migrate to mysql. For some reason though any queries to any columns of type datetime are returned in French in the following format: 7/avr/2004 14:00 This also includes all the text of an SQL dump which not surprisingly makes mysql unable to read the dump from the MSSQL db. I've checked that my … MSSQL 2005 & 2008 - Both Installed 14 Years Ago by BasilBear Hi, I am working on a server which appears to have both MSSQL 2005 and 2008 installed. When I start the management studio, version 2008 opens. I am unable to debug triggers because I am told by the management studio that this feature is not available with MSSQL 2005. What is my best course of action: is it to simply uninstall MSSQL 2005?… MSSQL - MySql Database Connectivity 17 Years Ago by sb2008 Hi, A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity since a few fields need to relate. We are having issues … MSSQL HELP (mdb to sql) 14 Years Ago by synfist Hi I have zero knowledge about sql,databases,mssql etc etc. I have installed MSSQL 2005 express edition. What i need i have two access files say data1.mdb and data2.mdb. i need to create a database database1 which has tables from both data1.mdb and data2.mdb. Please tell me how i can do it . Please tell me in … Re: MSSQL: Best way to connect 14 Years Ago by dottomm Hi Nichito - I am new to mssql but am currently starting a new project using mssql and php. I learned that mssql_connect is no longer supported by M$ and they recommend using SQLSRV driver. You can Google sqlsrv to find the download. FYI - Additionally you must use a whole slew of new tags, but it's well documented and isn't too hard to figure … mssql to mysql 18 Years Ago by kuubay hi...is there anybody who has the right software for converting MSSQL to MYSQL?maybe u can share with me? please help coz im still very new to these fields. Re: mssql to mysql 18 Years Ago by nagramana I have developed my own mssql to mysql converter software. Before sending to you can you giveme your personnal mail id with address. Ramana mssql,sqlsrv,obdc_connect 16 Years Ago by orxanx Hi guys. I have web site, but my hosting don't support php functions(mssql,sqlsrv,obdc_connect) :cry: for connections to MS SQL. I need that remote connect to MS SQL and receive from data online. Can you tell me, about alternative ways to import data from remote MS SQL server with php script. What you think about, importing to XML can… MSSQL 2008 Express Edition setup 15 Years Ago by zachattack05 It's been a while since I've posted. Things have been going well for my project, but I'm coming back to the issue of setting up a SQL server on my user's computers. Sknake was kind enough to give me the command line switches to get a MSSQL install set up in a good direction. The problem is that in the 2008 express version the sa user is disabled… MSSQL export to csv with PHP 14 Years Ago by dottomm Hello everybody and thank you in advance for any suggestions and help I hope to receive. I have Mysql experience but now I am working on my first M$sql database project, and I am getting frustrated. I am using php and would like to export a query. It is quite easy to export a query to csv with Mysql, but I can not figure out how or find … Re: MSSQL export to csv with PHP 14 Years Ago by dottomm Hello Codewall - Thank you for taking the time to help me out. I am sorry if I wasn't clear. What I would like to do is export a table in my MSSQL database to an csv formated file. I am not using MySQL. MSSQL: Best way to connect 14 Years Ago by ndeniche Hello guys. I'm developing a web application in which I have to connect to a mssql server which is connected through a proxy server. I have allowed data transfers for the MSSQLSERVER service, and allowed connections for port 1433. I've read that this is absolutely insecure, and it still gives me [icode]mssql_connect()[/icode] errors, so which … Re: MSSQL export to csv with PHP 13 Years Ago by dubinfo [QUOTE=dottomm;1459777]Hello Codewall - Thank you for taking the time to help me out. I am sorry if I wasn't clear. What I would like to do is export a table in my MSSQL database to an csv formated file. I am not using MySQL.[/QUOTE] Hello, Did you find the way to export data from MS SQL Server to csv with PHP ? If yes, could you … Re: MSSQL export to csv with PHP 13 Years Ago by sakarora oops sorry... i didn't saw it was MsSQL.... sorry.... but i'll try to find it for you Re: MSSQL export to csv with PHP 13 Years Ago by sakarora hey.. i found i good post for you... i didn't use that code but i read the people reviews... so may be it helps... [url]http://daipratt.co.uk/exporting-data-sql-server-2005-express-csv-php-mssql/[/url] MSSQL Connection for Yii (How) 13 Years Ago by draven07 ..hi...im working with a Cash Collection System using PHP and a Yii Framework.. ...but i am wondering if it is possible to connect a MSSQL Database by Yii... ..if so...then could you please help me how... MSSQL Fields Out Of Order 18 Years Ago by DVHost [COLOR=#000000]For years I have been working with MS Access and enjoying the simplicity and ease of use. I am now making the move and converting all of my sites to MSSQL. Virtually everything works but in the process, I have found an oddity that I am not used to.[/COLOR] [COLOR=#000000]I have a question about fields in an MSSQL DB or any type of …