My Sql database is in need of a little tuning up ;-)
Every time I try to run the tuning wizard I get this message.
I have tried tuning scripts profiles, many tables, one table, tuning SP's, everything and this is what I get every time about 3 seconds after the wizard starts.
"an error...
I have a web form inputing to a description table field using a SP
I need more data in the field so i went to the sp and changed from varchar(256) to varchar(500) for the field
I then went directly to the table and changed the same thing the same thing. varchar(256) to varchar(500)
I have...
I have upsized an access database using the upsizing wizard to my sql database.
I am now unable to create any stored procedures using adp.
although I can select the tables necessary, the table field boxes are empty and I can not proceed.
Help
PS: Please move slowly, I am a little out of my...
By no means am I SQL efficient!
But this should be easy ( shouldn't it?)
I created this query to update a new database structure from my old one with the query wizard in enterprise manager and modified it accordingly.
We are trying to change to a new ecommerce solution if we can get the data...
cannot open user default database. logon failed
This is what I get trying to logon using enterprise manager.
How do i get back into the SQL server?
I have tried everything( which isn't very much )
I accidentally shut down the main database to do some testing and obviously, something was setup...
cannot open user default database. logon failed
This is what I get trying to logon using enterprise manager.
How do i get back into the SQL server?
I have tried everything( which isn't very much )
I accidentally shut down the main database to do some testing and obviously, something was setup...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.