Access ADP integration?

I'm sorry but Management Studio is slow, cumbersome and difficult to
quickly make changes while designing a new system. It is directly and
very visibly impacting my teams production. The same can be said for
developing databases though the Visual Studio IDE.
We are at our highest production when using Access ADP projects to
modify the database. It's intuitive, familiar and very responsive. Do
we have to wait until Office 12 before we have Access ADP / SQL 2005
integration?
Please PLEASE don't say this is not going to happen. We are highly
dependent on this and have alot of infrasture in place based on this
setup.
CI would like to expand on my dislike of Management Studio. There is no
copy / paste for tables or views. There is in Access. There is no
Search / Replace in the SQL window. You have to copy all to a text
editor to search and replace.
But I do really like the View Dependancies option though.
C|||Hi
Well, do you have SQL Server 2005 installled as a named instance? I you do
, so a named instance is consumed memory which amy hurt a performance. Also
check out whether you have AutoClose of the database option checked.
In order to make 'copy /paste' as you like in Access you will have to learn
some T-SQL commands as
SELECT * INTO NewTable FROM OldTable
In addition you have a great option in my opinon as Script Table As to make
changes and DML operations

> Search / Replace in the SQL window. You have to copy all to a text
> editor to search and replace.
Have you tried CTRL-F option in the Query Builder?
"The Cornjerker" <addoty@.gmail.com> wrote in message
news:1140311969.961191.275270@.g47g2000cwa.googlegroups.com...
>I would like to expand on my dislike of Management Studio. There is no
> copy / paste for tables or views. There is in Access. There is no
> Search / Replace in the SQL window. You have to copy all to a text
> editor to search and replace.
> But I do really like the View Dependancies option though.
> C
>|||Uri,
Thanks for helping. I'm trying hard to work with Management Studio. I
know I can do anything with SQL commands, but I think the point of
having a tool like Management Studio is to make things visual and
easier. It just doesn't seem very intuitive for rapid development.
CTRL-F is grayed out for me. I can't seem to find the AutoClose option
plus I'm not for sure what it does.
I guess my frustration comes from the fact that I'm constantly being
forced to change my development process. I'm spending more and more my
time and my development team's time learning new processes to do
basically the same thing. VB6 to VB.NET, ASP to ASP.NET, FrontPage to
Visual Studio.NET, now Access ADP to Management Studio. The products
we produce are basically the same, they just take longer to develop and
seem more difficult to maintain. I think there is something to be said
about incrementally improving technologies instead of these huge
revolutionary leaps and then abandoning previous technologies.
Sorry for the rant,
C

About SQL Server Management Studio Express CTP

All,

I downloaded SQL Server Management Studio Express CTP (v9.00.1399) dated 11/11/05. May I know if this is the latest stable build of the application to be used for SQL Server 2005 Express (final release version)?

Why it is CTP?
Thanks,
WilliamThe November 11 CTP is the latest stable build.

Management Studio Express is a new product that hasn't had all the testing that SQL Server 2005 Management Studio has had and isn't quite ready to be released. The CTP lets a broad range of users try the product out while we can still easily fix any problems that are found.

Also, the feature set for Management Studio Express is not yet final, so we want to use the CTP to gather feedback on how well the current set of features work for people. Depending on what feedback we get, we can still make feature set changes in a pre-release product.

About SQL SERVER 2005(Stored Procedure) & Dot Net 1.1

I create a new stored procedure in SQL SERVER 2005 .It it is stored in " C:\Documents and Settings\mmm\My Documents\SQL Server Management Studio Express\Projects" as (some_name).sql .it takes this links by default . Then I exeecute it with this command

"exec InsertValueIntoTable ;" BUT when i want to execute with clicking the execute button in the then gives an error "Could not find stored procedure 'InsertValueIntoTable'."

Malay Roy wrote:

I create a new stored procedure in SQL SERVER 2005 .It it is stored in " C:\Documents and Settings\mmm\My Documents\SQL Server Management Studio Express\Projects" as (some_name).sql .it takes this links by default . Then I exeecute it with this command

What do you mean by this? The *.sql file is just the script, you must put all the contents in the sql file to SQL_SERVE before you can execute the SP.

|||

Hi,

Please post your question in the following forum.
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

Thank you,
Bhanu.

|||thread moved to the appropriate forum.

About SQL Server 2005 Management Studio

i would like to ask if there is a way to FILTER THE IPADDRESSES of users who wants to login the SQL Server Management Studio. right now, we are using Enterprise Edition of SQL Server 2005.

i just want to limit the users who can log in at Management Studio, the users know the password of SA, and i can't change the password coz we have deployed the programs with odbc connection using SA. so i thought of filtering the ipaddress of computers i want to grant access to SQL Server Management Studio, if its possible.

need a help.

thanks

I'm not sure you are able to do this unless you can write some sort of database/server scoped trigger that checks which application/IP the request is coming from (does anyone know if thats possible?).

However, remember that SSMS is just a GUI intended to make administration easier and restricted access to this tool doesn't really plug the serious security risk you have in using the sa password. Malicious users would still be able to use other methods of accessing the database eg osql.

Obviously, you should seriously consider stopping your application using the sa account for database access. At the very least, its good practice to create another user with sysadmin priveleges (eg saUser) and use this instead though operating a policy of least privelege is most best practice.

HTH|||

thank you richbrownesq.

about sql management studio?

i have a problem regarding sql management studio....

1. I can't create new server, i'd follow the tutorial in video. but it doesnt work. or may be i must install the IIS?

2. i create a new database named sample (sql management studio) and add some tables and sort of data. how can i deploy this database so that i can bind/connect to my program.

2 question for now.

thx in advance

Hi,

from question 2 I assume that you already installed SQL Server, or do you want to install it on another box ? If yes, which error do you get ?

2. Where do you want to deploy the database to ? Another system ? Is there SQL Server already installed ? Do you want to run a script to built up your database, or do you want to ship copy of the database files within your application to attach to ? Do you want to use a server controlled database / instance or a user instance (Assuming that you use SQL Server express)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

i used sql server express... i dont know how to deploy my database...in sql managemt studio, right click add new database, add tables. now i want to deploy this dbase so that i can use this to vbee. how can i deploy this stuff? i want to deploy this in my documents. how can i do that?

how to make a server controlled dbase?