Forum Replies Created

Viewing 15 posts - 6,451 through 6,465 (of 13,460 total)

  • RE: No sql account for login

    you'll need to start the server in single user mode, and add yourself as an administrator again, then put the serve back to normal.

    fromt ehre, you can connect and start...

    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!

    November 9, 2011 at 9:56 am

    #1405354

  • RE: Is there a way to find out the current daylight savings state

    if you know what offset your timezone is, you could calculate it;

    for example in Miami Florida, i'm -5 from GMT , but when it's daylight savings, i'm -4;

    by getting the...

    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!

    November 9, 2011 at 9:27 am

    #1405309

  • RE: SQL TOOLS

    davidshephard (11/9/2011)

    Hi all,does anyone know of a free SQL tool that can scan a group of machines and expose the follwoing:

    1.What version of SQL on each machine.

    2.Service pack level

    3.Number of...

    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!

    November 9, 2011 at 9:00 am

    #1405288

  • RE: How to retrieve tables , sp's, views , functions related to a particular field?????

    i think something like this will help;

    with the WHERE statement below, you get every objec that happens to have a reference to any column named "EmployeeNumber"

    you might want to change...

    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!

    November 9, 2011 at 5:53 am

    #1405090

  • RE: Function in Reporting

    are you using the two values for the BETWEEN ...AND operator?

    if that's true, you could work around it with a case statement to make sure the lower value is used...

    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!

    November 8, 2011 at 2:54 pm

    #1404871

  • RE: Aggregate statistics

    ideally, you just use a CTE to put the data together, and then summarize it.

    show us the cursor and the expected output, maybe we can switch it to set based...

    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!

    November 8, 2011 at 1:53 pm

    #1404837

  • RE: Add a carriage return within text

    littlelisa1111 (11/8/2011)

    The results are in a grid. I'm using SQL Server Management Studio if that makes a difference. My goal is once I get this to work 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!

    November 8, 2011 at 1:40 pm

    #1404831

  • RE: scripting a join between db's on different servers/same domain

    Breakwaterpc (11/8/2011)

    how would i script a join (or anything else for that matter) between two tables/databases on different servers on the same domain?

    For instance, i want to compare...

    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!

    November 8, 2011 at 1:30 pm

    #1404826

  • RE: QUICKY: Trying to reference another server in our domain, NOT a linked server, gives "Could not find server..."

    Ninja's_RGR'us (11/8/2011)

    sjimmo (11/8/2011)

    Using openrowset will allow you to perform selects between servers that are not using linked servers. We do this amongst many servers on our network. We do this...

    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!

    November 8, 2011 at 10:57 am

    #1404731

  • RE: Set up connection to remote server on another domain

    christina-518819 (11/8/2011)

    Thanks for your reply. I wanted to use a mapped drive but I've been given orders from on high that I'm not allowed to map any drives to the...

    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!

    November 8, 2011 at 6:10 am

    #1404433

  • RE: SQL conundrum

    Dan Williams-449672 (11/8/2011)

    Can anyone help with the following?

    I have a table that stores appointments and another that stores

    peoples availability.

    People can specify dates and times they are available...

    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!

    November 8, 2011 at 6:05 am

    #1404429

  • RE: Set up connection to remote server on another domain

    I'm not an SSIS guy, but i do know that the you can map a network drive with the NET USE command allows you to specidy a domain users...

    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!

    November 8, 2011 at 6:01 am

    #1404422

  • RE: How to backup a table with data?

    another way is the SSMS addin from http://www.ssmstoolspack.com/ also has the ability to generate insert statements from The SSMS GUI;

    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!

    November 8, 2011 at 3:16 am

    #1404341

  • RE: Database mail permission problem

    Sagar Sawant (11/7/2011)

    Hi guys,

    I am getting error when trying to execute database profile and database account through stored procedure.

    I already executed,

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'Database...

    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!

    November 8, 2011 at 3:12 am

    #1404338

  • RE: Stored Procedures - Execute Permissions - proc with dbcc command

    Steve Malley (11/7/2011)

    If I create a stored procedure with 'dbcc freeproccache' in it, and then grant execute on that stored procedure to a specific user account, the grantee should be...

    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!

    November 7, 2011 at 3:22 pm

    #1404198

Viewing 15 posts - 6,451 through 6,465 (of 13,460 total)