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 |
|
sirmilt
Starting Member
49 Posts |
 Posted - 2011-10-25 : 14:09:24
|
| I am using theSQL Server 2008R2 Express with theManagement Studio.In a previous, aborted attempt to setup and use an SQL database I created a number of queries. I can access these by menu File/Open. I now want to use the queries in a new database with a different name.The copy/paste method works. If I try to simply change the database name the Parse and Execute I get an error poiting at the quey name as ianvalid.Is there a better way to simply change the query to the new database and not get the error?Milt |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-25 : 17:49:06
|
| can you post the query and the error message that you got? |
 |
|
|
sirmilt
Starting Member
49 Posts |
Posted - 2011-10-25 : 18:38:27
|
| I have the problem solved. The ssms has a menu item File/Open/File with New Connection. After some experimenting (I could find no help files) I got it to allow me to open the file, make any chanes and save it to the new database..Thank you Cindyaz for answering my original(and premature) post.MiltMilt |
|
|
|
yadav
Starting Member
1 Post |
Posted - 2011-11-04 : 07:30:33
|
| how to solve this problem"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted."raju |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-12-06 : 05:12:53
|
quote:
Originally posted by yadav
how to solve this problem"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted."raju
Please open your own thread...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Copy A Query