Forum Replies Created

Viewing 15 posts - 3,106 through 3,120 (of 13,460 total)

  • RE: Minimum rights required to add users to a DB

    lloks like the string is constructed slightly wrong: thank goodness for the print statements!

    CREATE LOGIN [test1] WITH PASSWORD = 'password',N' DEFAULT_DATABASE=[Master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;

    i think the cod eneeds to be changed...

    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 10, 2013 at 9:17 am

    #1631267

  • RE: Minimum rights required to add users to a DB

    because your obiwan user is going to be creating logins and also executing AS., it needs to be a sysadmin(for CREATE LOGIN) and db owner in the database (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!

    July 10, 2013 at 7:54 am

    #1631234

  • RE: Neighboring counties

    note: 7 year old 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!

    July 10, 2013 at 7:22 am

    #1631206

  • RE: "Throw it on the Big Screen" Like on NCIS tv show

    Brandie you are spot on about the too literal thing, and i knew it when i heard the requirement; I thank you for your time in adding to my question...

    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 10, 2013 at 5:26 am

    #1631152

  • RE: Increase length of NVARCHAR(MAX) more than 8000 Character

    instead of

    EXEC sp_executesql @sql

    use

    EXEC(@sql)

    which has no limits on the query size, since it's not parameterized. ou are not passing parameters via sp+executesql, so you'd be good 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!

    July 10, 2013 at 2:48 am

    #1631116

  • RE: Restore databse from SQL SERVER 2005 to SQL SERVER 2012.

    vinod.venugopal 71189 (7/9/2013)

    I thought SQL Server 2005 has to be on SP4 or above before we plan to migrate/restore it to SQL 2012.

    Thanks for clarifying my doubt. I will...

    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 10, 2013 at 2:20 am

    #1631109

  • RE: "Throw it on the Big Screen" Like on NCIS tv show

    ok, i've seen that kind of thing, but that's basically a wireless monitor cable right? only one person can use the screen?

    I don't think that's quite what i'm after, but...

    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 9, 2013 at 3:10 pm

    #1631005

  • RE: Hostname is a dot in sp_who2

    you can get the IP address for connections, if that helps;

    compare this to sp_who2, and see if it helps you any:

    select

    conns.client_net_address,

    conns.auth_scheme,

    sess.* from sys.dm_exec_sessions sess

    LEFT OUTER JOIN sys.dm_exec_connections conns on...

    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 9, 2013 at 3:08 pm

    #1631004

  • RE: Are the posted questions getting worse?

    ok if anybody has some answers on my off the wall post here, i'd appreciate it: this is more of a "heard of an app that does this"? question:

    "Throw 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 9, 2013 at 2:32 pm

    #1630980

  • RE: Hostname is a dot in sp_who2

    SQL Guy 1 (7/9/2013)

    That's funny, I never knew about such trick, thanks Lowell. But why Microsoft allows to change them at all? It can be really misleading.

    it's a property...

    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 9, 2013 at 2:27 pm

    #1630979

  • RE: The operating system returned error 5(Access is denied.) to SQL Server during a write at offset 0x00000000012000 in file 'D:\data\data.mdf'

    JP10 (7/9/2013)

    yes I believe it's on a SAN (IT guy is on vacation). This happens when we restart the service only and not the server.

    So what was...

    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 9, 2013 at 2:25 pm

    #1630978

  • RE: Hostname is a dot in sp_who2

    also, the bad news: keep in mind the hostname/workstation id as well as the Application Name can be configured to say anything in a connection string,

    so you cannot always rely...

    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 9, 2013 at 2:03 pm

    #1630972

  • RE: The operating system returned error 5(Access is denied.) to SQL Server during a write at offset 0x00000000012000 in file 'D:\data\data.mdf'

    is this on a sAN, where the SAN ends up coming on line AFTER the SQl service is already started?

    i've seen a similar situation on my developer machine.

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

    July 9, 2013 at 1:39 pm

    #1630964

  • RE: How do I allow all logged in users to access a SQL Express 2008 R2 database?

    Rod at work (7/9/2013)

    OK, I've added our Domain Users group to the logins for SQL 2008 R2 Express on my PC. It's server role is public. Domain User's default database...

    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 9, 2013 at 1:36 pm

    #1630961

  • RE: Email function results as XML

    i think it has to do with FOR XML returns a stream of xml, and not an object we typically expect.

    this is what i used for the proof of concempt...

    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 9, 2013 at 12:49 pm

    #1630942

Viewing 15 posts - 3,106 through 3,120 (of 13,460 total)