Forum Replies Created

Viewing 15 posts - 2,266 through 2,280 (of 13,460 total)

  • RE: Copying from SQLSMS grid, pasting in Excel, the word "NULL" is pasted!

    I have a data massage macro in EditPlus exactly for this situation, where i replace \tNULL\t and \tNULL\n and also \nNULL\t with an empty string;

    then i can copy and paste...

    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!

    July 1, 2014 at 1:48 pm

    #1726322

  • RE: Reset SA password

    at one point, Microsoft had a script that you ran to simply add yourself as sysadmin to an instance. it required a stop and start of the instnace, but it...

    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!

    July 1, 2014 at 7:03 am

    #1726165

  • RE: Error while Assigning database level role (db_datareader) to SQL login (Domain Account)

    didn't see the screenshot you attatched, and you said "SQL 2003 SP3", did you mean 2000, since that is the forum you posted? 2005?2008?

    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!

    July 1, 2014 at 5:49 am

    #1726126

  • RE: Query to check for current database backup?

    a bit of research on my side seems to tell me this DMV can help: sys.database_recovery_status :

    if the database in question is in this resultset, it does not have 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!

    July 1, 2014 at 5:38 am

    #1726124

  • RE: Query to check for current database backup?

    Perry your example doesn't seem to be telling me what i thought I should find.

    i think the OP is asking if he can test whether he can take a log...

    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!

    July 1, 2014 at 5:29 am

    #1726118

  • RE: Search based on a table name and add code to the existing Stored Procedures

    you will be much better off simply scripting out all your procedures, and doing a find and manual replace/edit.

    any search is going to have the potential to fail, simply because...

    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!

    June 30, 2014 at 2:47 pm

    #1725994

  • RE: Bulk insert statement cannto open file on the share

    yeah i tlooks like the account has read access to the share for sure.

    is there any chance an application has the file open, so the bulk insert process cannot open...

    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!

    June 30, 2014 at 2:27 pm

    #1725984

  • RE: How to repair backup of .mdf file database?

    before you do anything, run the followign command, and post the full results here for some peer review:

    DBCC CHECKDB('msdb') WITH NO_INFOMSGS, ALL_ERRORMSGS

    DO NOT reboot the server, take the database offline,...

    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!

    June 30, 2014 at 2:07 pm

    #1725975

  • RE: Bulk insert statement cannto open file on the share

    i beleive delegation is not involved at all;

    if xp_cmdshell is enabled, you can run this and see who the user is, as wella s wehtehr the user ahs access 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!

    June 30, 2014 at 12:33 pm

    #1725951

  • RE: Bulk insert statement cannto open file on the share

    pure permissions is the issue;

    this is a common security misconception/"gotcha". The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard drives 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!

    June 30, 2014 at 11:16 am

    #1725941

  • RE: DID NOT have to re-establish the login and db user link after restoring database

    stating the obvious, windows users would not need to be resynced as orphans.

    if we are talking about SQL users, i can certainly think of a classic scenario where this 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!

    June 30, 2014 at 9:46 am

    #1725920

  • RE: retrieving 1 record takes 5 times longer than before PC went into sleep and woke up

    well, first, 26 milliseconds is fast. the difference is pretty minimal for things under 50 milliseconds, i don't know if it's worth investigating much.

    also, how are you measuring this? 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!

    June 30, 2014 at 9:11 am

    #1725906

  • RE: How do you describe what you do?

    in a non tech setting like with inlaws or strangers , i just say "i work in an office, and i work with the business group", as i've learned 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!

    June 30, 2014 at 9:06 am

    #1725903

  • RE: Restoring Issue in 2012..

    it sounds like all the instances(2008, 2008R2, and 2012) are all on the samemachine.

    you will absolutely have to change the path or filename in order to 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!

    June 30, 2014 at 5:42 am

    #1725824

  • RE: Best way to write stored procedures

    performance is really a broad quesiton, and it's not just procedure codign style you need to consider;

    indexing and SARG-ability of the queries are probably the two biggest things i 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!

    June 26, 2014 at 11:42 am

    #1725224

Viewing 15 posts - 2,266 through 2,280 (of 13,460 total)