Forum Replies Created

Viewing 15 posts - 7,696 through 7,710 (of 13,459 total)

  • RE: TNSnames.org File Entry for all databases?

    can't you connect with your default linked server to oracle, and then simply switch to 4 part naming conventions, same as SQL?

    That's absolutely true in my case whenever i connect...

    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!

    April 26, 2011 at 5:48 pm

    #1316328

  • RE: Deny all permissions

    SQL Server is deny by default, so as long as the user is not tied to a sysadmin, you would add the user to the database, and then add that...

    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!

    April 26, 2011 at 4:49 am

    #1315753

  • RE: Import/Export files (.txt/.csv/.xls) into SQL 2005 Compact Edition

    Jeff Moden (4/23/2011)

    Pardon my ignorance. What's an "SDF"?

    SQL Server Compact Edition databases are supposed to a good idea for mobile phones and other portable devices;There's no service like SQLServer...

    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!

    April 24, 2011 at 6:30 am

    #1315245

  • RE: Not able to restore in WIndows 2008 Enterprise Edition from Standard Edition

    Syed Jahanzaib Bin hassan (4/23/2011)

    lets try with recent updates of this release like service packs and CUs

    Regards,

    Syed Jahanzaib Bin Hassan

    MCTS | MCITP | OCA | OCP | OCE | SCJP...

    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!

    April 23, 2011 at 5:46 am

    #1315123

  • RE: lakhs separator (1,23,45,67,890)...

    here is an example that works to 99999.99; from there it's trivial to expand it to higher numbers:

    --1,23,45,67,890

    ALTER function lakFormatting(@value money)

    returns table

    as

    return

    SELECT

    CASE

    ...

    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!

    April 23, 2011 at 5:21 am

    #1315120

  • RE: lakhs separator (1,23,45,67,890)...

    Isn't this handled by the GUI/app you are using to display the data? Typically separators are handled by the regional settings in windows for me; all numbers in SQL server...

    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!

    April 23, 2011 at 5:12 am

    #1315119

  • RE: Add Reference Data to Tables When You Deploy the Database

    the SSMS has an option to script data as wll as the table definitions; i've used it before

    but it's weird when i went to Tools>>Options ...SQL Server Object Explorer>>Scripting 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!

    April 22, 2011 at 4:13 am

    #1314825

  • RE: Add Reference Data to Tables When You Deploy the Database

    don't deploy a script ;give the end user a complete backup with all tables and default data already in place; it's faster, easier and not prone to script errors

    it's...

    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!

    April 21, 2011 at 10:07 pm

    #1314777

  • RE: copy files through network to another server

    I had to lookup Sneakernet on Wiki , already anticipating installing something ultra fast on my network;

    That one made my day.

    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!

    April 18, 2011 at 8:08 am

    #1312814

  • RE: Exporting results from multiple queries to csv

    it is much easier to write a file within your application than it is to do it on the SQL Server.

    You run into a lot of permissions issues where 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!

    April 18, 2011 at 8:00 am

    #1312802

  • RE: INSERT

    what is the name of the identity column in the table [stocktb]?

    are you trying to force stocktb.[identitycolumn?] to be exactly the same as the productid from the other table, 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!

    April 18, 2011 at 7:55 am

    #1312791

  • RE: Date as INT - having trouble with comparison :(

    ok, with a lot of rows in the source table,isn't the CURRENT_TIMESTAMP variable still being evaluated on a per-row basis?

    can you try this instead?

    declare @Last7Days int

    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!

    April 18, 2011 at 7:23 am

    #1312745

  • RE: Rolling down data based on key column

    really need a bit more of the table definition to give you some solid code examples.

    basically, what you want is to use a tally table to help generate all possible...

    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!

    April 18, 2011 at 7:13 am

    #1312730

  • RE: Date as INT - having trouble with comparison :(

    I'm guessing there's not an index on the[table-name-removed] column yet;

    that should speed things up considerably i bet.

    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!

    April 18, 2011 at 6:38 am

    #1312713

  • RE: Database slow sql server 2005

    use the DMV's to determine the slowest query currently in the cache. examine the queries to see if they can benefit to from being rewritten to be more SARG-able, 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!

    April 17, 2011 at 11:14 am

    #1312517

Viewing 15 posts - 7,696 through 7,710 (of 13,459 total)