You searched for the word(s): userid:796767

More Search Options

RSS Available

• Re: The user is not associated with a trusted SQL Server connection Error

  As the previous poster said, in this case, you don't want trusted_connection=yes (= Windows Authentication). Just use username & password and remove the trusted_connection part from your query string. Regards Steve

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wisccal on 9/30/2008

• Re: The user is not associated with a trusted SQL Server connection Error

  Hi I don't quite understand why you're specifying Trusted_Connection=yes and still provide a user name and password. If you're using Windows Authentication for SQL Server, then there is no need for the latter two properties. Can you login through SSMS with Windows Authentication? Regards Steve

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wisccal on 9/28/2008

• Re: xquery returning one data row result only?

  Hi You probably want this: Select( "/root_node/XML_Child_Node/*[@p_family='" & prVal & "']/@pdt_des" ) Regards Steve

  Posted to XML and XmlDataSource Control (Forum) by wisccal on 9/16/2008

• Re: Check constraint to lock a row based on the value of a bit datatype column

  Hi If you need it to work for deletes, too, you just need to add a DELETE after the INSTEAD OF UPDATE. But I just noticed that my example doesn't check the bit value. You need something like this in the trigger: declare @cnt int ; SET @cnt = 0; SET @cnt = ( SELECT COUNT(*) FROM ( SELECT col1, col2 WHERE [locked?] = -1 EXCEPT SELECT col1, col2 WHERE [locked?] <> -1 OR [locked?] IS NULL ) sub ); IF (@cnt > 0) BEGIN RAISERROR( "not allowed" , 10, 1); END A check constraint doesn't

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wisccal on 9/9/2008

• Re: SQL for a hashed value? (md5/sha1)

  Not as far as I know. You can cast it to a nvarchar, of course: CAST(HASHBYTES('MD5','passwd') AS nvarchar(128)). But why don't you just store your hash as a varbinary in your VB code? The cryptography classes work on bytes, so why store them as strings? Regards Steve

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wisccal on 9/9/2008

• Re: Check constraint to lock a row based on the value of a bit datatype column

  Hi I'd use a trigger. Something like: CREATE TABLE MyTab(Id int IDENTITY (1,1) NOT NULL PRIMARY KEY , SomeValue varchar (50), SomeOtherValue int , Locked bit NOT NULL ); GO CREATE TRIGGER CheckLocked ON MyTab INSTEAD OF UPDATE AS IF ( UPDATE (SomeValue) OR UPDATE (SomeOtherValue)) BEGIN /* do something */ END GO Regards Steve

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wisccal on 9/9/2008

• Re: SQL for a hashed value? (md5/sha1)

  Hi Jenny The Hashbytes function returns a varbinary type. So, declaring your column as varbinary(128) instead of nvarchar(128) should make it work. Regards Steve

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wisccal on 9/9/2008

• Re: Evaluating Datatable Row..never true with Var...true with hard code!

  Hi Joel I think you want to use: HiddenField1.Value = RowTable(3).ToString() or HiddenField1.Value.Equals(RowTable(3)) Regards Steve

  Posted to Data Access and ObjectDataSource Control (Forum) by wisccal on 9/8/2008

• Re: what needs to be done so can let any users access my sql server db from a web application?

  Hi I might be wrong, but I believe you're confusing the security functionality provided by ASP.Net and the one by SQL Server. If you're using ASP.Net, which I presume considering that you're posting on this forum, you need to look into ASP.Net authentication and authorization. There's an out-of-the-box feature called ASP.Net Membership that does all the hard work for you. ASP.Net accesses SQL Server as a single process, so any permissions that you assign to this process's SQL

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wisccal on 9/6/2008

• Re: sp_MSdropconstraints does not work

  Hi Those sp's are internally used by MS and are not guaranteed to work. I recommend you construct the queries by selecting the constraint names from sys.key_constraints. Something like: SELECT 'alter table ' + object_name(parent_object_id) + ' drop constraint ' + object_name( object_id ) FROM sys.key_constraints WHERE is_ms_shipped = 0 Regards Steve

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wisccal on 9/6/2008