Forum Replies Created

Viewing 15 posts - 6,961 through 6,975 (of 13,460 total)

  • RE: Granting rights

    Sachin Nandanwar (8/12/2011)

    Thanks.

    But I was thinking of a scenario where there are 10 users and all these 10 users have different set of permissions where in by no 2 users...

    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 12, 2011 at 5:35 am

    #1367826

  • RE: bcp tutorial or example

    you mean besides Books Online?

    http://msdn.microsoft.com/en-us/library/ms162802.aspx

    from my snippets:

    EXECUTE master.dbo.xp_cmdshell 'sqlcmd -Q "SELECT * FROM AdventureWorks.Person.Contact" -o MyOutput.txt'

    EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT FirstName, LastName FROM AdventureWorks.Person.Contact ORDER BY LastName, Firstname" queryout Contacts.txt -c...

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

    #1367464

  • RE: Does anyone know why "Batches" is a keyword in 2008 R2 - and how it is used?

    of the 273 future keywords on that list, 78 of them appear with syntax highlighting in SSMS 2008...and many of them are what i'd consider reserved words....datatypes like int 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 11, 2011 at 11:03 am

    #1367461

  • RE: C# bulk copy

    .NET has a bulkCopy object you can use.

    you need to read the data into a datatable first, and like bcp, the table has to exist as well.

    here's a translated 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!

    August 11, 2011 at 9:26 am

    #1367383

  • RE: Need some help with Query

    what you are seeing is how NULss are treated;

    they are undefined, so you cannot compare them;

    you need to handle the NULL values logiclaly, like with an isnull

    or 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!

    August 11, 2011 at 8:45 am

    #1367343

  • RE: A CASE Statement ...with conditions?

    SQL is a little different when it comes to CASE statements.a case statement returns a VALUE. it's only used for data elements.

    if you need to do a logical decision, you...

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

    #1366765

  • RE: Rolling back already commited data..?

    restore the database to a point prior to when the developer entered the data? or delete the data as he surmised?

    that's the onyl two things 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!

    August 10, 2011 at 9:44 am

    #1366678

  • RE: what to know what query executing the background ?

    My firend Remi schooled me on a trigger post a long time ago that dbcc inputbuffer now returns an Nvarchar(4000), and not 255 that i had assumed was still true...

    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, 2011 at 5:58 am

    #1366488

  • RE: Subquery

    row number is very handy for getting data like you are asking...this is a wild guess to get you started, it might or might not be right, but is 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!

    August 9, 2011 at 2:02 pm

    #1366256

  • RE: Before create a procedure send a trigger to a table

    ulisseslourenco (8/9/2011)

    GSquared (8/9/2011)

    You can use DDL triggers to fire on creation of a procedure. They can check values in tables. Will that do what you need?

    In fact 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!

    August 9, 2011 at 12:28 pm

    #1366147

  • RE: Execute Batch File Windows 2008/Sql 2005 - Error !!!

    no the task scheduler has an option to repeat multiple times:

    you have to dig intot eh details just a little here:

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

    #1366021

  • RE: Tuning a query

    ok i see there is a RID Lookup on the Company Table, which is a Heap, that seems to be something to address, I'm going to sit back and learn...

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

    #1365985

  • RE: Tuning a query

    well, i'm pretty sure statistics need to be updated; we've got a couple of orders of magnitude off on the estimated vs actual on two of the index seeks:

    i don't...

    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 9, 2011 at 8:55 am

    #1365977

  • RE: The mail could not be sent to the recipients because of the mail server failure.

    the errors pretty straight forward, i think:

    The specified string is not in the form required for an e-mail address

    http://www.google.com/search?q=The+specified+string+is+not+in+the+form+required+for+an+e-mail+address&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1

    you probably have an exchange server, and in the From Address 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!

    August 9, 2011 at 7:29 am

    #1365893

  • RE: Cannot bulk load because the file could not be opened. Error code 3

    Frank Cazabon (8/9/2011)

    I am using FILESTREAM to store PDF documents in a table. I let the user select the PDF to store and then use this code to upload...

    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 9, 2011 at 6:59 am

    #1365861

Viewing 15 posts - 6,961 through 6,975 (of 13,460 total)