Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. justinmarkham

    Sql server help

    Also try: SELECt nt_username FROM master..sysprocesses WHERE spid = @@spid
  2. justinmarkham

    NT Authentication

    what version of SQL are you running?
  3. justinmarkham

    NT Authentication

    WHat about... SELECt nt_username FROM master..sysprocesses WHERE spid = @@spid Regards, Justin.
  4. justinmarkham

    Sql server help

    Have you tried setting up an NT group and setting the permissions in SQL server the same as the SQL login then tell your users to login via NT authentication instead of using SQL the SQL login. The best way to get them to do this is then to deny the permissions to the SQL login. Regards, Justin
  5. justinmarkham

    Sql server help

    Have you tried setting up an NT group and setting the permissions in SQL server the same as the SQL login then tell your users to login via NT authentication instead of using SQL the SQL login. The best way to get them to do this is then to deny the permissions to the SQL login.
  6. justinmarkham

    Mail without using Outlook/Exchange

    Hi there, I can reassure you it is possible to run SQL mail without running outlook as a an active program in the background. Are you running SQL service through the same account as the mail alias? Regards, Justin
  7. justinmarkham

    select * from @???

    Hi there, It will work but use single quotes: DECLARE @tabxxx sysname, @SQL nvarchar(1000) SET @tabxxx = 'TABLE_NAMExxx' SET @SQL = 'SELECT * FROM ' + @tabxxx EXEC(@SQL) Regards, Justin
  8. justinmarkham

    stdev in MDX

    Hi all, Has anyone here had any degree of success in using the stdev function in MS OLAP. I have a field already in the fact table which I would like to calculate the stdev as a measure, like if it was an aggregate function. However the formula stdev (SET [, Numeric Expression]) does seem to be...
  9. justinmarkham

    stdev function in MDX

    Hi all, Has anyone here had any degree of success in using the stdev function in MS OLAP. I have a field already in the fact table which I would like to calculate the stdev as a measure, like if it was an aggregate function. However the formula stdev (SET [, Numeric Expression]) does seem to be...

Part and Inventory Search

Back
Top