Forum Replies Created

Viewing 15 posts - 1,861 through 1,875 (of 13,460 total)

  • RE: BUILTIN\Administrators login doesn't appear to be working.

    sounds like windows firewall to me.

    you can prove it real quick by simply turning off windows firewall, and trying to connect from another machine.

    the right thing to do after 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!

    March 26, 2015 at 5:38 am

    #1786506

  • RE: Script Out Database Mail Settings?

    Glad it helped you Rick!

    with 20K+ hits on this thread, it's clear that it's probably helped more than just the folks who were kind enough to post a thank you!

    glad...

    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!

    March 25, 2015 at 12:24 pm

    #1786402

  • RE: Transferring 3 SQL databases from both SQL Express 2005 and Standard to a new physical server

    bradh 14842 (3/25/2015)

    I am trying to figure out the best method for transferring SQL 2005 databases from 2 different physical servers to a new server running windows server 2008 64bit.

    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!

    March 25, 2015 at 6:25 am

    #1786249

  • RE: Microsoft.SqlServer.Management.Common.dll

    i think you have to extract it from the GAC(Global Area Cache?)

    c:\windows\assembly\GAC_MSIL or %windir%\assembly\GAC_MSIL

    you shoyuld see a fodler there with the dll name, IF it is installed.

    ie Microsoft.SqlServer.Management.Common

    inside you'll probably...

    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!

    March 24, 2015 at 8:08 am

    #1785976

  • RE: How Can I Tell the Number of Times People Use SSMS to Change Client Data

    this is really a security problem.

    developers should not have access to production data.

    it sounds like now you supsect or are afraid that they can touch the data, but you still...

    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!

    March 24, 2015 at 7:07 am

    #1785940

  • RE: rename hostname in SQL server cluster

    i think google is probably your friend on this one: i think this one was the better resource than anything i got from MSDN

    http://windowsitpro.com/windows-server/rename-nodes-cluster

    i've never done it, but the article...

    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!

    March 24, 2015 at 6:40 am

    #1785929

  • RE: Incremental Load

    Phil Parkin (3/23/2015)

    Is there a 'DateCreated' column in your source data?

    or is there an incremental primary key in the Oracle source that you can just select fromOracle where the source...

    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!

    March 23, 2015 at 7:07 am

    #1785683

  • RE: Monitoring Scripts - SQL

    there's applicaitons specifically designed for monitoring servers and services; a search of network monitoring sql server will get you a zillion apps. in a shop with 350 sql servers, your...

    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!

    March 23, 2015 at 6:24 am

    #1785673

  • RE: Server rename

    Michael L John (3/20/2015)

    sp_addserver @server = 'Servername', @local = 'local'.

    This re-sets the value of @@SERVERNAME

    ....combined with a server stop and start, that is correct...but not as a stand alone command.

    ...

    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!

    March 20, 2015 at 12:19 pm

    #1785448

  • RE: Server rename

    the running values for @@servername stay in place, until the service is stopped and started.

    if you select * from sys.servers where server_id = 0, that is the new name, 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!

    March 20, 2015 at 10:37 am

    #1785415

  • RE: T-SQL and CLR types for return value do not match

    i didn't compile this or test it , but it looks right to me;

    what if you return SQL values? SQLDouble will implicitly convert to Double, i think?

    you might have 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!

    March 20, 2015 at 8:53 am

    #1785376

  • RE: When does NT SERVICE\Winmgmt actually get used?

    well i know we have some monitoring apps on the network that use WMI calls;

    if i use a powershell query that uses WMI, do you think it might...

    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!

    March 20, 2015 at 8:50 am

    #1785375

  • RE: sp_who3 does not show any active processes?

    sp_who3 is not a built in proc from microsoft.

    my google search found at least four versions in the top ten results, so you'd have to look to the source itself.

    http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3

    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!

    March 20, 2015 at 7:56 am

    #1785353

  • RE: Bulk Insert Errors

    just checking the obvious here:

    what drive is this on? the string starts with a colon which is obviously invalid but might be an artifact of code obfuscation? or an actual...

    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!

    March 20, 2015 at 6:24 am

    #1785319

  • RE: How to drop columns from VIEW (ALTER VIEW?)

    well i'm betting that all the column names are aliases, right? the base tables don't have columns that have that pattern. in that case you can't alter the view without...

    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!

    March 20, 2015 at 6:06 am

    #1785315

Viewing 15 posts - 1,861 through 1,875 (of 13,460 total)