Monday, September 23, 2013

[SQL Server] domain\server$

[SQL Server] domain\server$

domain\server$

Posted: 23 Sep 2013 05:34 AM PDT

Hi, SQL Server log shows several login failures from the login "domain\server$". What does that mean? I read somewhere that it means that the remote machine is using "network service" to run the service which is connecting to SQL Server. I don't understand what that means and if I need to change something or if the app team needs to make a change.Does the $ on the end indicate a system created object in AD?Thanks for reading.

Display the results of search in a DataGridView

Posted: 23 Sep 2013 12:26 PM PDT

Hi to all especially to those who always answer my questions wholeheartedly :-)I Have another question..and this is my Code.....============================================================set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo-- =============================================-- Author: <Author,,Name>-- Create date: <Create Date,,>-- Description: <Description,,>-- =============================================ALTER PROCEDURE [dbo].[SearchBiography] @firstname varchar(50), @middlename varchar(50), @lastname varchar(50), @sex varchar(50), @status varchar(50)-- @bioID int ASBEGIN SET NOCOUNT ON; DECLARE @SqlQuery varchar(max) , @SqlQueryFirstName varchar(max),@SqlQueryMiddleName varchar(max), @SqlQueryLastName varchar(max), @SqlQueryStatus varchar(max), @SqlQueryFullName varchar(max) SET @SqlQuery = '' IF LEN(@firstname) > 0 SET @SqlQueryFirstName = ' AND firstname like ''%' + @firstname + '%''' ELSE SET @SqlQueryFirstName = '' IF LEN(@middlename) > 0 SET @SqlQueryMiddleName = ' AND middlename like ''%' + @middlename + '&''' ELSE SET @SqlQueryMiddleName = '' IF LEN(@lastname) > 0 SET @SqlQueryLastName =' AND lastname like ''%' + @lastname + '%''' ELSE SET @SqlQueryLastName = '' SET @SqlQuery = 'SELECT * FROM TestMyView WHERE ' + ' sex like ''%' + @sex + '%''' + ' AND status like ''%' +@status + '%''' SET @SqlQuery = @SqlQuery + @SqlQueryFirstName + @SqlQueryMiddleName + @SqlQueryLastName + @SqlQueryStatus EXEC(@SqlQuery) PRINT(@SqlQuery)END===========================================================II already have a class in my front-end to call the SP(Stored Procedure)..but how can i display the result of the search on my dataGridViewI can simply do this ( TestMyViewTableAdapter.FillByAll(Me.BiographyDataBIOGRAPHY.TestMyView, SexBindingSource.Current("sex"), StatusBindingSource.Current("status"), txtbxFname.Text, txtbxMname.Text, txtbxLname.Text)) using dataset to display the result without using SP.... but i like to use SP, i want to code it since i am a newbie, so that i can appreciate on what is instant...Help me please :-( Thank you :-)See my UI Attachment

Create an Alert for ROW Size increase

Posted: 22 Sep 2013 11:44 PM PDT

Hi being a newbie, i have been asked by one of our Apps admin guys to create an alert that when a table rowsize gets to 90 rows to send him an email or log an event in system event viewer (windows server) I have written a small query which tells you how many rows there are but I am stuck as to how to get it to do something meaningful.Help!!!
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog