InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 13:31:25 GMT20http://www.sqlservercentral.com/Forums/Topic1306066-391-1.aspxCan Anyone explain the logic to behind to get the first day of the monthSELECT dateadd(MM,datediff(MM,0,getdate()),0)Thu, 24 May 2012 12:44:58 GMTJay Petehttp://www.sqlservercentral.com/Forums/Topic1306101-391-1.aspxI set one column as varchar(8000) but user still complain that some input was cut off.Does varchar(8000) really store 8000 characters?Thu, 24 May 2012 13:19:36 GMTadonetokhttp://www.sqlservercentral.com/Forums/Topic1306070-391-1.aspxHello,Can anyone tell me if SQL has a transaction that is open but is in a sleep status, if that SPID is still using CPU resources? I have a server with over 4000 open transactions which most of them are not active, and I am trying to figure out what type of impact this is having on the CPU. Please note that this is a vendor application so my hands are tied as far as correcting the code.Thu, 24 May 2012 12:48:28 GMTrodmeanshttp://www.sqlservercentral.com/Forums/Topic1306067-391-1.aspxThis is an issue I run into periodically that drives me crazy.I am importing an excel sheet to add data to my table and I go through the process pointing to the table and editing mappings.All of the ones I map have a yellow triangle with an exclamation point in it. The ones I didn't map have a green circle with a checkmark (these are set as Ignored and not mapped).The ones I mapped happen to be all varchars - so shouldn't be a problem.Then when I go to the Save and Run, depending on how many I have mapped - I MAY be able to run immediatly. If I map more then about 5, the Run Immediately choice is disabled??????If I allow the program to use a new files (which it names the same as the excel file, than it allows me to run immediately.Why can't I ALWAYS run immediately???Thanks,TomThu, 24 May 2012 12:45:58 GMTtshadhttp://www.sqlservercentral.com/Forums/Topic1305937-391-1.aspxHi All,I have SSIS package which loads the millions of data everyday.SSIS package has Flatfile Souce and OLEDB Destination.I want logging so i should have records how many records are inserted into the table.Please suggest to get rid of the task.Thanks in advance,JayThu, 24 May 2012 09:04:45 GMTJay Petehttp://www.sqlservercentral.com/Forums/Topic1306056-391-1.aspxHello there. I've been administering our company's SQL database for a good while now, and I've begun to move into an idea I had to use XML to handle API calls that rely on our data. Unfortunately, I have essentially no XML experience, so I'd like a few pointers on how to handle XML in the context of SQL Server.Looking at the MSDN article on SQLXML, it seems that it should be possible to generate an XML document by using FOR XML and formatting as needed, with the additional ability to insert parameters into the XML generation statements that would hold data pulled from our database; from there, it should be possible to export the contents to a file, correct? At this point, though, I'm a bit lost. I need to get the XML document sent out and retrieve a response, and I'm not sure this is something SQL Server is capable of (and I honestly wouldn't expect it, following the logic that the prime function of a database should be to house data, rather than firing off calls across the web).If my reasoning holds true, how would I get the SQL-generated XML documents out to the API in question? I believe the POST command for XML should do it, but I honestly don't have a clue how or where I'd direct that to where it should go. That's my biggest stumbling block at the moment.If this is too much of an XML-based question, I understand; I'll toss this thread out and try the XML section of the forums instead. I would be pleasantly surprised if my guess about SQL's XML transmission is wrong, but I'll adapt as needed.Many thanks for your time.Thu, 24 May 2012 12:27:59 GMThisakimatamahttp://www.sqlservercentral.com/Forums/Topic1305997-391-1.aspxHi allI know that SQL Server is backward compatible - I can restore a 2005 Database into a 2008 instance. Is this possible between Service Packs?Can I restore a database for a SQL 2008 SP2 instance into a SQL 2008 SP3 instance?I recently took a backup of my MSDB database, upgraded the service pack and was not able to restore the database. ThanksThu, 24 May 2012 10:36:12 GMTderekr 43208http://www.sqlservercentral.com/Forums/Topic1304019-391-1.aspxHi All,We have to create some standard DBA maintenance plans everytime a new SQL server is installed, is there any shortcut through which I can copy those plans from the server where they already exist to the new one? I know shortcut for copying DTS packages but can't find one for SSIS packages.Tue, 22 May 2012 04:20:49 GMTMI_DBAhttp://www.sqlservercentral.com/Forums/Topic1306036-391-1.aspxHi All, My employer has recently migrated a database from Sybase ASE 12.5.3 to SQL Server 2008 R2. After the migration, if I try to store a certain special character "bullet point" through the Java application, it is getting stored as a different value. But the same "bullet point" is written to the database correctly, if I use the query editor in SSMS.Have any one noticed this kind of issue before..? Is it because of the collation? Can you help me?Thanks!Siva.Thu, 24 May 2012 11:45:52 GMTSiva Ramasamyhttp://www.sqlservercentral.com/Forums/Topic1306030-391-1.aspxHi all - I'm working error handling in a package and one of the requirements is to log an error when there are no files to process. It seems that the ForEachFile container just quits with success when no files are found. In other error handlers I've put an execute SQL task and written to a table. I need to do the same here, but it's not reported as an error... any ideas?Thu, 24 May 2012 11:35:54 GMTUripedes Pantshttp://www.sqlservercentral.com/Forums/Topic1305695-391-1.aspxHopefully a quick post.I am running an ASP.net 4.0 website with backend database SQL Server 2008. (hosted on GoDaddy)I have recently copied my production website onto my pc and have also installed SQL Server 2008 Express so I can develop it and the production database has been copied onto my PC.When I run the website from my PC I get:The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.This works fine on my actual website so it has to be something with the date format on the SQL Server Express running on my PC.When I run selet getdate() on the 2 sql servers I receive:GoDaddy SQL Server:5/24/2012 3:52:43 AMMy local SQL Server:2012-05-24 06:52:33.957What do I need to change on my local SQL Server to get the date to the format seen on the GoDaddy server?Thanks for all replies.Thu, 24 May 2012 04:54:51 GMTjamie_collinshttp://www.sqlservercentral.com/Forums/Topic1305943-391-1.aspxHi All, Is it possible to set the transaction isolation level for a specific login? I.E. If a support team connects to a DB all queries they write use READ UNCOMMITTED?Cheers,Thu, 24 May 2012 09:09:09 GMTLoundyhttp://www.sqlservercentral.com/Forums/Topic1305970-391-1.aspxHello -I am creating several reports. Each report runs daily and a team uses each of the reports on a daily basis. I would like to make it easy for the team to come in each day and print all the reports. I have two ideas:Idea 1:Each date, all the reports will print to a folder with the date as the folder name (in YYYYMMDD format so that it can be sorted easily). So, I would have a Parent folder and subfolders with names like: 20120520, 20120521, 20120522, etc. Each day a new folder would be created and the reports would go into that folder.Idea 2:If Idea 1 is not possible with SSRS, then I would print all reports to one folder, but I would want to put the date at the beginning of the file name in the YYYYMMDD format. This way when they are sorted, all of the reports for the day are sorted together and the users do not have to hunt and scroll for reports.Is this possible with SSRS?Thank you.TammyThu, 24 May 2012 09:42:04 GMTtammyfhttp://www.sqlservercentral.com/Forums/Topic1304274-391-1.aspxHiWe are planning to partition a table based on a column containing year.There will be 3 partitions: one for current year, one for previous year and one for remaining years(containing data which is usually not queried).Now we plan to keep all partitions in same filegroup on same disk as we don't hae option for additional disk.My question is, will it boost the performance of my queries considering that most of the queries are fired on current year data.Tue, 22 May 2012 10:02:49 GMTS_Kumar_Shttp://www.sqlservercentral.com/Forums/Topic1305341-391-1.aspxCurrently we have SQL server 2008 standard edition, we are using SSRS and SSIS.If we later want to upgrade the server to 2012, can we still use standard edition for the purpose of using SSRS and SSIS just like we do in SQL server 2008?I know there is a business intelligence edition in 2012, but more expensive than standard, so I just don't want something we don't use, but to buy the edition that has equivalent function as 2008 BI features.Wed, 23 May 2012 14:02:43 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1303209-391-1.aspxHi friends, could u please any one tell me the these questions1) what is your company file architecture and how much data u r handle.2) how many data and log files u r handle in u r company3)what is the difference between installtion of 2005 and 20084)i have done installtion of sqlserver in c:\ drive but i want d:\ drive how to do this. Pls friends send me answers i have faced this questions in interview time.Mon, 21 May 2012 01:25:31 GMTk.subramanyam1017http://www.sqlservercentral.com/Forums/Topic1305933-391-1.aspxHi,Thanks for coming here and reading my question.I have one table called TRN_Image and here I have one column called vImage varbinary(Max). I am inserting data using below query.INSERT INTO TRN_Image ( iImageID, vImage )VALUES ( 1000, (SELECT * FROM OPENROWSET(BULK N'C:\Chand.jpg', SINGLE_BLOB) AS img1) )It is inserting data which looks like.....(0xFFD8FFE000104A46494600010101006000600000FFDB0043000201010201010202020202020202030503030303030604040305070607070706070708090B0908080A0807070A0D0A0A0B0C0C0C0C07090E0F0D0C0E0B0C0C0CFFDB0043.....28A28A0028A28A0028A28A0028A28A0028A28A00FFD9)I want to know that which format is this? Is it Binary, Hexa Decimal, base64, etc. Is ther any way in SQL server to view this image?When I am inserting this same image from my iPad app using base64 data then it is different than this data and i am not able to figure it out that which format I have to use.ThanksChandresh PatelThu, 24 May 2012 08:59:50 GMTcpatelhttp://www.sqlservercentral.com/Forums/Topic1305906-391-1.aspxI have table1 and table2.Table1 is source table and table2 in Dim table. when i insert value, or update ant value or delete value it should effect to the dim table also....If i insert record in source table then it will dynamically insert in dim. same as if any data updated or deleted in source table then it should change in dim table.i need to create stored procedure or SSIS package for that. Aapno khub khub aabhar ( In Gujarati Language - india )( Thank you very very much )Thu, 24 May 2012 08:35:15 GMTpatelronaks1983http://www.sqlservercentral.com/Forums/Topic1304443-391-1.aspxI am looking into creating an HR database for an organization with a central admin office and remote locations. According to my supervisor, they need to keep copies of employee records at the remote location for the employees assigned to that location. (Of course that pertains to physical records on paper...)The managers at the locations will be able to view/enter/edit the data.Setting aside the question "if it's electronic do they need a copy?" is there a way to automate having a remote copy of a subset of the database at several locations and keep changes synched between them over the internet? Or does it need to be done with code? Or can it be done even with code?We have 2008 R2 Web edition.Any advice or ideas to point me in the right direction would be helpful (quit? :-D)Tue, 22 May 2012 13:13:06 GMTtimwellhttp://www.sqlservercentral.com/Forums/Topic1305863-391-1.aspxI have a package that runs on a job server that pulls data from db2 and populates sql tables on a different server. So, data flow is db2 (odbc) thru sql job server to another sql server using linked server connection. When the package is executed from a job it runs in about 45 minutes, when I open the solution and run it, it completes in less that 10 minutes. The job server is server2008r2, sql2008r2, 64bit, 1cpu, 8gb ram. Why would this happen?Thu, 24 May 2012 07:58:20 GMTSQLHeaphttp://www.sqlservercentral.com/Forums/Topic1296145-391-1.aspxI am trying to set up a scheduled job that executes an SSIS package stored in the package store. When I execute the job, it 'works' but is putting out an error message about the connection I set up in the package for use only with SQL Server Configuration values. To me, it seems when my package runs, it is trying to 'validate' the connection to my SQL Server Configuration too soon and I get the error messages.Since I want to be able to write the package one time for deployment in 3 environments, I am setting the connection string for the 'SQL Server Configuration' on the job. I know that the package is reading from the Configuration table, because values used by the package are not being saved in the package and can only be found on the configuration table.Each environment is on a separate server with different user id that the jobs run under. So I don't put that information in my package.So while my Package actual runs correctly and is obviously getting the connection information, I don't want the job to keep putting out these messages that make it look like an error occurred.I'm not sure what else I can say or show because this is very straight forward. The package is a simple data flow between two tables on two separate databases with a single configuration. On the job I set the ConnectionString for the connections.Mon, 07 May 2012 15:58:04 GMTLoras Freihoeferhttp://www.sqlservercentral.com/Forums/Topic1305883-391-1.aspxHello,I'm building a report in SSRS. I have many datasets in the report.The datasets are built based on a stored procedure that expects a parameter. Depending on the parameter the procedure retruns specific columns. No matter what parameter I pass the return is the same..I have test my procedure it works perfectly..It looks like what ever the first dataset have the other datasets would have as columns even though I'm calling them with different parameters that return different columns.Any ideas ???Thank youThu, 24 May 2012 08:11:27 GMTBeginner2012http://www.sqlservercentral.com/Forums/Topic1303496-391-1.aspxHi,I am trying to rewrite queries, for better performance. I rewrote one and displayed the execution plan. It gave me a missing index. I created the index and displayed the plan again. It gave me another missing index, which I created. I displayed the plan again and had no missing indexes.Today, I did the same thing with another query. I displayed the execution plan and go a missing index. I created the index, but when I display the plan, I still get the same index is missing.I went back to my first query and displayed the execution plan. It gave me another missing query, which I created. However, no matter how many times I create the index and display the plan, it still tells me that the index that I created is missing.Thanks,DavidMon, 21 May 2012 10:08:11 GMTdpedrellihttp://www.sqlservercentral.com/Forums/Topic1305380-391-1.aspxHey all,I received a database containing user data from a firm, and my job is to locate and extract certain parts of that data. I have essentially no prior knowledge of the structure of the database. I have looked at the different numbers of rows in each table and have identified some tables of interest. One thing I'm having trouble with is figuring out where certain fields that are key fields come from. That is, if there is a customer type key field in the Customer table, I want to know what table contains that key as its primary key and contains descriptive information on the different types.What is the best way to do this? I've tried making a database diagram and adding related tables. However, one thing I don't like about this is the lines between the tables aren't drawn to the fields they are linked to. The lines themselves may say the foreign key constraint in a tool tip, but they don't accurately diagram the relationships.By contrast, if I add 2 tables to a view that I know have a relationship, the diagram in the view draws lines from the primary key of one table to the field in the other table that references that key. The issue is that you have to know that the tables are related already as far as I know. Is there a fast way to figure out these tables relationships? I would appreciate any advice anyone can give. Thanks.Wed, 23 May 2012 14:41:58 GMTSQLUserChttp://www.sqlservercentral.com/Forums/Topic1305828-391-1.aspxHello,I have what i hope is a relatively simple question, that i will keep deliberately non-specific ;-)Basically, there are some built in functions within SQL server that allow an unknown number of parameters. The most obvious one of these that i can think of is Checksum()How do these work? Can i look 'inside' of Checksum() somehow?Ultimately what i want to be able to do say:[code="other"]select myFunction(field1, field2, field3, fieldn) from myTable[/code]and have the flexibility to have myFunction do whatever i choose ;-)I am thinking a CLR might be required here... thanks in advance!Thu, 24 May 2012 07:33:41 GMTBGMhttp://www.sqlservercentral.com/Forums/Topic1303949-391-1.aspx[font="Arial"]Hi All,I hope someone would be able to help me.I need to write a process in SQL Server that will: 1. Read through a specific directory and update a specific table with the path of each document in a specific directory, 2. as well as update the name of each of these documents. 3. Store each document in ExampleDB_DocLib (document_storage_tbl) linking it to the document_tbl. Column document_pk is the link. 4. It must be a scheduled task in the SQL Agent.The documents are in the following directory:• D:\Documents_1\Documents_2\This directory path is mapped in the Example database (ExampleDB_Example_2005) in table document_tbl and the documents are stored in ExampleDB_DocLib in table document_storage_tbl. Thanks![/font]Tue, 22 May 2012 02:13:22 GMTclerouxhttp://www.sqlservercentral.com/Forums/Topic1305527-391-1.aspxHI ,We have ssis job running on sql 2008.The job fails with below error.MessageExecuted as user: . Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:10:12 AM Error: 2012-05-24 05:10:13.12 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2012-05-24 05:10:14.18 Code: 0xC0202009 Source: DTS_X Connection manager "Microsoft OLE DB Provider for SQL Server" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "Login failed for user 'sa'.". End Error Error: 2012-05-24 05:10:14.18 Code: 0xC020801C Source: DTSTask_DTSDataPumpTask_1 OLE DB Destination [34] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Microsoft OLE DB Provider for SQL Server" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2012-05-24 05:10:14.20 Code: 0xC0047017 Source: DTSTask_DTSDataPumpTask_1 SSIS.Pipeline Description: component "OLE DB Destination" (34) failed validation and returned error code 0xC020801C. End Error Error: 2012-05-24 05:10:14.20 Code: 0xC004700C Source: DTSTask_DTSDataPumpTask_1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2012-05-24 05:10:14.21 Code: 0xC0024107 Source: DTSTask_DTSDataPumpTask_1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:10:12 AM Finished: 5:10:14 AM Elapsed: 2.11 seconds. The package execution failed. The step failed..Can any one help me please.Thanks,Wed, 23 May 2012 23:23:09 GMTbala2http://www.sqlservercentral.com/Forums/Topic1304945-391-1.aspxI have a for loop that has two variables, variableX and variableY passed to it by two execute sql tasks. Within the for loop my EvalExpression is variableX <= variableY. Within the For Loop I have a data flow that takes the bottom N number of records and processes them, then it loops around and processes the next N number of records. After each loop it updates a table with a value that I'm grabbing variableY from so it knows which records to grab next. The problem is, I can't seem to figure out how to update variableY after each loop. So the package runs fine but it errors out at the end because it tries to process even though there are no records left to process. It's seems like it should be pretty simple to solve, but I haven't had much luck. I tried updating the variable after the data flow with another execute sql task, but that doesn't seem to work. Any help would be much appreciated!Wed, 23 May 2012 07:44:36 GMTshawn.larsonhttp://www.sqlservercentral.com/Forums/Topic1305817-391-1.aspxHi, I recently took over a Reporting Services server and had to delete the encryption key to restart the server instance. The reports on the server runs off of a series of shared data sources. There's a "Data Sources" folder on the server. Since the encryption key was reset, the connection strings for the sources need to be reset. The previous person in charge of the Reporting Services server is no longer with the company. Does anybody know where the data sources .sln files (Business Intelligence Development Studio files) are stored?Thu, 24 May 2012 07:25:26 GMTguerillaunithttp://www.sqlservercentral.com/Forums/Topic1304211-391-1.aspxHi - I recently uninstalled a SQL cluster, however I am left with an issue with MSDTC. I am trying to re-create the cluster but the IP we assigned for MSDTC is saying that its in use. I can see there is a service and also in COM there is a clustered MSDTC.How can I completely remove MSDTC from the cluster? I have tried MSDTC -uninstall but this just uninstalled the local copy of MSDTC and not the clustered one.All thoughts welcomeThanksTue, 22 May 2012 08:38:47 GMTKwisatz78http://www.sqlservercentral.com/Forums/Topic1305665-391-1.aspxHi,I have a file which I named "file1 codp meta2.rar"As you can see this file name as spaces betwwen string which makes the below command don't work: set @NomeFinal ='file1 codp meta2.rar'set @DirectoriaFinal='c:'select @cmd = '"C:\Program Files\WinRAR\WinRAR.exe" x -u '+@NomeFinal+' '+@DirectoriaFinal+''exec master..xp_cmdshell @cmd, no_outputThe execute command only takes part of the name "file1" because of the spaces...How can I make this work ? the file name shoud have spaces....Thu, 24 May 2012 04:05:18 GMTriver1http://www.sqlservercentral.com/Forums/Topic1305528-391-1.aspxTable 1 contains the below fieldsGROUP_ID, Emp_id and emp nameTable 2 contains the below fieldsEMpid, GroupList, GROUP_IDScenario is to insert the Grouplist and Group id in to table 2Condition:1) GroupList – Each grouplist (per GROUP_ID will have (TOTAL_CNT / 4) records in it (rounded up to nearest whole value)Count the total no of records in table 1 group by GROUP_IDE.G. TOTAL_CNT = 175 TOTAL_CNT / 4 = 43.75 – Round up to 44. Record #1 to Record # 44 – GroupList will be 1. Record #45 through Record #89 – GroupList will be 2. Record #90 through Record #133 – GroupList will be 3. Record #134 through Record #175 – GroupList will be 4Wed, 23 May 2012 23:24:06 GMTsqlstudhttp://www.sqlservercentral.com/Forums/Topic1305552-391-1.aspxHi..All,I have an issue , Kindly any 1 help me on thisI have a table which stores the dates as followsProduct| FridayDate| MondayDateABC | 2012-06-15|2012-06-18ABC | 2012-06-22|2012-06-25ABC | 2012-06-29|2012-07-02I need to check in which range this date "2012-06-27" falls. I have to get the following as outputas the date falls b/w 2012-06-25 and 2012-06-29, need to compare monday date and friday dateProduct| FridayDate| MondayDateABC | 2012-06-22|2012-06-25ABC | 2012-06-29|2012-07-02Thanks in advance :)Thu, 24 May 2012 01:06:37 GMTmanzilkolur23http://www.sqlservercentral.com/Forums/Topic1268315-391-1.aspxHiAny can help me for Generating the create and Drop script for Constraints and Indexes on a databaseFri, 16 Mar 2012 09:17:11 GMTDanzzhttp://www.sqlservercentral.com/Forums/Topic1303857-391-1.aspxHi All, I downloaded SQL SERVER 2008 R2 Enterprise Evaluation version & installed for checking some futures. ISSUE :- I am trying to configure Log-shipping but not able to see future. Let me know, can it is possible to configure in Enterprise Evaluation Version or not...Thanks in advance...Satish...Mon, 21 May 2012 23:23:43 GMTsaidapurshttp://www.sqlservercentral.com/Forums/Topic1305602-391-1.aspxHi,I'm hoping someone will be kind enough to give me a hand on a little problem I have.Basically we a relationship table, that uses a parent-child association, this table is displayed in the code below as table #Old.However I need to link the children together as shown in table #New.The IDs will be random so it's not possible to just increment the id by one but it is most likely safe to say that the next id will be greater then the previous.If someone could please show me a query method of getting from table #Old to table #New I would be really grateful.Many thanks.Lewis[code="sql"]create table #Old (FirstID int, SecondID int)insert into #Old select 101, 201insert into #Old select 101, 202insert into #Old select 101, 203insert into #Old select 101, 204insert into #Old select 101, 205select * from #Oldcreate table #New (ParentID int, FirstID int, SecondID int)insert into #New select 101, 201, 202insert into #New select 101, 202, 203insert into #New select 101, 203, 204insert into #New select 101, 204, 205select * from #Newdrop table #Olddrop table #New[/code]Thu, 24 May 2012 02:43:46 GMTlewisdow123http://www.sqlservercentral.com/Forums/Topic1305564-391-1.aspxHI All,I am facing a weird issue ,during the processing of the certain tasks from Application,some part of time we are observing blocks in our database.Processing ,load are quite normal at that time of blocks and what we observe is last query which is holding locks and making the other processes to wait is sp_cursorclose;1 it is taking a very long time just say 2hrs.As the blocks are making the other activities to be on hold,application performance went down.Why sp_cursorclose is taking a very long time to process and one more thing what we observed is this process is blocked by spid 0.What is the significance of the process 0?why and when this process blocks the others?Is there a way to fix this issue or it should definitely fixed from the application?Thu, 24 May 2012 01:41:19 GMTrkumar590http://www.sqlservercentral.com/Forums/Topic1305640-391-1.aspxHi, I am configured successfully Marge Replication in my PRO ENI.I have a small query..If i insert any data in a any table automatically new column is generated Column Name :- rowguidData type :- uniqueidentifierAny one can explain me. Why it is generating? What is use?Thanks in Advance.......SatishThu, 24 May 2012 03:33:11 GMTsaidapurshttp://www.sqlservercentral.com/Forums/Topic1260112-391-1.aspxHi allMS KB article http://support.microsoft.com/kb/958734 says before installing SP1 on Passive node [b]In the Cluster Administrator tool, use the corresponding SQL Network Name resource to remove half of the nodes from the possible owners list in the failover cluster instances on which you want to apply the updates. Remove the passive nodes first from the possible owners. Keep the list of nodes that you remove from the possible owners for future reference during this update process.[/b]Do we really have to do this? Has anyone applied SP1 without ' removing half of the nodes from the possible owners list in the failover cluster instances ' Is there any straight forward instruction MS instruction seems bit complicated to me :)Thanks in advanceThu, 01 Mar 2012 07:14:05 GMTSqlsavyhttp://www.sqlservercentral.com/Forums/Topic1304835-391-1.aspxHi I'm looking at one of my databases and trying to get fragmentation infoi run the queryselect top 10 * from sys.dm_db_index_physical_stats(21 ,0,NULL,0,'LIMITED') but the query itself just sits there for an age (i stopped it after 12 minutes)i ran sp_who2 and that particular spid is reporting back DBCC under the command, with a very very slowly incrementing DiskIO columnis sys.dm_db_index_physical_stats just ruinning a DBCC SHOWCONTIG under the bonnet? - all my other databases seem to run this absolutely fineWed, 23 May 2012 05:03:14 GMTmichael vessey