Once again, I would like to thank everyone for there help and patience. I was able to avoid the problems by using the SQL functions within enterprise manager to insert...

To go with the above error, I now have an entirely new problem! yay!

I was inserting data and was stopping every now and then to c if it worked. My...

While working in Enterprise Manager I try to update some fields, and then when i go to close the table i get the message:

'Transaction cannot start while in firehose mode'

What...

Thanks, I understand that there a no positions in my tables in my database, but when viewing the database in Enterprise manager (when I go 'Open Table, Return all rows'),...

Sorry all, please ignore.

After hours I finally figured out that it was the license value that had the problem. I was passing it in a querystring and I dont...

This might not be the best place to post this because it is getting too asp instead of SQL but its worth a try 🙂

When accessing data from a data...

Frank,

So it is possible its just hard to do and time consuming? An SQL insert statement couldnt just chuck it where i want it?

I guess i code write code to...

Ok, back to SQL Server. Say I have a table populated with around 50 items. The primary key is their ID (eg 1-50). If I get a new item that...

Thanks for the help, I think importing data from excel is going to be a no-go. I think the spreadsheets have too many different headings and what not, and when...

Once again thank you Frank.

Do you think it would be possible to get the users to trasport the data from an excel spreadsheet to the database every time a new...

I feel this is a really good beginners guide: http://www.functionx.com/sqlserver

At one point in the guide it says "Another technique used to perform data entry consists of importing already...

Frank,

thanks for all the help. I think my mail is configured but I will search instead.

BOL = Books Online?

I will post any good URLs I find in here.

Thanks Frank, I think I need to have a good read of the online books before I go any further. One question though, the example you just showed me, where...

Thanks for your replies Frank. I was able to move the tables from one database to another.

I added 2 rows to my initial table1, test and test2. I was not...

A further question. Can u copy a table from one database to another using Enterprise Manager?