|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2005 - Generate Script
Hi,
I attempt to create SQL Script for my database as follows: In "Microsoft SQL Server Management Studio Express" Object Explorer screen. "mydatabase"->Right Click -> Tasks -> Generate Scripts -> In the "Script Wizard" I don't see my database is Listing here. All other database comes except my database. Is it a Permission problem or anything else. Please help me. Hello,
It is because you do not have permissions on that database Thanks Hari Show quoteHide quote "Senthilmurugan" <senthilmuru***@angleritech.com> wrote in message news:1174039905.573102.7030@e65g2000hsc.googlegroups.com... > Hi, > > I attempt to create SQL Script for my database as follows: > > In "Microsoft SQL Server Management Studio Express" Object Explorer > screen. > > "mydatabase"->Right Click -> Tasks -> Generate Scripts -> > > In the "Script Wizard" I don't see my database is Listing here. All > other database comes except my database. > > Is it a Permission problem or anything else. > > Please help me. > Thanks for your response.
But I am "sa" user. Able to do any changes in Database level/Table level. I have all the rights, but It doesn't come to listing. Let me explain the scenario more... The Main Server (SQL Ser 2000) name is Serv38. Database dbRef. I am accessing the database from my SQL Server 2005 by using "sa" user. And tried to "Generate Script". But I could not see the particular DB. Other DB in the 2000 server listing well. Note: The dbRef is created by using "sa" user. What should I do? Show quoteHide quote On Mar 16, 6:24 pm, "Hari Prasad" <hari_prasa***@hotmail.com> wrote: > Hello, > > It is because you do not have permissions on that database > > Thanks > Hari > > "Senthilmurugan" <senthilmuru***@angleritech.com> wrote in message > > news:1174039905.573102.7030@e65g2000hsc.googlegroups.com... > > > Hi, > > > I attempt to create SQL Script for my database as follows: > > > In "Microsoft SQL Server Management Studio Express" Object Explorer > > screen. > > > "mydatabase"->Right Click -> Tasks -> Generate Scripts -> > > > In the "Script Wizard" I don't see my database is Listing here. All > > other database comes except my database. > > > Is it a Permission problem or anything else. > > > Please help me. Perhaps the database is in a too low compatibility level?
-- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Senthilmurugan" <senthilmuru***@angleritech.com> wrote in message news:1174039905.573102.7030@e65g2000hsc.googlegroups.com... > Hi, > > I attempt to create SQL Script for my database as follows: > > In "Microsoft SQL Server Management Studio Express" Object Explorer > screen. > > "mydatabase"->Right Click -> Tasks -> Generate Scripts -> > > In the "Script Wizard" I don't see my database is Listing here. All > other database comes except my database. > > Is it a Permission problem or anything else. > > Please help me. > You can try out this app:
http://www.elsasoft.org/tools.htm it will generate scripts for all objects for any 2000 or 2005 db using SMO. it's open source too. Ok. How can we resolve it
On Mar 16, 7:30 pm, "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote: Show quoteHide quote > Perhaps the database is in a too low compatibility level? > > -- > Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi > > "Senthilmurugan" <senthilmuru***@angleritech.com> wrote in message > > news:1174039905.573102.7030@e65g2000hsc.googlegroups.com... > > > Hi, > > > I attempt to create SQL Script for my database as follows: > > > In "Microsoft SQL Server Management Studio Express" Object Explorer > > screen. > > > "mydatabase"->Right Click -> Tasks -> Generate Scripts -> > > > In the "Script Wizard" I don't see my database is Listing here. All > > other database comes except my database. > > > Is it a Permission problem or anything else. > > > Please help me. If that is the case (check the compatibility level first), then you would up the compat level,
generate scripts and then down the compat level (if the compat level should be low, that is). -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Senthilmurugan" <senthilmuru***@angleritech.com> wrote in message news:1174105229.506665.247280@b75g2000hsg.googlegroups.com... > Ok. How can we resolve it > > On Mar 16, 7:30 pm, "Tibor Karaszi" > <tibor_please.no.email_kara***@hotmail.nomail.com> wrote: >> Perhaps the database is in a too low compatibility level? >> >> -- >> Tibor Karaszi, SQL Server >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi >> >> "Senthilmurugan" <senthilmuru***@angleritech.com> wrote in message >> >> news:1174039905.573102.7030@e65g2000hsc.googlegroups.com... >> >> > Hi, >> >> > I attempt to create SQL Script for my database as follows: >> >> > In "Microsoft SQL Server Management Studio Express" Object Explorer >> > screen. >> >> > "mydatabase"->Right Click -> Tasks -> Generate Scripts -> >> >> > In the "Script Wizard" I don't see my database is Listing here. All >> > other database comes except my database. >> >> > Is it a Permission problem or anything else. >> >> > Please help me. > > Hi,
Thanks a lot for everybody. I just changed the Compatability Level Up. And It works fine. I just want to know why the database was created with the "SQL Server 7.0" compatability, though I created the database in SQL Server 2000. Because I have five databases which were created in SQL Server 2k. All other databases comes in the SQL Server 2005 "Generate Script Wizard" except "dbRef". On Mar 17, 1:58 pm, "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote: Show quoteHide quote > If that is the case (check the compatibility level first), then you would up the compat level, > generate scripts and then down the compat level (if the compat level should be low, that is). > > -- > Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi > > "Senthilmurugan" <senthilmuru***@angleritech.com> wrote in message > > news:1174105229.506665.247280@b75g2000hsg.googlegroups.com... > > > Ok. How can we resolve it > > > On Mar 16, 7:30 pm, "Tibor Karaszi" > > <tibor_please.no.email_kara***@hotmail.nomail.com> wrote: > >> Perhaps the database is in a too low compatibility level? > > >> -- > >> Tibor Karaszi, SQL Server > >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/... > > >> "Senthilmurugan" <senthilmuru***@angleritech.com> wrote in message > > >>news:1174039905.573102.7030@e65g2000hsc.googlegroups.com... > > >> > Hi, > > >> > I attempt to create SQL Script for my database as follows: > > >> > In "Microsoft SQL Server Management Studio Express" Object Explorer > >> > screen. > > >> > "mydatabase"->Right Click -> Tasks -> Generate Scripts -> > > >> > In the "Script Wizard" I don't see my database is Listing here. All > >> > other database comes except my database. > > >> > Is it a Permission problem or anything else. > > >> > Please help me.  
Other interesting topics
Insert Duplicate row in Temp Table
Large database - unable to delete even 10 rows? Deferred Name Resolution gone wild. SQL Server Backup and Transactions How to avoid creating duplicate indexes on the same column SQL Server 2005 compact edition with VB Table size Restore Failure OS Related ? ISNULL not working SQLH2 |
|||||||||||||||||||||||
