I have a database that needs restoring to get a website up and running. I am not a ASP developer (am PHP) and therefore have never used SQL Server before.
I have just tried to import one of the tables from a .txt file using SQL Server Management Studio 8 and instead of the column names being inputed, it just has "column 0", "column 1" etc. I have noticed that I have a folder full of stored procedures, am I supposed to import these first? Im not 100% what these stored procedures are for or the best way for me to import all this data successfully as I have so many files it will take forever to import one by one. I dont mind doing it one by one if I have to but just want to ensure I do it all correctly first time!
View Complete Post