Tag Info

Hot answers tagged

10

Yes, you're good to go. .NET framework versions are designed to install side-by-side. The other versions of the framework will happily continue on with their lives. One thing I will add is that sometimes newer versions of the framework will patch older versions if necessary.


9

Sounds like a timeout setting. So your SSMS thinks it takes too long and cancels the connection for you. The SQL server roles back. But there is help. You are not the first person to encounter this. See here. For everybody who doesn't want to click the link. Here is the price winning answer: After hitting the same error, I stumbled upon the corrent ...


8

This sounds like the same issue you're running into... The problem is that for a database that is offline or has been auto-closed, collation comes back as NULL, and SSMS assumes it's because you don't have permission. The fix is to go to Object Explorer Details, right-click the column header list, uncheck Collation, and refresh the Databases node. You ...


7

We have a Customer who has the unfortunate need to use this program. Sage purposefully makes it difficult to get to your data because they see that as a "revenue opportunity". (I guess they want to have all of the "lock-in" power of a proprietary file format combined with all of the convenience and performance of using SQL Server 2005...) Read your license ...


6

How timely - I just wrote a log blog post about exactly this issue yesterday - check it out at Importance of data file size management. Summary: size the data files initially to account for current size plus at least a year's growth, if possible turn on instant file initialization if you can (note: this only affects data files, log files always have to be ...


6

I don't think there is a better option than scripting your job. You can modify the script as required and reapply it to any number of SQL instances (always backup your system databases before apply scripts).


5

OK, so this is what I did (I'd like to edit the accepted answer because I based this on his idea, but I don't have enough points...) I set SSMS to start with "an empty environment", so it doesn't prompt me for a login (Tools-> Options->Environment->General). I opened Object Explorer and docked it to the left I opened Registered Servers and made it a ...


5

I don't think there's a good answer to your question, other than the fact that automatic script generating tools sometimes have to sacrifice efficiency to make sure they don't cause issues in strange corner cases. No inside information here, but perhaps they're accounting for something like the following scenario: The CEO went to an inspirational seminar, ...


4

Here you will find information on how to start the SQL Server Management Studio (SSMS) from a shortcut or from the command line. The following will open the SSMS by using Windows Authentication and will bypass the splash screen. The query editor will be set to the SMS_XXX database: SqlWb -E -S SQLServerName -d SMS_XXX –NoSplash Note: Change SQLServerName ...


4

or you can use the actreader.exe utillity that is included in the premium versions of act, to create a read only user for the act! database (I would advise against writing into act!s' databases anyway...) simply start it, enter a password, and then connect using the username ACTREADER and the password you have chosen. done.


4

Speaking from the development side, I can say that the admin should be able to lock everyone down to their own database (and probably master as well, for metadata). From the MSDN, the list of SQL Server securables includes databases and the permissions include being able to even see the database. Here is a link to the MSDN Security considerations for ...


4

No it does not - the verbiage in Books online appears misleading


4

There is no ways to specify bunch of transaction log backups (oк folder) to restore in SQL Server Management studio. But you can find all information about SQL Server backup operations in database MSDB (table backupset and related). Here is script to generate SQL Server commands for restore database from backup and applying all transaction logs backups ...


4

See Options > Query Results > SQL Server > Results to Text Check "include column headers". My text results are being enclosed in doublequotes so that should take care of the comma issue. Take a look at the "Results to grid" tab as well - I see a "Quote strings containing list separators when saving .csv results" If not through SSMS then you can also use ...


4

Just do the restore again, checking the REPLACE option in the second tab of the restore screen. When the restore the canceled the old database was gone and the new database was only partially restored. If you refresh the object explorer it should be removed from the list as it isn't there. It might show in a restoring state, I'm not sure how the engine ...


4

You need to connect to .\SQLEXPRESS or (local)\SQLEXPRESS


4

This might be a very simplistic answer, but this happened to me because a dialog it was attempting to present was off of the desktop and/or hidden behind something else. When it beeps like that, can you do the whole "Alt-Space m" and move something into focus?


3

This is a bug with SQL Management Studio. Microsoft seem to be aware of it, but have not fixed it as yet, and many users are experiencing it. Some users have reported success with always running the app as an administrator on Vista or Windows 7. You can run Managment studio from the command line, and supply your password in this. By creating a shortut to ...


3

I tried adding additional info to the answer by sphilp but that edit got rejected because some people seem to think it's incorrect. I can assure you: it is not. What I wanted to add: The Registered Servers functionality in SSMS can be used to connect to several servers in just a couple of clicks. If you group the servers together by creating a New Server ...


3

When you drop the database the UI is going to also try and delete the backup and restore history for the database from the MSDB database. Dry using the DROP DATABASE statement from a query window, then clean up the database backup history manually.


3

Yes. You can increase the mdf initial size and SQL Server will grow the file to that size. It's quite safe to do this on a live database, though choose a quiet time! You should find the size increase is very quick. I just grew a test database from 128MB to 4GB and it took 2 seconds. An initial size of 4GB seems reasonable given the current size of the ...


3

I'm assuming you've remembered to include the instancename (server\SQLEXPRESS)? Try to create an ODBC against the same server. If you get the same error; create another ODBC, but use regular "SQL Server" driver, and on the "Client Configuration" settings choose "Named Pipes". Also, SQLChickens tip about making sure the SQL Browser is started on the server ...


3

No, you should be good. There are a couple of things you might not be able to do (such as playing with DTS) but by and large you're good. I did the same thing until we upgraded our servers to 2005. Now am doing the same thing using SSMS 2008 with SQL 2005 servers.


3

Make sure the Express instance is configured to accept remote connections, check here for details; the standard SSMS can connect to Express instances without a problem.


3

This error typically occurs when you exceed the length of the data type for the column. Are you inserting more than 150 characters into the column?


3

Management Studio gets the list of databases from sys.databases. The default permissions on sys.databases is for each login to see only it's own database: If the caller of sys.databases is not the owner of the database and the database is not master or tempdb, the minimum permissions required to see the corresponding row are ALTER ANY DATABASE ...


3

1433 and 1434. Due to how the slammer worm operated, you'll find that a lot of ISPs out there filter these ports. http://support.microsoft.com/kb/287932 http://support.microsoft.com/kb/968872


3

First, in management studio, check management, sql server logs\current - you want to search for a message saying 'Server is listening on ['any' 1433].' If not, go to start, all programs, SQL server 2008, configuration tools, sql server configuration manager. Select 'sql server network configuration\protocols for MSSQLServer\SQLExpress'. Ensure TCP/IP is ...



Only top voted, non community-wiki answers of a minimum length are eligible