Answer Questions

• UI Freak Database Diagrams

  TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. ------------------------------ BUTTONS: OK ------------------------------ I don't know what is the meaning of the above message, which I get when I 'right click' the Database Diagrams node of the Northwind database. Every thing seems OK, since I am the owner of this database. I am using the trial version of MS SQL Server 2005. Thanks a l ...Show All

• Vlad Pitaru Can't connect to server

  I reinstall sql server develope edition. Then I try to connect the server from another computer, it shows below infomation. But in server property, it allows remote connection. I don't know whether it was caused by reinstall. Before reinstall, I can connect to the server, but it's edtion is group version. And edition for client is also group version. Any one can help me Thank you very much! TITLE: Connect to Server ------------------------------ Cannot connect to *.*.*.*. ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under t ...Show All

• Rafael Mores Totaling of the represented values (but not dataset values)

  Hello! I have a problem with totaling. There is table below which represents what exactly I need. Each cell value in the table is field multiplied by a coefficient. Totals should sum all row values as represented below : Tasks            User1 value                  User 2 value      ...     Column Totals  task 1            =field1_1*coef1           =field2_1*coef2   ...    =field1_1*coef1 + field ...Show All

• Bulldog.NET Restore a filegroup

  Can i restore a single filegroup (or file) to a previous point in time (say 8am), but keep the rest of the database unchanged (say 10am). Or, does the whole database have to be at the same point in time after a restore of a specific filegroup. Thank you. From what i have found out, that is correct. Too bad about that though. I'm sure the product will improve in that area one day. The entire database has to be at the same point in time after a restore (of a specific filegroup). Thanks Sherry ...Show All

• TRID sp_spaceused

  Hi everyone, I'd like to retrieve the results for SP_SPACEUSED. I've created a table with 7 columns, something like that: CREATE TABLE [dbo] . [ESPACIOUSADO] ( [DATABASE_NAME] VARCHAR ( 255 ) NULL, [DATABASE_SIZE] VARCHAR ( 120 ) NULL, [UNALLOCATED SPACE] VARCHAR ( 120 ) NULL, [RESERVED] VARCHAR ( 120 ) NULL, [DATA] VARCHAR ( 120 ) NULL, [INDEX_SIZE] VARCHAR ( 120 ) NULL, [UNUSED] VARCHAR ( 120 ) NULL, ) ON [PRIMARY] INSERT INTO ESPACIOUSADO ( [DATABASE_NAME] , [DATABASE_SIZE] , [UNALLOCATED SPACE] , [RESERVED] , [DATA] , [INDEX_SIZE] , [UNUSED] ) EXEC sp_spaceused But it doesn't works ...Show All

• paso Problem to logon

  Hi, we had a Problem that a colleague can't connect the SQL-Server on one server. We use the VSTS 2005 and SQL Server 2005. He is trying to build a ne connection to the virtual maschine with his windows account and got the following message Login Faild for User ''. The user is not associated with a trusted SQL Server connection. He is user on the database and the server. he has dbowner rightson the database he tryed to connect. How we can fix this Problem. Thanks Thomas Hi, Thomas , refer below KB which has work around for the problem you are facing. http://support.microsoft.com/kb/889615/en-us Hemantgiri S. Goswami Is this local connection Can you check wheth ...Show All

• Emeraald TextBox break layaout in excel

  Hello, I have textBox in header of report, and it's expression - based (= "test text"), when I export in excel I get at the first time report that looks normal. But at the second - I get report with broken layout (I can press CTRL + F5 and all will OK) Or I can set TextBox static(not based expression) and all will OK too Could you please help me to solve this problem I'd like to have a dynamic textBox and normal layout. Thanks What's difference between based expression textBox and static when it's renderring ...Show All

• Tatworth Write a Trigger

  Hi all, i want to write a trigger which returns a row to the application whenever a row is inserted into a table. E.g. When row R1 is inserted into a table T1. the trigger should return the R1 to the application. Wanna be coding monkey... Hi all, thanks for your help, well as i am new in this SQL let me be clear on my requirements.. 1. we have a table T1, when a new row R is added in T1, i have a service who triggers an action (say beep) depending on the entities in R, i want a trigger who will send the data in R of T1 to that service. Now, question 1 - is it possible to write sucha trigger 2. if yes, how how can a table return a value to a service. Regards, chaman. i think you need ...Show All

• Prabagarane Ongoing problem connecting to SQL Server

  Hi, I am getting the error: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) whilst trying to connect to a database on SQL Server Express from an ASP .NET application. I'm trying to connect locally for testing purposes, so there seems to be little relevance in the "not allowing remote connections" error. I was kindly helped out the other week by Jimmy Wu who gave me links to some resources to read. This allowed me to connect without an error via th ...Show All

• S 007 Attempt to return record set in INSERT...EXEC statement from ODBC source(non MSSQL)

  Greeting. I use OdbcConnection inside clr procedure, for getting data. If I use simple EXEC dbo.clr_proc - all is OK. If I use INSERT...EXEC I recive error message: Distributed transaction enlistment failed . I set MSDTC security options for No Authentification and Allow inbound and Allow outbound, but it's no use. Have this problem solution May be, I must use another method to get my data P.S. Linked Servers and OPENQUERY is not applicable. Sybase not describe columns in stored proc result set and one stored proc may return different result set by params. P.S.S. Sorry for bad english. Is the underlying Odbc provider DTC-aware If not, it can't handle a DTC transaction. You might try DT ...Show All

• MShetty SSIS Higher Level Edition error when run in a Sql Job

  Hi, I am receiving the following error in Sql Job agent when I try to run an SSIS package : The task "Create Excel File" cannot run on this edition of Integration Services. It requires a higher level edition. It then goes on to tell me : The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. I have tried reseting the error count to allow for the "errors" , but it stills fails. The job suceeds in Visual Studio, but not when scheduled in Sql Management Studio. Any suggestions Thanks, J. See if my explanation here helps: http://blog ...Show All

• eric_from_nj How can I export data to a .sql with insert statements?

  Can someboby help me sith this issue. thanks in advance There's already data in the tables and I would like to become something like this... INSERT INTO Vertices VALUES (-99.6875 , 13.9952516555786, 0, 1); INSERT INTO Vertices VALUES (-46.597225189209, 14.1290817260742, 1, 1); INSERT INTO Vertices VALUES (-34.9146385157818, -8.08516788087916, 2, 1); INSERT INTO Vertices VALUES (-66.7407750757877, -54.3090734484738, 3, 1); INSERT INTO Vertices VALUES (-69.9132614086578, ......... Did you figure this out I have the same question. I am able to use 3rd party tools, but I was hoping to do it with SQL Server Mgt Studio. Take a look at this http://www.elsasoft.org/too ...Show All

• Leon Mayne toggle all

  I have seen other places where this question is asked, but I am still not seeing the answer clearly. If I have many groups that are collapsed and I want to expand them all at the same time, it there a way to accomplish this Many talk about a param that can be passed in, but even if you have the parameter set, this is only for the initail state, is it not Woyler, you are correct. the image icons seem to be reversed. i have written a code for changin the image state based on the paramter passed. but it does not behave normally. howvever, if i write a code without applying the visibility setting as pointed out by Chris, it does work. is it some kind of bug in Reporting Services. ...Show All

• notec SQL Server Side Trace Application compatibility

  I am using sp_trace_getdata @TraceID,@RowCount to get generated events. I was able to extract all the events by this procedure in SQL Server 2000, but in 2005 when I execute same procedure with @RowCount = 1 as second parameter, it returns me the first event that is there in the event queue of trace and queue gets cleared, so all other events are lost i.e. every call to sp_trace_getdata is clearing up the queue. Is there any work around for this issue Some hidden argument Thanks, Pushkar Moving thread to DB engine Any information on this issue. Awaiting for the reply. Pushkar ...Show All

• erick_the_redd Does SQL SERVER MANAGEMENT come with Visual Studio Prof 2005?

  I'm following a video tutorial about SQL wherein I'm told to download SQL SERVER MANAGEMENT STUDIO EXPRESS. However I have just bought and installed the whole MS visual studio pro 2005 along with the SQL that comes with it. I'm afraid to download and install the SQL SERVER MANAGEMENT STUDIO in case it botches up my prg already installed. Can anyone tell me if this management tool is already installed along with the package I have (if so, where is it - not listed in programs) Thank you for your time. SQL Server 2005 Developer is included with the Pro VS, this includes the full version of the SQL Server Management Tools. In regards to the tutorial you are using the functions are exactly the same. ...Show All