I have been using the sql server management studio (express) and i would like to know what the difference is of creating a db in the studio or creating in VS 2005... it appears that one is attached and the other isn't?
What are the pros and cons of the 2 different ways?
Also when i write queries etc in sqlcmd.. i use GO to execute the command/s ...but in SQL Management studio is there any point to GO?? As you click the EXECUTE button on the toolbar to execute the script which i assume executes ALL of the script not just the current line
If anybody can confirm anything i would be really grateful..