Forum Replies Created

Viewing 15 posts - 6,646 through 6,660 (of 13,460 total)

  • RE: Issue sending or receiving email from SQL Server

    run this query to check for mail sent but that failed;

    there's a description column with any errors returned formt eh mails erver when it was sent; stuff like relaying not...

    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 30, 2011 at 9:27 am

    #1388906

  • RE: spot the Cartesian product

    change the FROM statments to use inner joins and you''l find it a few seconds...

    i'm guessing that the table alaised as qp is not mentioned in the where/join criteria.

    FROM

    ...

    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 30, 2011 at 9:16 am

    #1388896

  • RE: Retrieving BLOB file from DB and save into disk using BCP?

    SSC poster Elliot Whitlow has this CLR project for file manipulation , and includes Blob read write stuff as well;

    it took me about three minutes to install, and has worked...

    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 30, 2011 at 8:10 am

    #1388873

  • RE: sql query to get the SUM of Bitmasks

    bitmasks are an old school way , from when memory cost dollars per bit, to maximize the amount of data stored in a byte. it had the cost of obfuscating...

    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 30, 2011 at 7:14 am

    #1388829

  • RE: sql query to get the SUM of Bitmasks

    rams.prsk (9/30/2011)

    Thanks a lot Lowell, Can you just guide me how you could do SUM the bitmasks...that could be more great help

    For eg : SUM of 1 & 2 =...

    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 30, 2011 at 6:53 am

    #1388824

  • RE: sql query to get the SUM of Bitmasks

    i think your issue is the display of a bitmask.

    01011001 is a varchar representation of a bitmask.

    you need to do all your math as integers, and display it with...

    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 30, 2011 at 6:32 am

    #1388816

  • RE: Cloaking databases from different users

    you need exclusive access to the database in order to change the owner...so if someone is in it, the query waits for them.

    you'll need to wait till someones not in...

    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 29, 2011 at 2:15 pm

    #1388629

  • RE: Cloaking databases from different users

    mrTexasFreedom (9/29/2011)

    Lowell,

    I received permission from the organization here to allow the customer user to be dbowner. I thought I'd try the method you suggested in this snippet, but I receive...

    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 29, 2011 at 11:26 am

    #1388536

  • RE: Deny windows account user to register sql server in enterprise manager

    does SQL 2000 support logon triggers? i think that's only 2005 and above, rioght?

    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 29, 2011 at 11:18 am

    #1388530

  • RE: Blowfish Encryption Toolkit on SS 2008 R2

    nineteen-red (9/29/2011)

    Thanks so much Lowell, replaced the originals with the dlls in the zip and it worked a treat.

    Appreciate your help with that one as I had read the thread...

    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 29, 2011 at 11:13 am

    #1388527

  • RE: Blowfish Encryption Toolkit on SS 2008 R2

    Mike C, the original author, pointed to a different thread where folks talked about not being able to use 64 bit with the originals.

    cygnussolutions posted a zip file 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 29, 2011 at 10:20 am

    #1388492

  • RE: identify applications using sa

    no...from what we posted above, i think it's now detecitve work...

    @ 12 noon, the machine \\BIZ100 was connected using sa

    we find that machine, and find Bob sits at the desk...

    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 29, 2011 at 10:07 am

    #1388482

  • RE: Getting DATEPART of getdate()

    and another way, since you posted in SQL2208, is to consdier the tIME datatype to get what yo are after as well:

    --returned 10:53:47.4970000 and 10:53 for me at that moment

    select...

    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 29, 2011 at 8:56 am

    #1388428

  • RE: Disabling CLR for Individual Databases

    i believe this is the possible CLR types:

    select * from sys.objects where type_desc IN

    ('CLR_STORED_PROCEDURE',

    'CLR_SCALAR_FUNCTION',

    'CLR_TABLE_VALUED_FUNCTION',

    'CLR_TRIGGER',

    'AGGREGATE_FUNCTION')

    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 29, 2011 at 8:48 am

    #1388420

  • RE: Disabling CLR for Individual Databases

    since every CLR has a proc or function object, can't you create a role with DENY EXECUTE ON [each procOrfunction]?

    then put all the users in that role to take 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 29, 2011 at 8:41 am

    #1388410

Viewing 15 posts - 6,646 through 6,660 (of 13,460 total)