Wednesday, March 27, 2013

[SQL Server 2008 issues] SQL Query Confusion

[SQL Server 2008 issues] SQL Query Confusion

SQL Query Confusion

Posted: 26 Mar 2013 10:41 AM PDT

Hi,I have 2 tablesTable Member with columnsA B C Dapple bread carrot ChocolateMango Begal Onion CandyTable Util ColumnsA B C D X yapple bread carrot Chocolate coffee chedderMango Begal Onion Candy tea ProvolonKiwi biscuit garlic peanut greentea mozrellaNow I want to know weather table UTIL have any data not in table MEMBER ONLY on columns A,B,C,DI wrote following query ---dd not give me resultSelect * from Util ULeft Outer join on Member mon U.A=m.AAND U.B=m.BAND U.C=m.CAND U.D=m.Dwherem.A is NULL ORm.B is NULL ORm.C is NULL ORm.D is NULLNext query I wrote was like this--and this gives me result the last row in the table Util.Select * from Util Uwhere U.A not in (Select A from Member)or U.B not in (Select B from Member)or U.C not in (Select C from Member)OR U.D not n (Select D from Member)I want to know what is wrong in my 1st query, why left outer join is not working..Kindly please help.Thanks

KILLED/ROLLBACK STATE - SERVICE RESTART

Posted: 20 Mar 2013 06:57 PM PDT

Hi all,Is there any fix other than sql service restaRT when there is transaction stuck in killed/rollback state (after killing a blocked transaction) in sysprocesses?i had this situation and once i unsucessfully tried moving the database to offline mode(courtesy:google) to end the transaction.any help will be appreciated.

reorganize index

Posted: 18 Mar 2013 05:16 PM PDT

Hi Guys,I'm going to reorganize indexes with > 10%.Is there a need to update statistics after the re-org?Understand that if it's a rebuild, SQL server will automatically update the stats.My question is, does re-org need a update statistics? Is the old statistics still accurate after re-org?In Micrsoft Note:Operations such as rebuilding, defragmenting, or reorganizing an index do not change the distribution of data. Therefore, you do not need to update statistics after performing ALTER INDEX REBUILD, DBCC REINDEX, DBCC INDEXDEFRAG, or ALTER INDEX REORGANIZE operations. The query optimizer updates statistics when you rebuild an index on a table or view with ALTER INDEX REBUILD or DBCC DBREINDEX, however; this statistics update is a byproduct of re-creating the index. The query optimizer does not update statistics after DBCC INDEXDEFRAG or ALTER INDEX REORGANIZE operations. thanks

Difference between?

Posted: 26 Mar 2013 03:34 AM PDT

1) Declare @i int=0 select @i=id+1 from user; select @i /* here id is an identity column*/2) select @i=max(id)+1 from user; select @i;In the above queries gives the same output but is there any difference in terms of performance?

data design considerations

Posted: 26 Mar 2013 01:52 AM PDT

Scenario is that I want to have a primary key to identify a new entry in a main table. Call it "record_id." This will also be a foreign key in many other tables.The most important of those tables will hold a complete history of all changes to the main record. Each record in the history table will have both the record_id as well as a unique history_id.So I'm envisioning a main table that generates the record_id, and a history table which will FK to the main table as well as generate its own unique internal PK as history_id.The thing I'm struggling with is that the "main" table seems like it only has one purpose, which is to generate the PK. All the other data would be stored in the history table because each piece of it might potentially change (this is storing data that is altered by users in something like a workflow application). So the main table is reduced to functioning the way a sequence does in Oracle. It holds no data and there's no real reason even to use it beyond its ability to create the record_id.This isn't really a problem, but it seems odd. Every time I think of other fields that might belong in the main table, such as create-date and such, that argument disappears, because that date will be in the first record of the history table as well as in another audit table.I get the feeling that something obvious is slipping right past my thought process. Composite key may fit here somehow.Though maybe I should just relax and allow this "main" table to hold only the record_id and recognize that its usefulness is limited to that - an SQL Server version of an Oracle sequence.Your thoughts are welcome!

Data warehouse File groups and Table partition designing

Posted: 26 Mar 2013 09:54 AM PDT

Hi Experts,Project: Datawarehouse migration from Oracle to SQL Server 2012In Oracle Number of Schemas in Oracle - 6Tables: Each Schema has 3 partitioned tables and three unpartitioned tablesEvery schema has its own Table space, all non partitioned tables are in its own Table SpaceEvery partitioned table(three tables in each schema) is partitioned on date partition column. i.each year a new partition is added to that table(PART_2011, PART_2012, PART_2013 ...etc) In SQL Server 2012All schemas from oracle are migrated to SQL Server in to one database with seperate schema nameNumber of Schemas:6Tables: Each Schema has 3 partitioned tables and three unpartitioned tablesMy Question: Can you please suggest me how to plan the file groups and partitions in SQL Server like FILEGROUPS for each schema or FILEGROUPS for every yearLet me know if you need more info

Query - Please Help!

Posted: 26 Mar 2013 03:21 AM PDT

Someone please tell me what I'm doing wrong..... :( All I want to do, is get a list of databases which don't have extended properties. Query below:exec ('create table #t_nodb(dbname varchar(120)) insert into #t_nodb (dbname) exec sp_MSforeachdb ''if ''?'' in (''tempDB'') returnuse ? select ''?'' where ''?'' not in (select ''?'' from sys.extended_properties)''select * from #t_nodbdrop table #t_nodb') Thanks!

Deadlock Analysis Results from trace flag 1222

Posted: 26 Mar 2013 12:43 AM PDT

Hi.I have just captured deadlock info into the error log using trace flag 1222. Can anybody help me disecting the results as it looks like a mine field of info !!!!:-)

FULLSCAN vs. REBUILD

Posted: 26 Mar 2013 06:53 AM PDT

Hi All,Except that REBUILD eliminates the fragmentation at indexes, is there any other advantage over update of the statistics for the indexes with FULLSCAN option? One disadvantage is the more consuming time for REBUILD, but not much more than UPDATE with FULLSCAN.If FULLSCAN makes the best update for the stats, then why should I run an everyday REBUILD for all indexes when I know that only few of them get fragmented? Then I will need to do the REBUILD only for them.RegardsIgorMi

Cant create a database...Not sure why

Posted: 26 Mar 2013 06:54 AM PDT

Hey guys,Ran into a problem I have never seen before...I am logged on to a SQL Server box as sa with sa rights...I go to create a database, give it a name, the drives are already populated, and when I click OK, I get the following errorCREATE FILE encountered an operating system error 5(Access denied) while attempting to open or create the file blah blah blah...What is this error? I even went to the drive where it will be created and created a txt file on that drive so:I am logged in as SA on SQL ServerI can create a file on the driveWhy is it not letting me create a database? Any suggestions?

Maintaining Compression

Posted: 26 Mar 2013 02:44 AM PDT

Recently I compressed all objects within a databases to page compression. Regardless of the object was a heap or clustered object. Heaps will keep their page compression on existing pages. New INSERT(s) that create new pages on heaps will be row compressed. I'm looking to maintain page compression and run a weekly rebuild on the heaps where row compression exists. Is the best way to approach this is to use sys.dm_db_index_physical_stats DMV? Compare the page count <> compressed_page_count. Where those two are not equal, is it fair to say there is row compression? Is there another way to go about this? Below is an example of the script and partial output of that script. Shouldn't I see more of a match on page count and compressed_page_count? Why are there so many mismatches?SELECT o.name, ips.partition_number, ips.index_type_desc, ips.record_count, ips.avg_record_size_in_bytes, ips.min_record_size_in_bytes, ips.max_record_size_in_bytes, ips.page_count, ips.compressed_page_countFROM sys.dm_db_index_physical_stats ( DB_ID(), NULL, NULL, NULL, 'DETAILED') ipsJOIN sys.objects o on o.object_id = ips.object_idORDER BY record_count DESC;index_type_desc page_count compressed_page_countNONCLUSTERED INDEX 1096438 1077279CLUSTERED INDEX 1961930 1958193HEAP 2134800 2134793CLUSTERED INDEX 891358 891356NONCLUSTERED INDEX 253437 253432

SQL DB to XML file on disk

Posted: 26 Mar 2013 05:52 AM PDT

Hi Am a newbie to the world of SQL server. I need to extract all recods from a DB table (say EMployee) and create a XML file on disk.EMP Table --> Name, Dept , Salary. I tried the below but not sure how to write this to an XML file on disk. Any help on this is highly appreciatedcreate proc [dbo].[EMPLOYEE]asdeclare @XmlOutput xml set @XmlOutput = (select name, dept, salary from dbo.EMPLOYEEFOR XML AUTO, ROOT('CallData'), ELEMENTS)select @XmlOutput AS CALL_DATA

Crosstab, dynamic number of columns, No Pivot function!

Posted: 26 Mar 2013 04:06 AM PDT

hi, is it possible to make a query that will turn a result set into a crosstab and it will automatically know how many columns are needed, but WITHOUT using the Pivot function?here is a table and data to illustrate what i'm talking about:CREATE TABLE Lines( line varchar(5) NULL, stopid varchar(5) NULL, boardings int NULL)insert into lines (line, stopid, boardings)values (2,1,58)insert into lines (line, stopid, boardings)values (2,2,37)insert into lines (line, stopid, boardings)values (2,3,40)insert into lines (line, stopid, boardings)values (2,4,41)insert into lines (line, stopid, boardings)values (4,1,13)insert into lines (line, stopid, boardings)values (4,2,21)insert into lines (line, stopid, boardings)values (4,3,25)insert into lines (line, stopid, boardings)values (4,4,20)insert into lines (line, stopid, boardings)values (4,5,12)insert into lines (line, stopid, boardings)values (4,6,9)insert into lines (line, stopid, boardings)values (4,7,4)insert into lines (line, stopid, boardings)values (4,8,3)insert into lines (line, stopid, boardings)values (4,9,1)--------------------------------------so when I select line 2, there would be four columns, each with the boardings number in it, when I select line 4, there would be nine columns.Thanks in advance for any help given!!-Martin

restore database without overwriting users

Posted: 26 Mar 2013 01:18 AM PDT

I am receiving a daily download of a database and restoring it locally to do some custom reporting on. I have this working from Batch files running nightly.The problem I have is that when I restore the database, it also overwrites the local users of the database which includes a user I added to access the tables from Visual Studio.How can I restore a database, but leave the local users tables alone?Thank you in advance.

SQL Server and NoSQL

Posted: 26 Mar 2013 04:22 AM PDT

Hi thereI need some advice/articles to go through. We have a ecommerce website using SQL Server 2008 R2. For the searches we implement a ranking system using FullText and some other ranking criteria, for example, the amount of units that product has sold etc.The search is working pretty well, but my manager wants to explore the use of NoSQL infrastructure to speed up our search results.Two questions:1. Can noSQL be completely integrated with SQL Server, so we can use the data in SQL to populate the NoSQL somehow?2. Will we have the flexibility to modify our searches according to our specific business needs?Any advice/articles pointing in the right direction will be appreciated.Thanks.

sql server question

Posted: 26 Mar 2013 04:03 AM PDT

Hi, it's sql server 2008R2 environment. There are some stored procedures in a database under schema called schema1. I granted userA execute,select and view deifinition on that schema1 schema. But userA is still unable to see those stored procs which are under schema1. Am I missing anything here to do? Thanks.

Curious: performance difference when using function in a where clause.

Posted: 21 Mar 2013 11:12 PM PDT

Hello all,This is just something I noticed and am [b]wondering[/b] about (I think this is an unexpected effect), there is [b]no problem[/b] to solve.I get a performance difference when I use a function in a where clause. See the code, the performance numbers are below the code.Sorry I was not able to isolate the problem and give definitions and data to reproduce this.Please read the code.[code="sql"]------------------------------------------------------------------------------------select * from client_order where -- ABS(ClientNr) = 12345 [b]ClientNr = 12345[/b] and startdttm = '2012-03-16'----(1 row(s) affected)----Table 'Encounter'. [b]Scan count 30, logical reads 62, physical reads 61[/b], read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.---- SQL Server Execution Times:---- CPU time = 0 ms, elapsed time = 765 ms.-- Estimated execution plan: Estimated Subtree Cost : [b]0.106408[/b]-- Actuel execution plan: Estimated Subtree Cost : [b]0.106408[/b]------------------------------------------------------------------------------------------------------------------------------select * from client_order where [b]ABS(ClientNr) = 12345[/b] -- ClientNr = 12345 and startdttm = '2012-03-16'----(1 row(s) affected)----Table 'client_order'. [b]Scan count 1, logical reads 4, physical reads 4[/b], read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.---- SQL Server Execution Times:---- CPU time = 0 ms, elapsed time = 49 ms.-- Estimated execution plan: Estimated Subtree Cost :[b] 0.0183334[/b]-- Actuel execution plan: Estimated Subtree Cost : [b]0.0183334[/b]------------------------------------------------------------------------------------[/code]Thanks for your time and attention,ben brugman

Maintaining Compression

Posted: 26 Mar 2013 02:44 AM PDT

Duplicate Post. My apologies. Proxy server at work is acting up.

Maintaining Compression

Posted: 26 Mar 2013 02:44 AM PDT

Duplicate Post. My apologies. Proxy server at work is acting up.

Problem in 1 Billion Records Table

Posted: 24 Mar 2013 03:34 PM PDT

Hi,I have one huge table which has 1Billion records. I tried to delete unnecessary records but it took a lot of time to delete and the delete was unsuccessful.Now my data is 26,491,552KB and index 20,569,168KB. Now inserting and updating process become very slow. What is the best way to handle the table to make it faster read and write access.Thanks in advance.

SSIS Warning - Global Shared Memory

Posted: 07 Apr 2009 10:27 PM PDT

HiI'm busy rewriting DTS packages as SSIS packages. As and when I finish a package I run it in debug mode via Microsoft Visual Studio and then examine the Exection Results to see the messages generated.Now it may or may not matter how I run the package but the following warning has been generated :-[SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.I'm one of these people who likes to run programs and get no warnings at all (if it can be helped).Can someone kindly explain what it means and if I can can get rid of it?

Track SQL severity levels in SCOM?

Posted: 12 Mar 2013 05:50 AM PDT

Trying to set up alerts and/or email notifications in SCOM 2007 that are triggered by SQL Server (2005 & 08) severity levels 19-25 and 823–825. Several db servers at my organization cannot send dbmail due to compliancy issues so I need another way to send alerts.Does anyone know if this can be accomplished in SCOM 2007? I can only find SCOM severity levels 0, 1, and 2 in FMSQLOPERATIONS.alert.vAlert. Maybe I can log these or pull these from the SQL Boxes' windows app logs using SCOM.Anybody have any experience with this?

Minimal Logging Enhancement in SQL Server 2008

Posted: 25 Mar 2013 09:53 PM PDT

Hi folks,SQL Server 2008 has enhanced INSERT..SELECT statement to allow minimal logging in certain cases, documented here:[url=http://msdn.microsoft.com/en-us/library/ms174335(v=sql.100).aspx]http://msdn.microsoft.com/en-us/library/ms174335(v=sql.100).aspx [/url](See section: Best Practices for Bulk Loading Data)We planned to use this feature in a situation where we wanted to insert millions of rows in an empty heap (or an empty clustered index) and made sure that all pre-requisites are fulfilled.[i]a) The target table is a heap or an empty B-Tree, b) TABLOCK is being used on the target table, c) The database is in SIMPLE recovery model, d) The target table is not used in replication.[/i]The INSERT is done from a SELECT from a temp table (#temp) having around 300,000 rows (300,000 distinct Ids) joined with another table that has ~500 rows for each of the distinct #temp.Id. Thus, 500 x 300,000 = 150 million rows (around 10 GB)We are on [b]Microsoft SQL Server 2008 (SP1) - 10.0.2740.0 (X64).[/b]But it seems the minimal logging is not working for us, as I see the transaction log growing to almost 10GB, during the insert if no other processes are running.We also face transaction log full issue, when other processes are running along with this insert. (Transaction Log size = 20 GB)There were no backups being run at the time of testing, which may have caused full logging.Is the minimal logging using INSERT..SELECT available in all versions of SQL Server 2008 or did it get included in one of the Cumulative Updates?I would really like to make use of this new feature in SQL Server 2008. Any ideas on how to achieve it, would be appreciated.

Optimal values needed for Server

Posted: 26 Mar 2013 01:11 AM PDT

Hi,Can any one tell me what these items are total cpu usage,context switches/sec,paging rate,network bandwidth utilization,disk queue length .Under what value ranges they should fall normally .. and how can we say some thing is wrong using these items.

Parallel Thread Deadlocks Help?

Posted: 25 Mar 2013 10:10 PM PDT

Trace Flag 1222 enabledProfiler CapturedDatabase Tuning AdviserI'm believe I'm getting "Intra-Query Parallel Thread Deadlocks" and not really sure how to go about fixing the problem.I know the problems are coming from a management tool database that we use in IT to remote and patch machines etc..This particular database has regular integrity checks as well as index rebuilds weekly I have captured the deadlock using Profiler then imported into the database Tuning Adviser. It's recommendations were to create various indexes which I applied but this didn't make any different to the problem I'm getting.Here is the deadlock info I'm getting but not quite sure how to troubleshoot. Any help would be much appreciated.

SSMS crashing at startup

Posted: 28 Aug 2011 07:23 PM PDT

Hello,I have a windows 2008 server with an instance of sql server 2008 installed on it. After installing an instance of SQL server 2008 R2. I'm no more able to open SQL server management studio, it crash at the startup, with the following message: - "SQL server management studio has stopped working".When I click the "details button" I get the following information:Description: Stopped workingProblem signature: Problem Event Name: CLR20r3 Problem Signature 01: ssms.exe Problem Signature 02: 2009.100.1600.1 Problem Signature 03: 4bb679e7 Problem Signature 04: mscorlib Problem Signature 05: 2.0.0.0 Problem Signature 06: 4d8c1599 Problem Signature 07: f50 Problem Signature 08: 7 Problem Signature 09: Exception OS Version: 6.1.7600.2.0.0.272.7 Locale ID: 4108Here is the detailed log:Version=1EventType=CLR20r3EventTime=129590751466956914ReportType=2Consent=1ReportIdentifier=510705be-d20d-11e0-a4a8-00155d43f601WOW64=1Response.type=4Sig[0].Name=Problem Signature 01Sig[0].Value=ssms.exeSig[1].Name=Problem Signature 02Sig[1].Value=2009.100.1600.1Sig[2].Name=Problem Signature 03Sig[2].Value=4bb679e7Sig[3].Name=Problem Signature 04Sig[3].Value=mscorlibSig[4].Name=Problem Signature 05Sig[4].Value=2.0.0.0Sig[5].Name=Problem Signature 06Sig[5].Value=4d8c1599Sig[6].Name=Problem Signature 07Sig[6].Value=f50Sig[7].Name=Problem Signature 08Sig[7].Value=7Sig[8].Name=Problem Signature 09Sig[8].Value=ExceptionDynamicSig[1].Name=OS VersionDynamicSig[1].Value=6.1.7600.2.0.0.272.7DynamicSig[2].Name=Locale IDDynamicSig[2].Value=4108UI[2]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exeUI[3]=SSMS - SQL Server Management Studio has stopped workingUI[4]=Windows can check online for a solution to the problem.UI[5]=Check online for a solution and close the programUI[6]=Check online for a solution later and close the programUI[7]=Close the programLoadedModule[0]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exeLoadedModule[1]=C:\Windows\SysWOW64tdll.dllLoadedModule[2]=C:\Windows\syswow64\kernel32.dllLoadedModule[3]=C:\Windows\syswow64\KERNELBASE.dllLoadedModule[4]=C:\Windows\syswow64\ADVAPI32.dllLoadedModule[5]=C:\Windows\syswow64\msvcrt.dllLoadedModule[6]=C:\Windows\SysWOW64\sechost.dllLoadedModule[7]=C:\Windows\syswow64\RPCRT4.dllLoadedModule[8]=C:\Windows\syswow64\SspiCli.dllLoadedModule[9]=C:\Windows\syswow64\CRYPTBASE.dllLoadedModule[10]=C:\Windows\syswow64\USER32.dllLoadedModule[11]=C:\Windows\syswow64\GDI32.dllLoadedModule[12]=C:\Windows\syswow64\LPK.dllLoadedModule[13]=C:\Windows\syswow64\USP10.dllLoadedModule[14]=C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4927_none_d08a205e442db5b5\MSVCR80.dllLoadedModule[15]=C:\Windows\WinSxS\x86_microsoft.vc80.atl_1fc8b3b9a1e18e3b_8.0.50727.4053_none_d1c738ec43578ea1\ATL80.DLLLoadedModule[16]=C:\Windows\syswow64\ole32.dllLoadedModule[17]=C:\Windows\syswow64\OLEAUT32.dllLoadedModule[18]=C:\Windows\syswow64\SHELL32.dllLoadedModule[19]=C:\Windows\syswow64\SHLWAPI.dllLoadedModule[20]=C:\Windows\system32\IMM32.DLLLoadedModule[21]=C:\Windows\syswow64\MSCTF.dllLoadedModule[22]=C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16661_none_420fe3fa2b8113bd\comctl32.dllLoadedModule[23]=C:\Windows\syswow64\CLBCatQ.DLLLoadedModule[24]=C:\Windows\system32\propsys.dllLoadedModule[25]=C:\Windows\system32tmarta.dllLoadedModule[26]=C:\Windows\syswow64\WLDAP32.dllLoadedModule[27]=C:\Program Files (x86)\Microsoft SQL Server\100\Shared\instapi10.dllLoadedModule[28]=C:\Windows\syswow64\SETUPAPI.dllLoadedModule[29]=C:\Windows\syswow64\CFGMGR32.dllLoadedModule[30]=C:\Windows\syswow64\DEVOBJ.dllLoadedModule[31]=C:\Windows\system32\profapi.dllLoadedModule[32]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\msenv.dllLoadedModule[33]=C:\Windows\system32\VERSION.dllLoadedModule[34]=C:\Windows\system32\SXS.DLLLoadedModule[35]=C:\Windows\system32\uxtheme.dllLoadedModule[36]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\1033\msenvui.dllLoadedModule[37]=C:\Windows\system32\CRYPTSP.dllLoadedModule[38]=C:\Windows\system32\rsaenh.dllLoadedModule[39]=C:\Windows\system32\RpcRtRemote.dllLoadedModule[40]=C:\Windows\syswow64\urlmon.dllLoadedModule[41]=C:\Windows\syswow64\WININET.dllLoadedModule[42]=C:\Windows\syswow64\iertutil.dllLoadedModule[43]=C:\Windows\syswow64\CRYPT32.dllLoadedModule[44]=C:\Windows\syswow64\MSASN1.dllLoadedModule[45]=C:\Windows\SysWOW64\mscoree.dllLoadedModule[46]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscoreei.dllLoadedModule[47]=C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dllLoadedModule[48]=C:\Windows\assembly\NativeImages_v2.0.50727_32\mscorlib\23bc3936180ff789f44259a211dfc7fc\mscorlib.ni.dllLoadedModule[49]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\AppIDPackage.dllLoadedModule[50]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System\610374fef100556da252243e673ac64b\System.ni.dllLoadedModule[51]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\8fcb99a22ed897c584edf6d0cc4c2e5d\Microsoft.SqlServer.SqlTools.VSIntegration.ni.dllLoadedModule[52]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.VisualStu#\3cf0869fb52f95ba66c44af9dc8204ce\Microsoft.VisualStudio.Shell.Interop.ni.dllLoadedModule[53]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.VisualStu#\8faa4b5bcdf2747817aa8265eeb5819c\Microsoft.VisualStudio.OLE.Interop.ni.dllLoadedModule[54]=C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorjit.dllLoadedModule[55]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Drawing\eba4ec48e3f7f16864c6d96f510fafd9\System.Drawing.ni.dllLoadedModule[56]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Windows.Forms\ad9c2f4737e1e07fa774af31a7d74235\System.Windows.Forms.ni.dllLoadedModule[57]=C:\Windows\assembly\NativeImages_v2.0.50727_32\SqlWorkbench.Interf#\864b9ee423e3e165c490161234074661\SqlWorkbench.Interfaces.ni.dllLoadedModule[58]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\62b49440df2124a81ecc0562ba077228\Microsoft.SqlServer.SqlTDiagM.ni.dllLoadedModule[59]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\40433cbeb10b6d14df78a6d697c0e55e\Microsoft.SqlServer.Instapi.ni.dllLoadedModule[60]=C:\Windows\assembly\NativeImages_v2.0.50727_32\EnvDTE\8230653175f553933b4db2f1bb8f0312\EnvDTE.ni.dllLoadedModule[61]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.VisualStu#\0aa9c0c21c7ccde9ac4ba666bcf5e477\Microsoft.VisualStudio.Shell.ni.dllLoadedModule[62]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.VisualStu#\9b79361da13edd39d0c2a893f0b7a0ae\Microsoft.VisualStudio.Shell.Interop.8.0.ni.dllLoadedModule[63]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\17e048fcec6ef01d19f8a5ad8c1e5bee\Microsoft.SqlServer.Management.SDK.SqlStudio.ni.dllLoadedModule[64]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\Packages\Debugger\vsdebug.dllLoadedModule[65]=C:\Windows\system32\MSIMG32.dllLoadedModule[66]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\Packages\Debugger\1033\VSDebugUI.dllLoadedModule[67]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.DataWareh#\fcba072adf0ae8ab0dbe9fa136e185ac\Microsoft.DataWarehouse.SQM.ni.dllLoadedModule[68]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\1033\AppIDPackage.rllLoadedModule[69]=c:\Program Files (x86)\Common Files\Microsoft Shared\VS7Debug\coloader80.dllLoadedModule[70]=C:\Program Files (x86)\ApexSQL\ApexSQLRefactor2008\ApexSql.Refactor.SsmsLoader.dllLoadedModule[71]=C:\Windows\assembly\GAC\Extensibility\7.0.3300.0__b03f5f7f11d50a3a\Extensibility.dllLoadedModule[72]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\4f1a27df050bbefad78b47f692860d66\Microsoft.SqlServer.Management.Sdk.Sfc.ni.dllLoadedModule[73]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\c1baff7ac94c5d243a7029dd6b6de516\Microsoft.SqlServer.Management.Reports.ni.dllLoadedModule[74]=C:\Windows\assembly\NativeImages_v2.0.50727_32\EnvDTE80\116509b8cdf36c562998803c5ee16a21\EnvDTE80.ni.dllLoadedModule[75]=C:\Program Files (x86)\ApexSQL\ApexSQLRefactor2008\ApexSql.Refactor.Ssms2008.dllLoadedModule[76]=C:\Program Files (x86)\ApexSQL\ApexSQLRefactor2008\ApexSql.Common.CommonLib.dllLoadedModule[77]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Configuration\0bddc91cbf37d143f08f6684b2919566\System.Configuration.ni.dllLoadedModule[78]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Xml\155679a9c8991cc33f90d6b27bac1977\System.Xml.ni.dllLoadedModule[79]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\c6a1362ff9bde823ee54a9dcede56c6b\Microsoft.SqlServer.Management.SqlStudio.Explorer.ni.dllLoadedModule[80]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\4d67f983b34ca9c59d2c7c06341166e8\Microsoft.SqlServer.Management.Controls.ni.dllLoadedModule[81]=C:\Windows\assembly\NativeImages_v2.0.50727_32\ObjectExplorer\b47708857448f5785f2f145dca3ae6f9\ObjectExplorer.ni.dllLoadedModule[82]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Design\a87b99435541fab7c7a58782904030f3\System.Design.ni.dllLoadedModule[83]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\bee73824bae4d7aedcb5abc9163cd71e\Microsoft.SqlServer.Management.UserSettings.ni.dllLoadedModule[84]=C:\Windows\assembly\NativeImages_v2.0.50727_32\SqlMgmt\0dc4c31dc6b4151fac9071c70596f6f7\SqlMgmt.ni.dllLoadedModule[85]=C:\Windows\system32\shfolder.dllLoadedModule[86]=C:\Windows\assembly\NativeImages_v2.0.50727_32\ConnectionDlg\38cea46249218a9ed0e7be1d8ed6da90\ConnectionDlg.ni.dllLoadedModule[87]=C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7600.16385_none_72fc7cbf861225ca\gdiplus.dllLoadedModule[88]=C:\Windows\system32\WindowsCodecs.dllLoadedModule[89]=C:\Windows\assembly\GAC_MSIL\Microsoft.VisualStudio\2.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.dllLoadedModule[90]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Drawing.Desi#\0fb34b9054c6a2491e48b8be259a5b43\System.Drawing.Design.ni.dllLoadedModule[91]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.VisualStu#\ad22382630a4c67729c4fbb56358d8f7\Microsoft.VisualStudio.Designer.Interfaces.ni.dllLoadedModule[92]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\6773e394d6582bec2129252e17d34e76\Microsoft.SqlServer.RegSvrEnum.ni.dllLoadedModule[93]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\VS SCC\1033\VssProviderui.dllLoadedModule[94]=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.SqlServer.Management.SqlStudio.Migration.dllLoadedModule[95]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\8bd8872d84923c75fec798f98d70cee0\Microsoft.SqlServer.Management.SqlStudio.Migration.ni.dllLoadedModule[96]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\3f14de30910c16142636e4a6f4fd827c\Microsoft.SqlServer.Smo.ni.dllLoadedModule[97]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.NetEnterp#\3fb5e172f37fcc845966b2c181eba25d\Microsoft.NetEnterpriseServers.ExceptionMessageBox.ni.dllLoadedModule[98]=C:\Windows\assembly\NativeImages_v2.0.50727_32\System.Data\86f429e0a23238cf277d464bd0433d86\System.Data.ni.dllLoadedModule[99]=C:\Windows\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dllLoadedModule[100]=C:\Windows\syswow64\WS2_32.dllLoadedModule[101]=C:\Windows\syswow64\NSI.dllLoadedModule[102]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\b23d899f3488016213705826a909e2f1\Microsoft.SqlServer.Management.SqlStudio.ni.dllLoadedModule[103]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Accessibility\5c6e1a094b1e65c69b528151cc19b1ee\Accessibility.ni.dllLoadedModule[104]=C:\Windows\system32\oleacc.dllLoadedModule[105]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\924b5c76a22f99698324e0164fb80af9\Microsoft.SqlServer.ConnectionInfo.ni.dllLoadedModule[106]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\a043fb3b67c8cdea7b4d9b03bf8381cb\Microsoft.SqlServer.Management.RegisteredServers.ni.dllLoadedModule[107]=C:\Windows\assembly\NativeImages_v2.0.50727_32\Microsoft.SqlServer#\0435b8b3c7483bd03683b576a57ccd93\Microsoft.SqlServer.SqlClrProvider.ni.dllLoadedModule[108]=C:\Windows\system32\apphelp.dllFriendlyEventName=Stopped workingConsentKey=CLR20r3AppName=SSMS - SQL Server Management StudioAppPath=C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exeReportDescription=Stopped workingI have tried to uninstall SSMS and reinstall it, but the same error occur.Thank you for your help
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog