Forum Replies Created

Viewing 15 posts - 4,336 through 4,350 (of 13,460 total)

  • RE: Network ip

    i was just looking through the SERVERPROPERTY functions, and cannot seem to find anything that shows the operating system.

    it is buried in @@VERSION, though, so i'd expect a serverproperty...

    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 26, 2012 at 5:47 am

    #1562172

  • RE: Network ip

    in 2008 and above, there is a new function called connection property, and you can get a lot of that information from that.

    that can give you both the client ip...

    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 26, 2012 at 5:32 am

    #1562167

  • RE: Migration from SQL Server 2005 to SQL Server 2008 R2 question

    APA0876 (11/21/2012)

    Hi,

    We will be migrating from SQL Server 2005 to SQL Server 2008 R2 (different physical server), and I'm wondering if I have to migrate the databases via Restore or...

    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 21, 2012 at 3:26 pm

    #1561422

  • RE: Delete Orphaned Constraints

    a SQL 2000 database, or one that was in SQL 2000 in a previous life?

    in that version, you could hand-edit the sys tables and drop objects without cleaning up 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 21, 2012 at 2:42 pm

    #1561411

  • RE: CONTAINS Keyword.

    Good point Erin; I guess it depends on whether you need to search for whole words or not;

    my example was just to show one way to match multiple search terms...

    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 21, 2012 at 2:34 pm

    #1561407

  • RE: Converting Oracle DDL statments to SQL

    if you want to do it yourself, which is another big job let me tell you, this data type equivalents link can help:

    http://docs.oracle.com/cd/B19306_01/gateways.102/b14270/apa.htm

    I've done it the other direction: take...

    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 21, 2012 at 12:43 pm

    #1561382

  • RE: Converting Oracle DDL statments to SQL

    SQLCrazyCertified (11/21/2012)

    I need to create a sql database which works the same way in oracle....

    Basically, I have to mimic a database from Oracle to SQL server.

    I have the DDL commands...

    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 21, 2012 at 12:37 pm

    #1561379

  • RE: Help in writing a statement

    des_vergara (11/21/2012)

    Hi need help writing a sql statement to show which departments did not submit any department goals.

    I have two tables name Department and Department Goals.

    Please help...

    without more detaisl, all...

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

    #1561330

  • RE: SQL QUERY for table names based on column VALUE

    nicholasferri (11/21/2012)

    Hi, I have a database where every table has an id column (CID) once this value changes all the tables must be checked and updated with the new CID...

    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 21, 2012 at 11:01 am

    #1561329

  • RE: how to handle "timestamp" datatype value in sql server

    timestamp is poorly named; the correct datatype name is rowversion.

    it's storing a number in there , not an nvarchar or varchar.

    you could change your variable to be int, bigint, or...

    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 21, 2012 at 9:45 am

    #1561301

  • RE: Total number of DMV in SQL Server

    Shadab Shah (11/21/2012)

    Thanks Lowell. I exceuted your query and found some of the column name not preceding with dm_...... . So is that OK?

    well you can filter it 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!

    November 21, 2012 at 7:26 am

    #1561253

  • RE: how can i write 2 select statements in single procedure

    Your application needs to use the techniques for Multiple Active Result Sets (MARS);

    just dumping the resutls into a DataReader or DataTable will only get you one of potentially multiple...

    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 21, 2012 at 6:59 am

    #1561233

  • RE: Total number of DMV in SQL Server

    the # depends on the SQL server version, and in some cases, the Service Pack version as well.

    easiest way is to simply look in SSMS Object Explorer>>Expad Server>>System Databases>>master>>Views>>System Views

    Or...

    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 21, 2012 at 6:52 am

    #1561229

  • RE: Install SQL Server on Linux

    yuvipoy (11/21/2012)

    Can we install SQL Server (any version) on Linux machine.

    If no why it is not designed in such a way that it can't be installed in other than windows.

    Thanks!

    SQL...

    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 21, 2012 at 6:28 am

    #1561222

  • RE: SQL Server 2008 R2 Setup How to chaneg system drive from C to D

    SQL server must be installed on the same drive as the %SystemDrive% variable points to; there's no getting around that, but the binaries themselves don't take up nearly as much...

    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 21, 2012 at 5:38 am

    #1561211

Viewing 15 posts - 4,336 through 4,350 (of 13,460 total)