Does anyone happen to know if the folks at Red-Gate used a public SDK
to create the log explorer, or did they fork over money to microsoft to
get a ISV licensed SDK?
I'm looking into making a similar product that would be open source,
and I'm trying to figure out what they used to translate entries in the
log to something that is readable by the human eye.
Thanks.....
First, I know nothing about PLC's, but I was wondering is there a wayto extract data from a SQL database file, feed that to a PLC is somemanner, and then have the PLC trigger a diverter gate based on thevalue in the table exceeding a certain value, to divert parts toanother location.Am I off base, or is there something out there that will allow or helpme to do this. Any help would be greatly appreciated.
View 2 Replies View RelatedI've been looking at using Red Gate's SQL backup pro for two reasons: compressed back up files, and it's log shipping functionality with SQL standard edition. Anybody have any feedback on it, likes, dislikes, etc.?
Thanks,Pete
Currently evaluating Red Gate SQL tools targetting SQL Server 2005 Express.
Specifically
- SQL Compare
- SQL Packager
- Dependency Tracker
This is the first tool of this kind that I've evaluated and must say I'm impressed. It looks like it will save me hours of writing scripts.
Any of you guys have any thoughts, recommendations, etc to share? Alternate tools?
Most appreciated in advance, thanks.
Anyone have experience with either of these products? Your thoughts?
-a
Hi all,
I just realized recently that a database "XYZ" in the Object Explorer of my SQL Server Management Studio Express (SSMSE) is put in the Database Explorer of my VB 2005 Express for processing a Stored Procedure in executing the SELECT statements (not by using Input and/or Output Parameters) during the ADO.NET 2.0-VB 2005 Express programming, then the content of the database "XYZ" is not in the SSMSE. How can I return the database "XYZ" from the DataBase Explorer of VB 2005 Express back to the Object Explorer of SQL Server Management Studio Express (SSMSE) safely? Please help and advise.
Thanks in advance,
Scott Chang
SQL server 2005:
How to view or open tables under object explorer details, when i double click an object under object explorer.
thats how the default settings used to be.
now when i double click any object or try to open query analyzer it is open in the same left side pane on top of Object explorer window.
i did something to my explorer and explorer details panes since then both are separated, they are not getting synchronized.
Thanks for your help.
Hello there... I had an intrusion into my DB and I'd like to analizethe log looking for the moment and the IP the modification was.Does anyone know about free software for this?Thank you.
View 2 Replies View RelatedWith Oracle, there is a comprehensive tool called SQL Navigator as well asTOAD. Does such a tool exist for SQL Server 2000?@drian.
View 2 Replies View RelatedI am using vs 2005 to connect to a remote database. I dont have remote access or any other type of access. I need to setup some constraints on the database, but the object explorer is missing. How can Iincorporate this tab into vs
View 1 Replies View RelatedHi,
I just installed 2005 Evaluation version (high spec laptop but running Windows XP Home edition).
Have opened SQL Server Management Studio then set up a dummy database with a table and a query then tried opening the Server Explorer.
I understand that Server Explorer should be on the 'View' tab with, say, Object Explorer but I can't see it.
Does the fact I am running this on XP Home edition have anything to do with it? Or do I need to run another SETUP.EXE or configure some options or is it something else?
When I installed SQL Server 2005 I got one error message saying:
quote:- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
Does Server Explorer need IIS to be running in order to work?
Help will be very appreciated.
Thanks in advance.
Hi,
Is there any way to change path for template explorer? Default path for SQL templates is ..Application DataMicrosoftMicrosoft SQL Server90ToolsShellTemplatesSql. I have scripts & would like to share with my teammates. Is there any way to set this path to a common folder so that whenever anybody connects with their login to our TS server, they should be able to see these scripts in template explorer.
Thanks in advance
Sandesh
Hello All;
I downloaded the VWD2005 recentrly, it was really agiant achievement , i appreciate the people who developed such an easy-to-learn web development package. I noticed the difference between VS2002 and VWD2005. I really liked it. (i am sorry if this speech isn't in its right place). Here i have an enquiry, I downloaded the the VWD2005, but i haven't seen the Object Explorer(SQLExpress), although it was included in the downloades?
Thanks alot
I am using MS SQL Server Managment Studio 2005 - I also use the old Enterprise Manager from time to time. My questions are about making SMS2005 more user friendly.
I) Is there a way to keep the list of server connections displayed in the object explorer after the application is closed and re-opened?
II) Is there a way to save the password in the "Connect Object Explorer" so I don't have to keep confirming the password to enable the connection?
In summary: In Enterprise Manager, the database engines are always displayed in the Object Explorer and are automatically connected upon opening the manager. Is this functionality possible in SMS2005?
Im new to Sql Server CE and I am following the procedure in books online to create a new database. Through Sql Server Management Studio, I have version 9.00.2047, books online says to click connect through Object Explorer and then select Sql Server Compact Edition. I dont see this option. I see Sql Server Mobile. Is it the same thing or am I missing something?
Thanks,
Jesse
Is there a way to stop SQL Server Management Studio (2005) from showing "dbo." on everything in the object explorer.
I'd love to turn that off on a database I'm working on as, for example, if you have to find tblMember, you'd have to type d-b-o-.-t-b-l-m before you can actually start jumping to the table you're interested in - whereas in Enterprise Manager (2000) you'd only have to type t-b-l-m if you get my meaning.
I am trying to establish a connection to a SQL server using server explorer. I have tried both the DNS name and the IP address and get this message: "Could not reconnect to "sqlserver". Make sure the machine name and path are valid.When I go to Enterprise Manager and enter the IP address, I can successfully establish a connection.What gives? Is this a VS problem?
View 4 Replies View RelatedDBxtra Data explorer
DBxtra version 1 is ready.
You can connect to unlimited MS Access, MS SQL Server, Paradox, PDF and Excel tables and queries.
Get the sense out of your data!1
1. Connect to your data
2. Explore your data
3. Design and deploy your reports
4. Export your data
5. Send your data by E-mail
6. Schedule reports and alerts
Try the free Download!
http://www.dbxtra.com
From Windows Explorer, the modified date of the database file is not updated. Why?
I assumed the modified date of the .MDF/.LDF files will be updated when transaction is made to database. Am I correct?
Dear All,
Can I add more than one server in ServerExplorer bar.I wll use Client Server utility to add create a alias of a same server and add more than one server in SQL 2000. How can do this in SQL 2005
Thanks in Advance
Dana
Opinions?I've installed all three to try'em out and they all seem to be workingso far, more or less.Log Explorer has given me a couple of errors but I started over andcontinued OK.ApexSQL Log squawked about "redo for delete cannot be generated fortables lacking clustered index". Huh? What the...? We have lots oftables without a clustered index.I read some reports in Red-Gate's technical support forum about theirproduct actually bringing down SQL Server. That did not inspireconfidence.All three install some server-side components like extended storedproc's which I'm not crazy about and I think all three are server orinstance licensed (does anyone actually purchase more than one licensewhen it seems like you can easily move any tran log to be analyzed tothe server the product is installed on?). I don't think I'd want toinstall any of them on a Production server, at least one that I'mresponsible for!Thanks,Martin
View 1 Replies View RelatedHello
We do not want the end users to know of the subscription capability. How do we hide 'New Subscription' link for a report.
Thanks
Hi,
I have a couple of MS SQL 2005 Mobile edition databases that I was using previously.
I am now not able to open them, I have not used them for about 3 weeks and do not recall doing anything 3 weeks ago to cause them to fail (Except maybe SQL Server 2005 install, not CE/Mobile).
There is no option for adding a connection to SQL Mobile 5 DB (or CE2.0 for that matter, which is also installed) when adding new data connection in VS.NET Server Explorer.
The databases seem to work fine when on the device, my probelm is accessing the database file .sdf from VS.NET.
I have tried uninstalling and reinstalling SQL Server Mobile 2005 several times with no luck.
I am developing on XP Prof with VS.net 2005 for Pocket PC Phone 2003 and 2005
If I click on the already existing connection I get message "The Provider was not found"
If I click on the file directly from VS.net get a message
"There is no editor available for 'C:lahb;ah.sdf' Make sure the application for the file type (.sdf) is installed"
I have been using these databases for some time and desperately need them back.
ANY assistance or comment would be appreciated.
Rod
Help! On my desktop some security warning came up and my friend clicked "ok" when it said "block". Apparently it was warning her that internet explorer was trying to contact the internet. So...now internet explorer cannot display anything and it is the only browser I have on my computer. I am so frustrated I can't figure out what on earth I can change to fix this. Please...someone help me figure out why I can't contact the internet? My internet connection is fine, and the troubleshooting feature in explorer keeps telling me so.
Thanks!
I am a Visual Studio .net developer and understand Solutions and Projects in VS.net. Nevertheless, it appears that the paradigm of using Solutions Explorer in SQL Server is not exactly the same. That is, in Visual Studio you can't get anything done without creating a solution first. In SQL Server, it is entirely possible to get a lot done without a solution and the ability to create and make use of a solution seems almost an after thought or an add-on.
I am particularly interested in using a solution in SQL Server to allow me to make use of SourceSafe. In the past, we jumped through all kinds of hoops to keep a running trail of changes we had made to (for example) stored procedures. It appears now that this can be managed more efficiently with the use of a Solution and SourceSafe and saving scripts or .sql files. I guess it is not possible to save a pristine copy of a stored procedure directly in SourceSafe, but you can save the code that makes up the stored procedure as a .SQL file which I suppose is about as good.
Anyway, what I would like to know is whether there is a good white paper (or chapter in a book) on the philosophy behind Solutions and projects in SQL Server and how MS intends us to use them; perhaps something other than the cold facts from the documentation. I would appreciate something more that gives me the big picture on just how MS sees them being used in SQL Server so I can get the most out of them. I have the feeling that if I "get the vision", they are meant to be an integral part of SQL Server now and in the future.
Woody
Hello,I'm having the following dilemma: I'm trying to connect to a database on a SQL Server, somewhere else in the country. - With Server Explorer in VS.Net it is no problem at all. New dataconnection: i fill in the ip-adress, user and pass, and the database-name i want to connect to, and voila, it's done. I can add, edit, delete everything.- With enterprise manager: With enterprise manager i can make a connection with the server, but after that the database isn't visible. And as far as i know i can't connect to a certain database. Another option i tried is to create a linked server on my local server: that does work, only now i can't add/edit/delete..I really want to work with enterprise manager, but is there any way to connect to one db only, and still be able to add/edit/delete ?? I can't find the solution..Please help..Much regards..J.JansmaThe netherlands
View 1 Replies View RelatedCan you give me a free version of "Log Explorer"
View 2 Replies View RelatedI recently installed VISUAL STUDIO .NET 2003 and SQL SERVER 2000 personal edition on my XP system.
I also applied service pack 3a to it. I use windows integrated security, and server runs from it's system account (SA).
The problem is that I cannot create tables, views, procedures or databases from SERVER EXPLORER. I can do it through Enterprise Manager. When I install destop engine instead of sql server it's OK, but when it's SQL server personal edition, then it's a problem. I tried giving my account, and my account group (builtin/administrators) all rights and privilegies I could think of, but it still doesn't work.
I did not have this problem vith previous version of Visual Studio .net.
I think it's something about security and permissions.
Any suggestions ?
Thx in advance.........
Greetings All,
I installed SQL 2000 with SP4 on a 2003 Server. I added a NT Group to the Server and created 2 users exactly the same in the SQL Server Enterprise Manager.
My issuse is with the other user I created. When I go to a database in the Server Enterprise Manager and right click on tables, and select New Table with my user, the New Table window pops up with no problem. When the other user follows the exact same steps, Internet Explorer opens up and says page not found.
Is this an SQL Issue or maybe an IIS issue?
Thanks in advance.
A view I created won't show up in "views' in Object Explorer, but will only show up when I script for it (Select * from blah). It also won't go into the ODBC. why?
View 8 Replies View Relatedinstallation of their softwares? If there has NEVER been a backup ofthe Database (.mdf), Recovery Model Set to Full, and there has neverbeen a backup of the Log (.ldf) files?Using the trial software for both, this was unclear.Thank you for your time,bd
View 2 Replies View RelatedI have installed default instance of SQLServer 2005 DE on Windows Server 2003 host. I also installed a named instance of MSDE rel A. I can connect to the MSDE instance from Management Studio but it does not appear in the list of servers when I try to add the connection in VS2005 server explorer. What am I doing wrong?
- Dick
Here's one thing that I'd like to see come out in some version of the SQL Server Management Studio...
The ability to create folders under the database node so that databases can be grouped on one server.
We have over 100 databases on our development server and these are created by a range of consultants and developers and even support staff as needed.
Being able to group the databases by product, etc would be a nice touch since we have client databases that don't fit naming conventions etc.
Multiple instances are another way around this but are expensive and resource hungry - we develop and support models, not use them for transactions too much.
Yes there are 'better' ways such as setting security correctly but we are too busy working and not maintaining.
Folders or database groups would be a nice touch.
Cheers