need to determine which db is pricipal

Database Mirroring

Index ‹ SQL Server

- Previous
  - 1
    - scheduled task not running I've looked at 'job history'...It has a constant result of 'failed'.When I look into the step details,the following message is written: Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed. It seems that I don't have enough permissions... Tag: need to determine which db is pricipal
  - 2
    - How do it right? I try to do conversation sending without any errors.And with clean sys.conversation_endpoints. There is my activation procedure code: Code Snippet SET NOCOUNT ON DECLARE @ConversationHandle UNIQUEIDENTIFIER DECLARE @ConversationGroupID UNIQUEIDENTIFIER DECLARE @MessageType NVARCHAR ( 126 ) DECLARE @Message VARBINARY ( MAX ) DECLARE @MessageXML XML ; WHILE ( 1 = 1 ) BEGIN SET @ConversationGroupID = NULL WAITFOR ( GET CONVERSATION GROUP @ConversationGroupID FROM [AGCapital/ServiceBroker/Queues/BrokerBug] ), TIMEOUT 1000 ; IF @ConversationGroupID IS NULL BEGIN BREAK END WHILE ( 1 = 1 ) BEGIN SET @MessageType = NULL SET @Message = NULL SET @ConversationHandle = NULL; RECEIVE TOP ( 1 ) @ConversationHandle = conversation_handle , @MessageType = message_type_name , @Message = message_body FROM [AGCapital/ServiceBroker/Queues/BrokerBug] WHERE conversation_group_id = @ConversationGroupID IF @@ROWCOUNT = 0 BEGIN BREAK END IF @MessageType = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog' OR @MessageType = 'AGCapital/ServiceBroker/Messages/Received' BEGIN END CONVERSATION @ConversationHandle ; BREAK END ELSE IF @MessageType = 'AGCapital/ServiceBroker/Messages/BrokerBug' BEGIN SET @MessageXML = CONVERT ( XML , @Message ); SEND ON CONVERSATION @ConversationHandle MESSAGE TYPE [AGCapital/ServiceBroker/Messages/Received] ; --do something BREAK END END END SET NOCOUNT OFF The code is identical on both services, Target and Iniciator. You can see, that it's work with it's own g aranteed delivering system - conversation endeds only when it's have confirmation of receiving mesage type AGCapital/ServiceBroker/Messages/BrokerBug' Looks like everything is rigth, but.. Profiler still show couple errors: on the Target server it is This message could not be delivered because the 'receive end conversation' action cannot be performed in the 'CLOSED' state. and on the iniciator An error occurred while receiving data: '64(error not found)'. Have you any ideas why it's happened Tag: need to determine which db is pricipal
  - 3
    - tabel scan Like I said, that it totally dependent on the design of your table and your query e.g. the indexes on the table and the where clause of your query. This really is a database question and not a reporting services question. Tag: need to determine which db is pricipal
  - 4
    - Cannot Load SQLSpars.dll SQL Server Setup log files are located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG Tag: need to determine which db is pricipal
  - 5
    - Strange thing in All examples at MSDN Hi, I have seen many examples at MSDN library related to SQL Querries in all queries one thing is same the way they use tables in there queries. BUT wht is this really i am not getting this, can anyone tell me.. the code and the problem is as follows: Code Snippet FROM Purchasing.ProductVendor JOIN Purchasing.Vendor ON (ProductVendor.VendorID = Vendor.VendorID) In the above code u see "Purchasing.ProductVendor", I want to ask that wht is this Purchasing Stands for, If we suppose that purxchasing is the database name then also normally we use database name as Purchasing.dbo.ProductVendor BUT I am not getting that what is this, Please if someone knows then explain it to me, Thanks. Tag: need to determine which db is pricipal
  - 6
    - SQL server database services option greyed out Which is the SQLServer edition u have. IF its Enterprise Edition, then u need server version of OS (windows 2000 svr sp4/2003 /vista etc) to install database services. You can only install client/workstation tool in XP. You can install other edition in XP. You can download SQL Express and install. Madhu Tag: need to determine which db is pricipal
  - 7
    - Where do I buy SQL Server Management Studio? Hi Jeffery, I`m not sure what you mean - you ask for Management Studio and there is a download link for SQL Server Management Studio Express . Or will you buy a SQL Server Standard, Enterprise or Datacenter Edition - then you have the "normal" SQL Server Management Studio. What do you want CU tosc Tag: need to determine which db is pricipal
  - 8
    - Sorting a table with numbers and letters I have renamed the numbers in the table (10 -> 0010) so all the numbers have 4 characters. Because I only need the numbers I have set a filter "BETWEEN 0 AND A". The sorting is no problem anymore. Tag: need to determine which db is pricipal
  - 9
    - Error with SMO.TransferData() (Exception from HRESULT: 0xC0011008) Euan, I recieved the same error when testing the code listed above but could not trace it. As soon as I switched my server connection method it worked without a hitch( I think I mention this in the sample.) so I do not know if this is as clear cut. Tag: need to determine which db is pricipal
  - 10
    - Can't uninstall SQL Server 2005 or install .NET 3.0 64bit after installing Office 2007 Well I had no response on the 64bit NET forum so I am posting here !! Windows Automatic Update has just failed to install .NET 3.0 (x64) WAU decided for itself that I needed this update Add Remove Programs reports the following (x64) programs ... .NET Framework 2.0 .NET Framework 2.0 SDK MS SQL SERVER 2005 VS2005 64bit prerequisites VS2005 64bit Remote Debugger MSinfo32 reports OS Name Microsoft(R) Windows(R) Server 2003 Standard x64 Edition Version 5.2.3790 Service Pack 2 Build 3790 Other OS Description R2 OS Manufacturer Microsoft Corporation System Name DEV-1 System Manufacturer Dell Inc. System Model Dell DXC051 System Type x64-based PC Processor EM64T Family 15 Model 6 Stepping 4 GenuineIntel ~3392 Mhz Processor EM64T Family 15 Model 6 Stepping 4 GenuineIntel ~3392 Mhz BIOS Version/Date Dell Inc. A05, 31/03/2006 BTW this is a fresh install because I was completely and utterly unable to uninstall SqlServer2005 which was necessitated by foolishly installing Office 2007 (Office 2003 being no longer available!) Tag: need to determine which db is pricipal
  - 11
    - Whats the different between SQL Express & SQL Server 2005? Hi, I'm working in a small company (less than 30 user), we can't buy MSSql Server 2005: Q1: can we use the Express edtion do access our data I mean for commersial purpose.. Q2: dose the Express edition stand to (30 connection) at the same time Q3: can I add users to it Tag: need to determine which db is pricipal
  - 12
    - SQL Server Management Studio Express on Vista Home Premium (Error on attaching and detaching .mdf) I'm using Windows Authentication. The user that I am using is an Administrator. The only thing I noticed is that in Management Studio -> Server Properties -> Permissions -> BUILTIN\Administrator Connect SQL is only granted to "sa" and not to "MyPC\MyUser". How can I grant 'Connect SQL' to 'MyPC\MyUser' Temporarily, I turn-off the User Access Control for my user, reboot the PC and everything works already. Tag: need to determine which db is pricipal
  - 13
    - SUM returns incorrect value in SQL Server Mobile Query ... Bug?? This might be a bug in our code. I have trouble reproducing the problem. Can you share the database (or just the schema) so that I can take a look. Thanks Pragya Tag: need to determine which db is pricipal
  - 14
    - Blocking in Analysis Services We have a report in Reporting Services that connects to a Cube. The report has 4 input parameters that are also derived from the same cube. If the report is running and another user tries to select the drop downs for the report or runs just the query portion in report designer, the query will not return until the report has finished. It looks like the report is creating some type of wait. Has anyone ran across something like this Tag: need to determine which db is pricipal
  - 15
    - converting varchar to int It is clearly an SQL error which cannot be solved in SSRS using expressions. I'm assuming that your dataset is formed by a stored procedure, not plain SQL text. The error is because you are trying to put an invalid integer value into a table (temporary table or user table) column which is of INT datatype. If possible, get the SQL text of the stored procedure and check all insert/update statements and all the columns of INT datatype involved in it. Also check If there is an implicit conversion using CONVERT or CAST function. Shyam Tag: need to determine which db is pricipal
  - 16
    - Error - The report server cannot decrypt the symmetric key? Incorrect. Only the ecrypted information will be nuked, i.e. connection credentials, connection strings, and any secure information stored in subscriptions 每 by default this is only username & password in File Share delivery extension. Tag: need to determine which db is pricipal
- Next
  - 1
    - Different ways to set DATEFIRST This thread may help with your pursuit. You 'hould' understand the implications. Every built-in function or procedure that has anything to do with WeekDay calculations or determinations will be affected, including week of year. Obviously, day of week determiniations, and most other datetime functions 'should NOT' be adversely affected. BUT test, test, test. Tag: need to determine which db is pricipal
  - 2
    - custom url not recognized i have this action.jumpto url = "javascript:void window.open('http://bklc-crm01:5555/cs/cases/edit.aspx id={" & cstr(Fields!incidentid.Value) & "}','_self')" for some reason when i use this field (incidentid.value) there is no hyperlink generated, however when i change the value to another field, the hyperlink works, what shall i be looking for, incident value is a set of number with dashes! Tag: need to determine which db is pricipal
  - 3
    - Only able to access Report Manager as Administrator There are three types of Authentification in Reporting Services: 1) Integrated Windows Authentification (Active Directory aware) is the default authentification method for the Report Server and Report Manager virtual directories. 2) Anonymous access (only suggested if used with security extensions). Anonymous access limites your ability to vary role assignment because all users will access the Report Server under the Anonymous user account. 3) Basic Authentification, which should only be used with a Secure Sockets Layer (SSL) connection because Basic Authentification sends username and passwords to the server in clear text, which could be picked up with a network sniffer. The Integrated Windows Authentification method is preferred and widely used. Your network administrator can setup Active Directory groups on the Domain Controller, which you can then grant those groups access to Reporting Services. If you network users have Unix, Mac, Novell or Linux accounts (non-Windows accounts) then you will need to go with Forms Authentification. Forms Authentification directs a request from an unauthenticated user to an HTML form, where they are prompted to enter a username and password. I have not used this method but many in this forum have and a quick search of the forum should return several useful posts. Tag: need to determine which db is pricipal
  - 4
    - SQL Agent Roles IF the SQLAgent is not a part of sysadmin and that job is created by SA or any other login with SYSADMIN privileges then that login may not be able to modify the job as it is owned by SA. As referred in the article try to set the login under that role. Tag: need to determine which db is pricipal
  - 5
    - error for sending(saving) data to database Form1.designer.cs namespace student { partial class Form1 { /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel. IContainer components = null ; /// <summary> /// Clean up any resources being used. /// </summary> /// <param name="disposing"> true if managed resources should be disposed; otherwise, false. </param> protected override void Dispose( bool disposing) { if (disposing && (components != null )) { components.Dispose(); } base .Dispose(disposing); } #region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this .components = new System.ComponentModel. Container (); System.ComponentModel. ComponentResourceManager resources = new System.ComponentModel. ComponentResourceManager ( typeof ( Form1 )); System.Windows.Forms. Label s_IDLabel; System.Windows.Forms. Label s_NAMELabel; System.Windows.Forms. Label s_ADDRESSLabel; System.Windows.Forms. Label s_PHONELabel; this .studentDataSet = new student. studentDataSet (); this .sTUDENTBindingSource = new System.Windows.Forms. BindingSource ( this .components); this .sTUDENTTableAdapter = new student.studentDataSetTableAdapters. STUDENTTableAdapter (); this .sTUDENTBindingNavigator = new System.Windows.Forms. BindingNavigator ( this .components); this .bindingNavigatorMoveFirstItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorMovePreviousItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorSeparator = new System.Windows.Forms. ToolStripSeparator (); this .bindingNavigatorPositionItem = new System.Windows.Forms. ToolStripTextBox (); this .bindingNavigatorCountItem = new System.Windows.Forms. ToolStripLabel (); this .bindingNavigatorSeparator1 = new System.Windows.Forms. ToolStripSeparator (); this .bindingNavigatorMoveNextItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorMoveLastItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorSeparator2 = new System.Windows.Forms. ToolStripSeparator (); this .bindingNavigatorAddNewItem = new System.Windows.Forms. ToolStripButton (); this .bindingNavigatorDeleteItem = new System.Windows.Forms. ToolStripButton (); this .sTUDENTBindingNavigatorSaveItem = new System.Windows.Forms. ToolStripButton (); this .s_IDTextBox = new System.Windows.Forms. TextBox (); this .s_NAMETextBox = new System.Windows.Forms. TextBox (); this .s_ADDRESSTextBox = new System.Windows.Forms. TextBox (); this .s_PHONETextBox = new System.Windows.Forms. TextBox (); this .sqlConnection1 = new System.Data.SqlClient. SqlConnection (); this .sqlCommand1 = new System.Data.SqlClient. SqlCommand (); this .sqlSelectCommand1 = new System.Data.SqlClient. SqlCommand (); this .sqlInsertCommand1 = new System.Data.SqlClient. SqlCommand (); this .sqlDataAdapter1 = new System.Data.SqlClient. SqlDataAdapter (); s_IDLabel = new System.Windows.Forms. Label (); s_NAMELabel = new System.Windows.Forms. Label (); s_ADDRESSLabel = new System.Windows.Forms. Label (); s_PHONELabel = new System.Windows.Forms. Label (); ((System.ComponentModel. ISupportInitialize )( this .studentDataSet)).BeginInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingSource)).BeginInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingNavigator)).BeginInit(); this .sTUDENTBindingNavigator.SuspendLayout(); this .SuspendLayout(); // // studentDataSet // this .studentDataSet.DataSetName = "studentDataSet" ; this .studentDataSet.SchemaSerializationMode = System.Data. SchemaSerializationMode .IncludeSchema; // // sTUDENTBindingSource // this .sTUDENTBindingSource.DataMember = "STUDENT" ; this .sTUDENTBindingSource.DataSource = this .studentDataSet; // // sTUDENTTableAdapter // this .sTUDENTTableAdapter.ClearBeforeFill = true ; // // sTUDENTBindingNavigator // this .sTUDENTBindingNavigator.AddNewItem = this .bindingNavigatorAddNewItem; this .sTUDENTBindingNavigator.BindingSource = this .sTUDENTBindingSource; this .sTUDENTBindingNavigator.CountItem = this .bindingNavigatorCountItem; this .sTUDENTBindingNavigator.DeleteItem = this .bindingNavigatorDeleteItem; this .sTUDENTBindingNavigator.Items.AddRange( new System.Windows.Forms. ToolStripItem [] { this .bindingNavigatorMoveFirstItem, this .bindingNavigatorMovePreviousItem, this .bindingNavigatorSeparator, this .bindingNavigatorPositionItem, this .bindingNavigatorCountItem, this .bindingNavigatorSeparator1, this .bindingNavigatorMoveNextItem, this .bindingNavigatorMoveLastItem, this .bindingNavigatorSeparator2, this .bindingNavigatorAddNewItem, this .bindingNavigatorDeleteItem, this .sTUDENTBindingNavigatorSaveItem}); this .sTUDENTBindingNavigator.Location = new System.Drawing. Point (0, 0); this .sTUDENTBindingNavigator.MoveFirstItem = this .bindingNavigatorMoveFirstItem; this .sTUDENTBindingNavigator.MoveLastItem = this .bindingNavigatorMoveLastItem; this .sTUDENTBindingNavigator.MoveNextItem = this .bindingNavigatorMoveNextItem; this .sTUDENTBindingNavigator.MovePreviousItem = this .bindingNavigatorMovePreviousItem; this .sTUDENTBindingNavigator.Name = "sTUDENTBindingNavigator" ; this .sTUDENTBindingNavigator.PositionItem = this .bindingNavigatorPositionItem; this .sTUDENTBindingNavigator.Size = new System.Drawing. Size (463, 25); this .sTUDENTBindingNavigator.TabIndex = 0; this .sTUDENTBindingNavigator.Text = "bindingNavigator1" ; // // bindingNavigatorMoveFirstItem // this .bindingNavigatorMoveFirstItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMoveFirstItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMoveFirstItem.Image" ))); this .bindingNavigatorMoveFirstItem.Name = "bindingNavigatorMoveFirstItem" ; this .bindingNavigatorMoveFirstItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveFirstItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMoveFirstItem.Text = "Move first" ; // // bindingNavigatorMovePreviousItem // this .bindingNavigatorMovePreviousItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMovePreviousItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMovePreviousItem.Image" ))); this .bindingNavigatorMovePreviousItem.Name = "bindingNavigatorMovePreviousItem" ; this .bindingNavigatorMovePreviousItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMovePreviousItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMovePreviousItem.Text = "Move previous" ; // // bindingNavigatorSeparator // this .bindingNavigatorSeparator.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator.Size = new System.Drawing. Size (6, 25); // // bindingNavigatorPositionItem // this .bindingNavigatorPositionItem.AccessibleName = "Position" ; this .bindingNavigatorPositionItem.AutoSize = false ; this .bindingNavigatorPositionItem.Name = "bindingNavigatorPositionItem" ; this .bindingNavigatorPositionItem.Size = new System.Drawing. Size (50, 21); this .bindingNavigatorPositionItem.Text = "0" ; this .bindingNavigatorPositionItem.ToolTipText = "Current position" ; // // bindingNavigatorCountItem // this .bindingNavigatorCountItem.Name = "bindingNavigatorCountItem" ; this .bindingNavigatorCountItem.Size = new System.Drawing. Size (36, 22); this .bindingNavigatorCountItem.Text = "of {0}" ; this .bindingNavigatorCountItem.ToolTipText = "Total number of items" ; // // bindingNavigatorSeparator1 // this .bindingNavigatorSeparator1.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator1.Size = new System.Drawing. Size (6, 25); // // bindingNavigatorMoveNextItem // this .bindingNavigatorMoveNextItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMoveNextItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMoveNextItem.Image" ))); this .bindingNavigatorMoveNextItem.Name = "bindingNavigatorMoveNextItem" ; this .bindingNavigatorMoveNextItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveNextItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMoveNextItem.Text = "Move next" ; // // bindingNavigatorMoveLastItem // this .bindingNavigatorMoveLastItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorMoveLastItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorMoveLastItem.Image" ))); this .bindingNavigatorMoveLastItem.Name = "bindingNavigatorMoveLastItem" ; this .bindingNavigatorMoveLastItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorMoveLastItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorMoveLastItem.Text = "Move last" ; // // bindingNavigatorSeparator2 // this .bindingNavigatorSeparator2.Name = "bindingNavigatorSeparator" ; this .bindingNavigatorSeparator2.Size = new System.Drawing. Size (6, 25); // // bindingNavigatorAddNewItem // this .bindingNavigatorAddNewItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorAddNewItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorAddNewItem.Image" ))); this .bindingNavigatorAddNewItem.Name = "bindingNavigatorAddNewItem" ; this .bindingNavigatorAddNewItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorAddNewItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorAddNewItem.Text = "Add new" ; // // bindingNavigatorDeleteItem // this .bindingNavigatorDeleteItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .bindingNavigatorDeleteItem.Image = ((System.Drawing. Image )(resources.GetObject( "bindingNavigatorDeleteItem.Image" ))); this .bindingNavigatorDeleteItem.Name = "bindingNavigatorDeleteItem" ; this .bindingNavigatorDeleteItem.RightToLeftAutoMirrorImage = true ; this .bindingNavigatorDeleteItem.Size = new System.Drawing. Size (23, 22); this .bindingNavigatorDeleteItem.Text = "Delete" ; // // sTUDENTBindingNavigatorSaveItem // this .sTUDENTBindingNavigatorSaveItem.DisplayStyle = System.Windows.Forms. ToolStripItemDisplayStyle .Image; this .sTUDENTBindingNavigatorSaveItem.Image = ((System.Drawing. Image )(resources.GetObject( "sTUDENTBindingNavigatorSaveItem.Image" ))); this .sTUDENTBindingNavigatorSaveItem.Name = "sTUDENTBindingNavigatorSaveItem" ; this .sTUDENTBindingNavigatorSaveItem.Size = new System.Drawing. Size (23, 22); this .sTUDENTBindingNavigatorSaveItem.Text = "Save Data" ; this .sTUDENTBindingNavigatorSaveItem.Click += new System. EventHandler ( this .sTUDENTBindingNavigatorSaveItem_Click); // // s_IDLabel // s_IDLabel.AutoSize = true ; s_IDLabel.Location = new System.Drawing. Point (44, 52); s_IDLabel.Name = "s_IDLabel" ; s_IDLabel.Size = new System.Drawing. Size (31, 13); s_IDLabel.TabIndex = 1; s_IDLabel.Text = "S ID:" ; // // s_IDTextBox // this .s_IDTextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_ID" , true )); this .s_IDTextBox.Location = new System.Drawing. Point (81, 49); this .s_IDTextBox.Name = "s_IDTextBox" ; this .s_IDTextBox.Size = new System.Drawing. Size (100, 20); this .s_IDTextBox.TabIndex = 2; // // s_NAMELabel // s_NAMELabel.AutoSize = true ; s_NAMELabel.Location = new System.Drawing. Point (51, 91); s_NAMELabel.Name = "s_NAMELabel" ; s_NAMELabel.Size = new System.Drawing. Size (51, 13); s_NAMELabel.TabIndex = 3; s_NAMELabel.Text = "S NAME:" ; // // s_NAMETextBox // this .s_NAMETextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_NAME" , true )); this .s_NAMETextBox.Location = new System.Drawing. Point (108, 88); this .s_NAMETextBox.Name = "s_NAMETextBox" ; this .s_NAMETextBox.Size = new System.Drawing. Size (100, 20); this .s_NAMETextBox.TabIndex = 4; // // s_ADDRESSLabel // s_ADDRESSLabel.AutoSize = true ; s_ADDRESSLabel.Location = new System.Drawing. Point (49, 122); s_ADDRESSLabel.Name = "s_ADDRESSLabel" ; s_ADDRESSLabel.Size = new System.Drawing. Size (72, 13); s_ADDRESSLabel.TabIndex = 5; s_ADDRESSLabel.Text = "S ADDRESS:" ; // // s_ADDRESSTextBox // this .s_ADDRESSTextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_ADDRESS" , true )); this .s_ADDRESSTextBox.Location = new System.Drawing. Point (127, 119); this .s_ADDRESSTextBox.Name = "s_ADDRESSTextBox" ; this .s_ADDRESSTextBox.Size = new System.Drawing. Size (100, 20); this .s_ADDRESSTextBox.TabIndex = 6; // // s_PHONELabel // s_PHONELabel.AutoSize = true ; s_PHONELabel.Location = new System.Drawing. Point (77, 160); s_PHONELabel.Name = "s_PHONELabel" ; s_PHONELabel.Size = new System.Drawing. Size (58, 13); s_PHONELabel.TabIndex = 7; s_PHONELabel.Text = "S PHONE:" ; // // s_PHONETextBox // this .s_PHONETextBox.DataBindings.Add( new System.Windows.Forms. Binding ( "Text" , this .sTUDENTBindingSource, "S_PHONE" , true )); this .s_PHONETextBox.Location = new System.Drawing. Point (141, 157); this .s_PHONETextBox.Name = "s_PHONETextBox" ; this .s_PHONETextBox.Size = new System.Drawing. Size (100, 20); this .s_PHONETextBox.TabIndex = 8; // // sqlConnection1 // this .sqlConnection1.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=\"C:\\Documents and Settings\\Glad\\Desktop" + "\\student\\student\\student.mdf\";Integrated Security=True;User Instance=True" ; this .sqlConnection1.FireInfoMessageEventOnUserErrors = true ; this .sqlConnection1.StatisticsEnabled = true ; // // sqlCommand1 // this .sqlCommand1.Parameters.AddRange( new System.Data.SqlClient. SqlParameter [] { new System.Data.SqlClient. SqlParameter ( "@S_ID" , System.Data. SqlDbType .Int, 0, System.Data. ParameterDirection .Output, false , (( byte )(0)), (( byte )(0)), "" , System.Data. DataRowVersion .Current, null ), new System.Data.SqlClient. SqlParameter ( "@S_NAME" , System.Data. SqlDbType .VarChar), new System.Data.SqlClient. SqlParameter ( "@S_ADDRESS" , System.Data. SqlDbType .VarChar), new System.Data.SqlClient. SqlParameter ( "@S_PHONE" , System.Data. SqlDbType .Text)}); // // sqlSelectCommand1 // this .sqlSelectCommand1.CommandText = "SELECT S_ID, S_NAME, S_ADDRESS, S_PHONE\r\nFROM STUDENT" ; this .sqlSelectCommand1.Connection = this .sqlConnection1; // // sqlInsertCommand1 // this .sqlInsertCommand1.CommandText = "INSERT INTO [STUDENT] ([S_ID], [S_NAME], [S_ADDRESS], [S_PHONE]) VALUES (@S_ID, @" + "S_NAME, @S_ADDRESS, @S_PHONE)" ; this .sqlInsertCommand1.Connection = this .sqlConnection1; this .sqlInsertCommand1.Parameters.AddRange( new System.Data.SqlClient. SqlParameter [] { new System.Data.SqlClient. SqlParameter ( "@S_ID" , System.Data. SqlDbType .Int, 0, "S_ID" ), new System.Data.SqlClient. SqlParameter ( "@S_NAME" , System.Data. SqlDbType .VarChar, 0, "S_NAME" ), new System.Data.SqlClient. SqlParameter ( "@S_ADDRESS" , System.Data. SqlDbType .VarChar, 0, "S_ADDRESS" ), new System.Data.SqlClient. SqlParameter ( "@S_PHONE" , System.Data. SqlDbType .Text, 0, "S_PHONE" )}); // // sqlDataAdapter1 // this .sqlDataAdapter1.InsertCommand = this .sqlInsertCommand1; this .sqlDataAdapter1.SelectCommand = this .sqlSelectCommand1; this .sqlDataAdapter1.TableMappings.AddRange( new System.Data.Common. DataTableMapping [] { new System.Data.Common. DataTableMapping ( "Table" , "STUDENT" , new System.Data.Common. DataColumnMapping [] { new System.Data.Common. DataColumnMapping ( "S_ID" , "S_ID" ), new System.Data.Common. DataColumnMapping ( "S_NAME" , "S_NAME" ), new System.Data.Common. DataColumnMapping ( "S_ADDRESS" , "S_ADDRESS" ), new System.Data.Common. DataColumnMapping ( "S_PHONE" , "S_PHONE" )})}); // // Form1 // this .AutoScaleDimensions = new System.Drawing. SizeF (6F, 13F); this .AutoScaleMode = System.Windows.Forms. AutoScaleMode .Font; this .ClientSize = new System.Drawing. Size (463, 266); this .Controls.Add(s_PHONELabel); this .Controls.Add( this .s_PHONETextBox); this .Controls.Add(s_ADDRESSLabel); this .Controls.Add( this .s_ADDRESSTextBox); this .Controls.Add(s_NAMELabel); this .Controls.Add( this .s_NAMETextBox); this .Controls.Add(s_IDLabel); this .Controls.Add( this .s_IDTextBox); this .Controls.Add( this .sTUDENTBindingNavigator); this .Name = "Form1" ; this .Text = "Form1" ; this .Load += new System. EventHandler ( this .Form1_Load); ((System.ComponentModel. ISupportInitialize )( this .studentDataSet)).EndInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingSource)).EndInit(); ((System.ComponentModel. ISupportInitialize )( this .sTUDENTBindingNavigator)).EndInit(); this .sTUDENTBindingNavigator.ResumeLayout( false ); this .sTUDENTBindingNavigator.PerformLayout(); this .ResumeLayout( false ); this .PerformLayout(); } #endregion private studentDataSet studentDataSet; private System.Windows.Forms. BindingSource sTUDENTBindingSource; private student.studentDataSetTableAdapters. STUDENTTableAdapter sTUDENTTableAdapter; private System.Windows.Forms. BindingNavigator sTUDENTBindingNavigator; private System.Windows.Forms. ToolStripButton bindingNavigatorAddNewItem; private System.Windows.Forms. ToolStripLabel bindingNavigatorCountItem; private System.Windows.Forms. ToolStripButton bindingNavigatorDeleteItem; private System.Windows.Forms. ToolStripButton bindingNavigatorMoveFirstItem; private System.Windows.Forms. ToolStripButton bindingNavigatorMovePreviousItem; private System.Windows.Forms. ToolStripSeparator bindingNavigatorSeparator; private System.Windows.Forms. ToolStripTextBox bindingNavigatorPositionItem; private System.Windows.Forms. ToolStripSeparator bindingNavigatorSeparator1; private System.Windows.Forms. ToolStripButton bindingNavigatorMoveNextItem; private System.Windows.Forms. ToolStripButton bindingNavigatorMoveLastItem; private System.Windows.Forms. ToolStripSeparator bindingNavigatorSeparator2; private System.Windows.Forms. ToolStripButton sTUDENTBindingNavigatorSaveItem; private System.Windows.Forms. TextBox s_IDTextBox; private System.Windows.Forms. TextBox s_NAMETextBox; private System.Windows.Forms. TextBox s_ADDRESSTextBox; private System.Windows.Forms. TextBox s_PHONETextBox; private System.Data.SqlClient. SqlConnection sqlConnection1; private System.Data.SqlClient. SqlCommand sqlCommand1; private System.Data.SqlClient. SqlCommand sqlSelectCommand1; private System.Data.SqlClient. SqlCommand sqlInsertCommand1; private System.Data.SqlClient. SqlDataAdapter sqlDataAdapter1; } } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// form1.cs using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Text; using System.Windows.Forms; namespace student { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void sTUDENTBindingNavigatorSaveItem_Click( object sender, EventArgs e) { sqlConnection1.Open(); sqlDataAdapter1.InsertCommand.CommandText= "INSERT INTO STUDENT (" + "S_ID, S_NAME, S_ADDRESS, S_PHONE" + ") VALUES ('" + s_IDTextBox.Text + "', '" + s_NAMETextBox.Text + "', '" + s_ADDRESSTextBox.Text + "', '" + s_PHONETextBox.Text + "')" ; sqlDataAdapter1.InsertCommand.ExecuteNonQuery(); sqlConnection1.Close(); this .Validate(); this .sTUDENTBindingSource.EndEdit(); this .sTUDENTTableAdapter.Update( this .studentDataSet.STUDENT); } private void Form1_Load( object sender, EventArgs e) { this .sTUDENTTableAdapter.Fill( this .studentDataSet.STUDENT); } } } Tag: need to determine which db is pricipal
  - 6
    - How to migrate from MySQL 4.1 to MS SQL Express 2005 I am trying to migrate from MySQL 4.1 to MS SQL Express 2005 1. do i need to create an empty db under Express 2. can this be done from within Express by pulling from MySQL into Express or do I need to work from command lines 3. what would be the cleanest way to approach this I have a MySQL dump and did look at the result from within Express, but it was not an import, I would like to find a way to import if possible that data. Table by table would be fine. Tag: need to determine which db is pricipal
  - 7
    - Parent - Multiple Child Package Execution Could you use two Execute Package tasks, one configured for executing on the file system, the other for the database Then use precedence constraints to control which one executes. So you'd pass in two variables - one being the connection to the package, the other setting a variable that controls which package executes. Tag: need to determine which db is pricipal
  - 8
    - msdb restore on new server One more thing. According to this (reference http://support.microsoft.com/kb/915845 ): ... -- Find the jobs to update. These jobs must match all of the input -- criteria, unless all of the inputs are null. In this case, -- examine all jobs. The jobs must also be jobs created locally, -- such as sysjobs.originating_server_id = 0 . These jobs should not be a job that we run -- because another server told us to. Furthermore, if the job -- is local but it is meant to be run on a target server, we send an -- update for the job. declare @jobsToUpdate TABLE (job_id uniqueidentifier not null) insert into @jobsToUpdate select job_id from sysjobs where originating_server_id = 0 -- local jobs and ((COALESCE(@job_name, sysjobs.name) = sysjobs.name) and (COALESCE(@job_id, sysjobs.job_id) = sysjobs.job_id) and (COALESCE(@owner_name, suser_sname(sysjobs.owner_sid)) = suser_sname(sysjobs.owner_sid))) ... The originating_server_id's in sysjobs on SQL_TEST is already 0 (local jobs). If anyone has any details on how to script the Maintenance Plans then please let me know. Thanks, Mark Tabash Tag: need to determine which db is pricipal
  - 9
    - Some things about SMO Hello, Which version of SQL Server are you using ( no Job Agent with SQL Server Express ) Have a nice day Tag: need to determine which db is pricipal
  - 10
    - Add hidden field to report I was able to resolve this by using the rowcount function, and just specifying the previous list as the scope to count. Tag: need to determine which db is pricipal
  - 11
    - Making Reports Customizeable for Users on a .NET site We are doing the same thing, using IFrames with the report displayed in the IFrame. We did some custom code to facilitate the moving around of the frames within a page. This really would not be 1 report, but a web page with multiple reports being displayed in multiple IFrames. HtH BobP Tag: need to determine which db is pricipal
  - 12
    - Connections through a server alias, IP address, or any other alternate name are not supported. Hi Ziad, Can you explain what you did exactly did you create the following: 1-create alisan name : mysecondserver 2-port: by default empty , you need to specify the port in case you have firewall issue. 3-protocol: TCP/IP or other.. 4-server: IP\instance_name NB: to be sure about server name on the second server select @@servername in query window on the second server. If you still cannot connect , please send me a direct email, you can find it on my site and i will try to discuss it with you. Tarek Ghazali SQL Server MVP http://www.sqlmvp.com Tag: need to determine which db is pricipal
  - 13
    - How to deliver a report dynamically based on the dataset with standard edition? I don't see a reason why this shouldn't work. You can write a script task to call down to the SSRS web service and request the report by invoking the Render method . Tag: need to determine which db is pricipal
  - 14
    - Design table need help Isn't this a self-referential ParentID relationship You can do it all in one table (I think): tbProject ProjectID int IDENTITY (1,1) (PK) ProjectName nvarchar(255) ParentProjectID int NOT NULL (FK --> projectID) TopLevelProjectID int NOT NULL (FK --> ProjectID) Requirement nvarchar(255) Create a project, it gets ProjectID = 1, and since it has no Parent, it's ParentID = 1 that means that it's a Top-Level project, so it's TopLevelProjectID = 1. A sub project would have ProjectID = 2 (or whatever the next avilable ID is), a ParentProjectID = 1, and a TopLevelProjectID = 1. And, if this sub had a sub, then: ProjectID = 3 (or next available ID) ParentID = 2 ('cause that's one level UP from this project) TopLevelProjectID = 1 ('cuase that the top of the tree from this project) With this, you can use something like: Update Set REquirment = Requirment + " SOME NEW STRING " where TopLevelProject = 1 Code Block create table #Projects ( ProjectID int identity ( 1 , 1 ) , ParentID int , TopLevelID int , ProjectName varchar ( 255 ) , ProjectRequirement varchar ( 255 ) ) insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 1' , 1 , 1 , 'some thing or other' insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 2' , 2 , 2 , 'do this now' insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 3' , 3 , 3 , ' FOOBAR the 3rd' insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 1: Sub A' , 1 , 1 insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 2: Sub A' , 2 , 2 insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 1: Sub B' , 1 , 1 , 'Hey, here''s another one!!' insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 1: Sub A: Sub i' , 4 , 1 insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 1: Sub A: Sub ii' , 4 , 1 insert into #Projects ( ProjectName , ParentID , TopLevelID , ProjectRequirement ) select 'Project # 1: Sub A: Sub ii: Sub a:' , 8 , 1 , 'Do it. Do it now!' insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 3: Sub A' , 3 , 3 insert into #Projects ( ProjectName , ParentID , TopLevelID ) select 'Project # 3: Sub A: Sub i' , 10 , 3 ; with CTE as ( select ProjectName as [ProjectName] , ProjectName as [ParentProject] , ProjectName as [TopLevelProject] , convert ( varchar ( 4000 ), IsnUll ( ProjectRequirement , '' )) as [REQ] , ProjectID from #Projects where TopLevelID = ProjectID union all select P . ProjectName , cte . [ProjectName] , cte . [TopLevelProject] , convert ( varchar ( 4000 ), CTE . REQ + ': ' + isnull ( ProjectRequirement , '' )), p . ProjectID from CTE inner join #Projects P on P . ParentID = cte . ProjectID where P . ProjectID <> p . ParentID and p . ProjectID <> p . TopLevelID ) select * from CTE order by TopLevelProject , ParentProject drop table #Projects Tag: need to determine which db is pricipal
  - 15
    - Estimating hardware requirements for a SQL Server 2005 installation Is there any good online documentation describing rules of thumb for estimating and planning a SQL Server 2005 deployment in support of a Windows rich client/WCF services architecture TIA, Ian Tag: need to determine which db is pricipal
  - 16
    - Online/Offline Application that must synchronize with SQL 2005 Hi ! I must developp a WPF Application with online and offline capabilities! First I think to use XML file on the local application and transfer these XML files to a webservice that will synchronize them with the SQL 2005 Server BUT I read about "Replication"... and I think it will be much simpler to implement!!! Do you think it is a good idea to have a "local" SQL Express database and replicate it (when connection available is) with the principal database that will run a standard SQL 2005 version! Do you have another suggestion to make such an application Thanks for help!!! PlaTyPuS PS: when the sql express solution a good idea is, does it give a simple solution to programm an automatic synchronization every hour Tag: need to determine which db is pricipal

Ofirb

Hi All,

i am working with database mirroring and i need to be able to determine which database will be principal.

for example if server A is principle and server B is mirrored and server A is down, then server B take owner and become principle, after fixing server A i want it to be principle again,

is it possible

Top

Re: need to determine which db is pricipal

Ofirb

Hi,

i find the solution !!!!

on the mirroring properties just push on FAILOVER !!!!

WELL DONE BILL

Top

Re: need to determine which db is pricipal

agustin_m

I would like to do the same thing, can you please explain your solution Thanks!

-Agustin

Top

Re: need to determine which db is pricipal

Deepak Rangarajan

hey i did the following....Srv 1 was principal and Srv 2 was mirror....i just stopped sql services in principal and it immediately failed over to mirror coz i was having witness server......now the original principal became new mirror and original mirror became new principal...again inorder to revert back to original state i went to the db properties of the new principal and clicked failover ......immediately the new mirror reverted to original principal and new principal became original mirror........the same can also be done using T-SQL statements......sounds cool.........

Alter database DBName

set partner failover

run it you'll get it.........

Top