Forum Replies Created

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

  • RE: Object is not an ADODB.RecordSet or an ADODB.Record. Parameter name: adodb

    you didn't mention it, maybe it's there but not in the snippet you posted, but where is the connection for the dataadapter?

    I know the ADODBRecordSet As object is the 4th...

    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 6:01 pm

    #1316330

  • 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

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