Forum Replies Created

Viewing 15 posts - 2,956 through 2,970 (of 13,460 total)

  • RE: @@variables

    didn't find a single list from Microsoft, but i found this one on codeproject:

    http://www.codeproject.com/Articles/39131/Global-Variables-in-SQL-Server

    •@@CONNECTIONS

    •@@MAX_CONNECTIONS

    •@@CPU_BUSY

    •@@ERROR

    •@@IDENTITY

    •@@IDLE

    •@@IO_BUSY

    •@@LANGID

    •@@LANGUAGE

    •@@MAXCHARLEN

    •@@PACK_RECEIVED

    •@@PACK_SENT

    •@@PACKET_ERRORS

    •@@ROWCOUNT ...

    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!

    November 12, 2013 at 8:05 am

    #1665737

  • RE: Bulk insert from file having varying number of columns

    Dorthy Jeff Moden has a couple of posts on this, which i'd saved in the past:

    here's the specific threads in question:

    http://www.sqlservercentral.com/search/?q=%22Headerless+Ragged+Right%22

    basically, he uses some dos commands to make sure 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!

    November 12, 2013 at 6:35 am

    #1665713

  • RE: Ideas for stopping customers meddling directly in the tables?

    at my last job we had a similar situation, after one core issue boiled down to the client creating poorly written triggers, which broke the application's logic. against the user...

    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!

    November 11, 2013 at 9:34 am

    #1665517

  • RE: List of SQL Server Express gotchas?

    i can think of only a couple offthe top of my head:

    TCP/IP / remote connections are not enabled by default.

    no Dedicated Admin Connection is available by default.

    depending on 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!

    November 11, 2013 at 6:19 am

    #1665457

  • RE: UPDATE with multiple joins

    here's my best guess based on your post's info:

    i'm explicitly aliasing the target table, so it might make it a little clearer:

    UPDATE MyTarget

    SET MyTarget.updtbl_lat = i.infotbl_lat,

    ...

    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!

    November 8, 2013 at 1:22 pm

    #1665219

  • RE: SQL Server 2012 training

    SQL Server Central currently has 103 videos on various SQL related subjects:

    http://www.sqlservercentral.com/Articles/Video

    add in the Stairways series on various SQl related paths, and you've got a great start right here 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!

    November 8, 2013 at 1:10 pm

    #1665218

  • RE: Connection string issue for sql authentication

    ushacheb (11/8/2013)

    Thank You for your reply Eddie . Am not using windows credentials ...access to this server is given with a different domain . Thank You

    Pretty sure SQL server 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!

    November 8, 2013 at 7:29 am

    #1665118

  • RE: Embedd Image from databse mail

    it's not obvious, but if you look at the html source of some of your own email, the trick is referencing the content id(cid) of the attachment(s) that was included;...

    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!

    November 7, 2013 at 6:36 am

    #1664731

  • RE: Determine the user who entered data

    well, you are only going to capture changes that occur in the future, after you've put some sort of auditing in place.

    stuff that has already happened just plain is 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!

    November 1, 2013 at 7:26 am

    #1663405

  • RE: Query/ Procedure to Generate list of logins and the DB access and their roles

    well, i'd start with implicit users that come from windows groups:

    select *

    from master.sys.server_principals

    where type_desc = 'WINDOWS_GROUP'

    from there, for each name in the list, you can use a built...

    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!

    October 31, 2013 at 10:08 am

    #1663156

  • RE: CLR Deployment - DLL Location

    hdillow (10/18/2013)

    Hello, if you were to remove the dlls from an installation directory, what happens if the SQL Server Instance is restarted or the cluster fails over to another node?...

    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!

    October 18, 2013 at 11:29 am

    #1659810

  • RE: Invalid object name 'DDLTriggerTest..EventTableData'.

    more details from you before we can help, i think.

    you really need to analyze the trigger itself, and fix the issue;

    for example, if there is a trigger on 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!

    October 2, 2013 at 6:37 am

    #1655199

  • RE: Invalid object name 'DDLTriggerTest..EventTableData'.

    Select from sys.triggers and sys.server_triggers. based on the brief description you gave plus the fact the.name contains "nested " you might have a trigger that blocks itself as well as...

    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, 2013 at 4:35 am

    #1654482

  • RE: Return text from a PDF stored in the database (Adobe iFilter)

    here's the first actual code example i found:

    http://www.codeproject.com/Articles/13391/Using-IFilter-in-C

    along the lines of what Erland was suggesting, i think i'd simply add a column that will hold the extracted text from 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 18, 2013 at 8:55 pm

    #1651355

  • RE: IP Restriction Feature

    I suspect the core issue is that everyone logged in has sysadmin or dbo priviledges and instead of fixing that as gail implied with proper security, you are looking...

    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 27, 2013 at 4:54 am

    #1645109

Viewing 15 posts - 2,956 through 2,970 (of 13,460 total)