Forum Replies Created

Viewing 15 posts - 346 through 360 (of 13,460 total)

  • RE: How to identity Sql server version from Backup file

    the restore headeronly command can do what you are asking

    the results has a column named "SoftwareVersionMajor", and "SoftwareVersionMinor", where you can get things like 13,0 for SQL2016, 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!

    September 15, 2017 at 9:24 am

    #1959615

  • RE: DateTime Field Hide time if it is midnight

    where are you displaying this, in SSMS or in some SSRS report?
    you can convert the values to varchar with a case statement, but is that what you want?

    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!

    September 14, 2017 at 2:15 pm

    #1959500

  • RE: Need to create a "done" file step.

    I've seen this as a cross check that the big file is not still currently being written to; ie the file exists, and would be open but potentially if read would...

    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!

    September 14, 2017 at 12:24 pm

    #1959486

  • RE: No Data in a table when database is restored

    it is not possible that a database restore skips a table.
    that means the table was empty at the time of the backup.
    you most likely need to go to a...

    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!

    September 13, 2017 at 8:23 am

    #1959256

  • RE: Altering a primary Key Constraint which is referred by foreign Key Constraint.

    nope, you have to drop the foreign keys that reference the PK, then drop the PK, then recreate a new PK and -the foreign keys so they now feature 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!

    September 13, 2017 at 7:06 am

    #1959235

  • RE: How to handle business hour loads?

    I have to use this kind of logic to maintain a suite of tables that are consistent as a group, ie all data s of 8am, and I can hot...

    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!

    September 5, 2017 at 2:43 pm

    #1958204

  • RE: How to handle business hour loads?

    how about swapping objects in and out of a schema? doing a bunch of transfers is extremely fast, but like  Chris said, you are consuming resources on production to do 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!

    September 5, 2017 at 1:00 pm

    #1958168

  • RE: Unable to connect to ftp with SQL Data Tools but can with ftp client

    SSDT can connect to FTP but not SecureFTP/SFTP.. FileZilla or many other executables handle both FTP and SFTP.

    if that is what you are connecting to, you'll need 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!

    September 2, 2017 at 3:37 am

    #1957910

  • RE: Display records horizontally

    so do you want to arrange your data as columns, or one column that is comma delimted?

    yopu did not provide an example query or expected output, but here's...

    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 31, 2017 at 6:05 am

    #1957625

  • RE: Query cancelled but completed is 0...

    you have to be patient. it finishes rolling back when it finishes. maybe 15 to 30 hours from now; it's common that a rollback can take twice as long as...

    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 31, 2017 at 5:48 am

    #1957622

  • RE: CPU usage overhead after setting Max DOP

    I think you should have fixed the one query that was the issue, since you already identified it as a problem.
    instead you changed the entire server behavior to account...

    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 30, 2017 at 7:59 am

    #1957436

  • RE: SQLCMD Mode; Run all SQL files in a directory

    i do something exactly like this in PowerShell; with that, i can capture the output of the script, whether it was an info message, a  data set or an error...

    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 25, 2017 at 7:52 am

    #1956848

  • RE: How can I use data returned from a query to delete files on my network?

    here's a quick and dirty version of powershell, detailing what Grant was referencing


    $FileNames = Invoke-SQLCMD -Query "SELECT top 5 'C:\Data\' + name + '.sql'...

    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 22, 2017 at 3:42 pm

    #1956255

  • RE: 2008 R2 - ConnectionProperty system function is missing.

    I don't know that ConenctionProperty is actually database functionality . function. it's server functionality related to the connection, right?

    this works in SQL2008 and above, and  I just checked, 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 21, 2017 at 1:55 pm

    #1956059

  • RE: Change all server name synonyms

    sure.
    this scripts out the synonyms exactly as is, so I simply added a replace on the definition to change the whichever synonyms had a base_object_name that contains 'CONTOSO' to 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 10, 2017 at 8:47 am

    #1954827

Viewing 15 posts - 346 through 360 (of 13,460 total)