| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
FastNStuff
   |
Posted - 2008.04.23 19:06:00 -
[1]
I am having difficulty running the MSSQL scripts against a MSSQL 2005 database. I was having problems with the comit line at the end and edited that out, after that I was having problems with he true's and false's I have changed them to 1 or 0. I am now having issues running the larger scripts as they seem to cause out of memory issues in management studio, and in osql they never seem to execute.
If you have sucsessfully managed to run these could you please let me know what process you used. |
FastNStuff
|
Posted - 2008.04.23 19:06:00 -
[2]
I am having difficulty running the MSSQL scripts against a MSSQL 2005 database. I was having problems with the comit line at the end and edited that out, after that I was having problems with he true's and false's I have changed them to 1 or 0. I am now having issues running the larger scripts as they seem to cause out of memory issues in management studio, and in osql they never seem to execute.
If you have sucsessfully managed to run these could you please let me know what process you used. |
Ki Anna
Ki Tech Industries
|
Posted - 2008.04.23 21:14:00 -
[3]
 Originally by: FastNStuff
If you have sucsessfully managed to run these could you please let me know what process you used.
From what I remember you are just about there: you just need to break up the larger files in to seperate pieces and execute them in order.
|
Oephre
|
Posted - 2008.04.24 12:27:00 -
[4]
I encoutered the same issues.
I did exactly the same with the false and true errors.
The comit error is not a real issue and it doesn't affect the bulk insert.
I 've got a workaround for the large file issue.
First open the file with ultraedit 32. (it is able to open such large file)
Then insert a new line with a GO statement before each INSERT statement.
exemple :
Replace all (without double quote) :
"
INSERT "
by
"
GO
INSERT"
Then use osql.
Note : for several file it took more than 1h30
Regards
|
Oephre
|
Posted - 2008.04.24 14:29:00 -
[5]
Edited by: Oephre on 24/04/2008 14:29:19
I think you will have an other issue with an other named type in the file dbo_dgmTypeAttributes.sql.
There is a type named UNKNOWN.
It is not recognized by MSSQL express. Just change the type to int and it should work
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |