Forum Replies Created

Viewing 15 posts - 3,391 through 3,405 (of 13,460 total)

  • RE: Estimating space needed for database

    assuming the second table could potentially be the same size as the max for the first, it looks like a 30 gig database to me for just the data?

    1.5Meg *...

    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!

    May 28, 2013 at 6:30 am

    #1618925

  • RE: Correcting Login to User mappings

    it sounds like orphaned users to me, is that right?

    for SQL users(not windows users)

    if you restore a database from a different server, the user "Bob" on my server 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!

    May 28, 2013 at 6:19 am

    #1618922

  • RE: Add e-mai signature to SQL Database Mail

    Denesh Naidoo (5/28/2013)

    Hi All,

    Is it possible to configure SQL Server 2008 R2 database mail to add a signature to all e-mails sent out

    Thanks

    Denesh

    that's usually handled by either the client application,...

    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!

    May 28, 2013 at 5:26 am

    #1618910

  • RE: Windows NT user or group '%s' not found. Check the name again.

    you can only create a SQL user without login;

    so CREATE USER [ClarkKent] WITHOUT LOGIN is fine and will work;

    but if you put in a slash in the name, a windows...

    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!

    May 24, 2013 at 3:15 pm

    #1618447

  • RE: SFTP with sql server 2008

    i've used filezilla from a command line, as well as CoreFTP; both of which support SFTP and other protocols;

    i think FileZilla is free, and I know we paid for CoreFTP.

    https://wiki.filezilla-project.org/Command-line_arguments_(Client)?

    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!

    May 24, 2013 at 1:20 pm

    #1618426

  • RE: SQL Server can't connect to database

    can you edit the SQL Server(SQLEXPRESS) service, and change the startup account?

    Change it form whatever is there, to your username and password, for example, and then start the service?

    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!

    May 24, 2013 at 10:58 am

    #1618385

  • RE: Are the posted questions getting worse?

    I have a certain fondness for doing solutions in TSQL, or at least be centered around TSQL, regardless of whether it's the right tool for the job or not.

    I...

    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!

    May 23, 2013 at 2:00 pm

    #1618033

  • RE: Linked Server Query Hung in Killed/Rollback

    killing a linked server action that is using a distributed transaction pretty much guarantees a reboot is required to complete the rollback.

    it depends on what the query is actually doing...

    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!

    May 23, 2013 at 1:38 pm

    #1618027

  • RE: SQL Server can't connect to database

    first, lets make sure you know the name of the instance, and the instance is actually running.

    It's quite possible you installed the Tools but not the service itself, or 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!

    May 23, 2013 at 1:23 pm

    #1618022

  • RE: Triggers

    pretty sure RAISERROR requires three parameters, and you only passed one.

    RAISERROR ('Duplicate Records',16,1)

    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!

    May 23, 2013 at 11:47 am

    #1617964

  • RE: Creating a Custom Function (Scalar)

    i believe functions that are not CLR functions must be prefaced by the schema:

    SELECT

    Address1,

    Address2,

    dbo.FNCNOTAVAILABLEDISPLAY(Address3)

    FROM Customers

    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!

    May 23, 2013 at 11:33 am

    #1617959

  • RE: [sys].[dm_os_volume_stats]

    this link says the function is part of 2008R2 SP1 or later:

    http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/250ee9a5-e851-4449-b279-165fe0ccd600/

    It is available in SQL 2008 R2 with SP1 or later. http://msdn.microsoft.com/en-us/library/hh223223(SQL.105).aspx

    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!

    May 23, 2013 at 10:47 am

    #1617935

  • RE: [sys].[dm_os_volume_stats]

    if you run the command in the master database on the server that seems to fail, does it work?

    CROSS APPLY for a function will fail syntax if the database compatibility...

    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!

    May 23, 2013 at 10:41 am

    #1617930

  • RE: Super script

    saving rtf text, or saving it inside a document(like word) which supports font formatting are the only other ways i can think 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!

    May 22, 2013 at 1:58 pm

    #1617573

  • RE: Does SQLSERVER2008 offer Object level recovery

    AmarettoSlim (5/22/2013)

    Resurrecting this thread with a question I have...

    Can someone explain why SQL Server doesn't support object level recovery in a native manner?

    How do 3rd party vendors make this possible?

    I'm...

    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!

    May 22, 2013 at 1:57 pm

    #1617570

Viewing 15 posts - 3,391 through 3,405 (of 13,460 total)