Forum Replies Created

Viewing 15 posts - 5,026 through 5,040 (of 13,460 total)

  • RE: Linked server permissions for a sql user

    Sapen (8/7/2012)

    Mine is setup the same way as shown in the image. But what permissions are you referring to? the user is a sysadmin on SQLServer but should it have...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2012 at 9:55 am

    #1522690

  • RE: session limiting for a particular user or for all users

    sql-noob (8/7/2012)

    how to limit a session for a user for 30 minutes after which he automatically gets disconnected and has to connect again?????

    also are you looking for session time outs,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2012 at 9:01 am

    #1522659

  • RE: Linked server permissions for a sql user

    it probably depends on how you set up the linked server;

    you can use the current login and pass it to the other server, if they have permissions, or you can...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2012 at 8:57 am

    #1522657

  • RE: How to order by month which is varchar field according to date format?

    any solution is going to involve some sort of convert text to date , or a hard coded CASE statement int he order by.

    can you fix the incoming data to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2012 at 8:02 am

    #1522617

  • RE: Hectic Key Combination Shortcuts (Ctrl+K and ++)!

    I've got 2012, and it looks to me like i can assign or replace keyboard shortcuts no problem.

    Tools>> Options>> Keyboard might have a slightly different layout, but it's there for...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2012 at 5:49 am

    #1522519

  • RE: Show Right Column to Right User

    ahh, but with column level permissions, you get errors that says user does not have permission to object:column, instead of empty values.

    it depends on what the OP wants in that...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2012 at 5:39 am

    #1522515

  • RE: Open port?

    that sql server should not be exposed to the internet, but simply accessible to the webserver; only the web server would have an outward facing ip.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 7, 2012 at 4:49 am

    #1522498

  • RE: How to read data in a pdf file in SSIS

    without a programming language? i more than just doubt it; i think that will be the only way to do it.

    check out this thread over on stackoverflow:

    read pdf files programatrically

    lots...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 6, 2012 at 2:55 pm

    #1522304

  • RE: Migration of Database from SQL server 2005 to SQL server 2005

    i have this saved in my snippets as a DR framework from a post that appeared on SSC fairly recently...I thought Simon provided a pretty good list of things to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 6, 2012 at 12:41 pm

    #1522238

  • RE: No blocking, queries running slowly, what to check next?

    I'd start with slow running queries;

    if you cannot change the app code, you might at least add indexes that will help.

    here's a query for the top 20 slowest queries

    SELECT TOP...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 6, 2012 at 12:29 pm

    #1522227

  • RE: SQL Server Login/Logout Audit

    my fault; in 2008 this line raises an error:

    I updated the script to correct the issue.

    exec sp_trace_setfilter @traceidout,12,0,4, 50 ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 6, 2012 at 12:24 pm

    #1522225

  • RE: How to Know ip address users who are accessing the application on sql server?

    nagkarjun1 (8/6/2012)

    How to know the ip address of the client application using the sql server?

    Example: if an application database is located on a sql server, can we know the ip...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 6, 2012 at 11:57 am

    #1522212

  • RE: sql to allocate quanitity according to available quantity

    what have you tried so far?

    this kind of looks like homework, so I'd prefer to help you learn how, rather than throw an answer out there.

    you have more than one...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 6, 2012 at 11:11 am

    #1522179

  • RE: Summing 2 Dates but only Workdays

    Here's my version of a Calendar table;

    I put a bit of time into it putting in various US holidays, which might be of some help as well.

    my date range is...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 6, 2012 at 10:56 am

    #1522174

  • RE: Group the common word

    well this kind of gets you the data chopped up into the pieces youa r elooking for;

    i'm using the famous DelimitedSplit8K you'll find links to in many posters signitures, and...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    August 6, 2012 at 10:48 am

    #1522172

Viewing 15 posts - 5,026 through 5,040 (of 13,460 total)