I've been encountering a seeming deadlock with one of my tables and the only place I can trace it back to is a stored procedure that uses sp_xml_preparedocument on a list of data. The data inserted, btw, consists of a 100k+ records on average. Is it possible that it is causing the deadlock? What other pitfalls does using sp_xml_preparedo...
Hi, I have several developers which connect to production and test servers where we have DBs with similar names and structures. In SSMS there are info related to the connection, but sometimes are not properly displayed and/or hidden. I know that it is possible to customize the status bar of each connection in SSMS, but how do you ensu...
The snapshot says is it all - I used to be able to attach a database, but after i detached today then tried to attach, i kept getting this error: http://img197.imageshack.us/img197/2574/attacht.jpg ...
I would like to add custom folders to a Sql Server Management Studio 2008 solution. Currently only three folders are included: Connections, Queries, and Miscellaneous with no easy way to add or customize this folder layout. ...
Using SQL Server Management Studio 2008, why can't I see unique index ( not primary key ) when I generate Create Table SQL code? It includes only primary key constraint. Is it by design ? There is a possibility to get SQL code for index creation via right mouse click on an index and "Script index as", but it is another step. ...
I recently downloaded all the software from WebsiteSpark, visual studio 2010, sql server 2008 etc. no problems with anything, apart from sql server. It installed correctly, no issues or errors with this. But SQL Server Management Studio was not installed following the installation. Wonderning if I missed something or if anyone had a si...
I am needing to edit several text fields in a SQL Server database. What would be the best way of doing this? The only solution I have so far is writing an update statement(along with escaping quotes and such) to update it.. This just seems really cumbersome though. Is there a better way? ...
I need to export database from one server and import it into another server. How do I export the entire database to a file, or two files mdf, ldf (either option is fine) How do I import it into a new server using ssms? In the instructinos frmo ponies, it says: In the To a point in time text box, either retain the default (Most ...
I am trying to restore a DB I am getting this prompt, however I am unable to point to a database to restore from Has anyone else experienced this horrific problem? ...
I've always relied heavily on Windows shortcuts to SSMS that include command-line switches allowing me to quickly open up a specific database on a specific server. For example Ssms.exe -S 123.123.123.123 -U sa -P goodpassword -d DbName or Ssms.exe -S . -E -d DbName These suddenly stopped working. I get this error from SSMS: Faile...
I knew that we have something like this in regular expression syntax world. *The syntax is {min,max}, where min is a positive integer number indicating the minimum number of matches, and max is an integer equal to or greater than min indicating the maximum number of matches. So {0,} is the same as , and {1,} is the same as + http://ww...
Hi every one Nice job! Using of Sql Express Management Studio 2008 GUI(not with coding),how can I make a primary key auto-incremented? Let me explain,there is a table which has a column named "id" and the items of this column are set to be primary keys. I want to make this column auto-incremented,but how? Cheers ...
I need to know if the "Backup Database Task" in MS SQL Management Studio, maintenance plans, takes the free space into account or that it only backsup the data part. For e.g. if the db size is 100 MB where 60Mb is data and 40Mb is free space. Will take the backup of the whole db of size 100 or that it will take backup of the 60Mb data. ...
The problem is that I need to explain the different sizes of backups that are being made of a database in a plant. Sometimes the difference between the sizes is in negative, even though that there is no data being deleted from the system. Datum Backupfile-file Size KB Diff 6/1/10 backup201006010100.bak 3355914 ...
hello, i want to restore database from file(Tasks->Restore->Database. atrer i select from device and select file) via sql server management studio. After that i get this error: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'E:\Program Files\Microsoft SQL...
While most of the work for my .NET projects is done in Visual Studio, I prefer to work in SQL Server Management Studio [SSMS] (I'm currently using the 2005 version) when editing stored procedures and doing other DB-related tasks for a project. I used to just open a ton of query Windows, commit my alters, and move on, but I recently disc...
By default when you copy/paste data from a query window in SSMS it does not copy the column headings. How can I get these headers to be copied along with the data? ...
Need to duplicate a TABLE using Microsoft SQL Management Studio 2008 The TABLE needs to duplicate all table row (Primary Key) ID as well. Thanks. ...
I have a table in which one column (type ntext) has data that includes carriage return and linefeeds. (CHAR(13) and CHAR(10)). If I right click the table in SSMS 2008 and choose 'Select Top 1000 rows' and the display mode is set to "Result to Grid" it seems that control characters (like TAB and CRLF) are converted to spaces for display...
I have many users in one database. All these users are named using "domain\" as a prefix. I would like to rename these user names by dropping this domain name from the user name. How to do that? In SQL Server Management Studio GUI user name is grayed and cannot be changed? ...