sql server - Sql script generated by management studio gives errors when run as query -


I have a large database I found the script of my database schema using SQL Server Management Studio.

There are 176,000 lines in the script when I copied the script into a new query window and executed it.

1 'GO' = & gt; The wrong syntax error error is repeated next to 90% error lines. The scalar variable "@abc" must be declared. 3. The variable name 'sql' has already been declared, the variable name must be unique within a query batch or stored procedure. 4. Foreign Key 'FK_FAVOURITES_DETAIL_FAVOURITES' Reference Invalid Table 'dbo.FAVORITES' 5. Object "dbo.LIC_INFO" can not be found because it does not exist or you do not have permission

According to the database, there could be no process of syntax error in invalid objects / relations or its definition

whether the management studio is limited in its ability to generate special scripts long Is correct or can run against a specific length of query batch or for specific script (such as), against dynamic SQL processes or user-defined datatypes

or in the process I do Can there be something wrong? SQL Server Management Studio (SSMS) is not good at creating scripts, in particular it does not work too much. Good work to determine the order in which objects should be prepared for preparing endencies. As soon as you have an error, the chance of next errors increases dramatically.

Regarding your expectation, "There may not be any syntax error in the database / invalidity or its definition in the database" This is not correct. Many objects present in the database may be present.

Depending on how you can create your script, you can review the Tools menu, Options, SQL Server Object Explorer, Scripting and Settings there.

Rhys


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more