Search DaniWeb - mssql2005

Re: SAP db - how to get the time update statistics was performed on a table? 2 Months Ago by peol To check when update statistics was last performed on an SAP table, use database-specific queries! For SAP HANA, check M_TABLES.LAST_COMPILED. In SQL Server, use STATS_DATE. For Oracle, check DBA_TAB_STATISTICS.LAST_ANALYZED. In DB2, use SYSCAT.TABLES.STATS_TIME. Stay optimized, stay ahead! 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 … 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 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 … Re: MSSQL Fields Out Of Order 18 Years Ago by RobStocks [quote=DVHost;301185][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 server remote access over VPN and direct 15 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 connection strings 18 Years Ago by hanifa Hi, I am using MSSQL (Microsoft SQL)to liase with python via third party driver. Well here goes... I have created two instances of SQL registration in my Enterprise manager. It is under i)Console Root->Microsoft SQL Servers->SQL Server Group->(LOCAL)(Windows NT) and ii)Console Root->Microsoft SQL Servers->SQL Server Group->… 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 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 Server problem writing VARBINARY data. 15 Years Ago by LED555 I'm trying to INSERT a zip file into an MSSQL table. The table structure is such: [CODE]CREATE TABLE [dbo].[zips]( [id] [int] IDENTITY(1,1) NOT NULL, [timestamp] [varchar](50) NULL, [inserted] [varchar](50) NULL, [filename] [varchar](50) NULL, [raw_file] [varbinary](max) NULL ) ON [PRIMARY][/CODE]...nothing too fancy. When I … 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 … Re: MSSQL connection strings 18 Years Ago by hollystyles db=MSSQL.connect('INTEL\FR6EnterpriseDB','sa','','SecondDBase') try this, I'm an ADO user so not sure about Python, but the theory should be the same. You see both databases are listening on that IP address 193.168.1.111, which is synonymouse with 'INTEL', the only way to differentiate is that the server with no name is the default and the other… Re: MSSQL connection strings 18 Years Ago by hanifa [quote=hollystyles]db=MSSQL.connect('INTEL\FR6EnterpriseDB','sa','','SecondDBase') try this, I'm an ADO user so not sure about Python, but the theory should be the same. You see both databases are listening on that IP address 193.168.1.111, which is synonymouse with 'INTEL', the only way to differentiate is that the server with no name is the … Re: MSSQL connection strings 18 Years Ago by hanifa Hi it is solved.. the linux problem... I never knew MSSQL uses different port for every instance...dats it... Bottom line: U must specify ur port number in ur connectionstring.. Cheers MSSQL Concurrency 16 Years Ago by AIexplorer … reference material. Primarily I need some basic theory on how MSSQL2005 Express handles queries (its limits), and whether there is anything… MSSQL "A network-related or instance-specific error" and IIS application pool 15 Years Ago by johnyjj2 Hello! I've got web application created for MSSQL and IIS. There are two directories in this application - Scripts and WebSite. In Script there is file CreateDb.sql. I need to run it so that it can create database. I changed in that file one line into this: CREATE DATABASE [NameOfDb] ON PRIMARY ( NAME = N'NameOfDb', FILENAME = N'F:\Inetpub\… 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 … 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-cannot find a title...sorry 16 Years Ago by kava hello, I'm kinda newbie in databases. I have a table like that: DB is MSSQL 2003 Name is varchar Fruit is int (i used the name just to avoid mess with numbers) the number and the type of the fruit is fixed (in real case are 1,2,3 and 4) Qty is int +++++++++++++++++++++ + Name + Fruit + Qty + +++++++++++++++++++++ … 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 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… 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 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 … 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 …