Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: SQL Server job sites

    Steve Jones - Editor (7/27/2008)

    Dice and Monster are very popular with recruiters, who list most of the jobs. Some private individuals on Monster. not sure if JustSQLserverJobs.com is still out...

    July 27, 2008 at 10:55 pm

    #848954

  • RE: Using a temporary table

    Sandy (7/21/2008)

    lallen (7/21/2008)

    --------------------------------------------------------------------------------

    I've created a temporary table using select into statement, and called the table #Table1 (for example). But I can't get the syntax right to pull the information...

    July 22, 2008 at 3:22 am

    #846243

  • RE: SQL Server logins

    rinu philip (7/22/2008)

    vanessab (7/22/2008)

    Try :

    sp_helplogins 'LoginName'

    thats true..you could also use :

    sp_helpuser youruserid

    🙂

    Thanks aton rinu..it worked ...koooolll

    July 22, 2008 at 3:12 am

    #846238

  • RE: SQL Server logins

    GilaMonster (7/21/2008)

    For server-level permissions, you can query sys.server_permissions and sys.server_principals thusly

    SELECT NAME, permission_name, state_desc

    FROM sys.server_permissions sp

    INNER JOIN sys.server_principals pri ON sp.grantee_principal_id =...

    July 21, 2008 at 5:23 am

    #845682

  • RE: No reason

    vidhya sagar (7/21/2008)

    [font="Verdana"]Check out the below KB article to create an alias for the destination server.

    http://msdn.microsoft.com/en-us/library/ms190445.aspx[/font]

    thanks a lot, I had a look and seems interesting..

    btw..do you have any idea of...

    July 21, 2008 at 5:02 am

    #845666

  • RE: SQL Server logins

    Ramesh (7/21/2008)

    Check for the system table sys.fn_my_permissions OR sys.fn_builtin_permissions

    SELECT * FROM sys.fn_my_permissions( NULL,'database' )

    thanks for the quick reply..however when I excuted the above script, I didnt get any records. moreover...

    July 21, 2008 at 4:57 am

    #845664

  • RE: returning non-english data from sqlclr

    Hi could any other language data be fed through sql server?? for example french text?? will the data be stored in french??

    July 21, 2008 at 2:10 am

    #845596

  • RE: SSIS temporary storage

    what is the major difference between dts and ssis packages??

    July 21, 2008 at 2:08 am

    #845595

  • RE: Use of SQL Server Profiler

    vidhya sagar (7/20/2008)

    Check out the link below

    http://msdn.microsoft.com/en-us/library/ms190176.aspx

    Hi I am pretty new to sql server, what is the use of profiler??

    July 21, 2008 at 2:05 am

    #845594

  • RE: No reason

    vidhya sagar (7/20/2008)

    [font="Verdana"]Try creating an alias in the source server to point destination server with correct port and then try creating the linked server.[/font]

    what is an alias server??

    July 21, 2008 at 2:04 am

    #845592

Viewing 10 posts - 1 through 10 (of 10 total)