Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rriordan
Starting Member
3 Posts |
 Posted - 2011-11-14 : 20:43:16
|
| Please tell me if this in not right forum.SQL Server 2008 R2 on Windows Server 2003 EE.Long-running ASP.Net code that dynamically creates SQL statement to CREATE TABLE. For ages, it created the tables NP. Does not now create the table, but, same code block, will DROP the same table if it exists. I can copy/paste the generated SQL statement out of ASP rendered in HTML and paste into SQL Server having logged in with the same account as is used in code. Will create the table no problem with the copy/paste. Will write to the table in code, once manually created via copy/paste. Will not create it...Anybody? Please? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-14 : 23:46:26
|
| do you have a error handler inside code where you drop the created tables. My guess is something is generating error in application causing it to call error handler block and DROP the created table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
johntech
Yak Posting Veteran
51 Posts |
Posted - 2011-11-28 : 10:09:00
|
| I thought that we need the source code to test by our self if possible, |
|
|
|
|
|
|
Cannot CREATE TABLE from ASP.NET code