>>>Hi
>>>
>>>any general tips on using management studio.
>>>
>>>I'm doing some work in SQL2005 and I am finding I end up with a lot of windows open all similarly named SQLQuery1 ,2 etc
>>>
>>>makes it quite hard to remember whats in each one.
>>>
>>>Is there an easy way to name them ?
>>>
>>>Thanks
>>>
>>>Nick
>>
>>The pages shows the name of the query, so if you save the query with some name, this name will appear in page caption.
>
>Thanks Boris
>
>No way just to give the window a name then.
>
>I guess I'll just have to get into the habit of saving the queries. Though when I'm playing around with things its going to create a lot of files.
I save files in folders by project, naming each file such that it is easy (relatively) to know what is inside.
E.g. \ProjectA\[table_name]_[column_name]_[purpose].
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham