Forum Replies Created

Viewing 15 posts - 7,231 through 7,245 (of 13,460 total)

  • RE: Invalid object name '#temptable'.

    the few times i've read about this kind of issue, it was situations that i'm not sure apply here:

    connection pooling: create a temp table, and then issue another statemetn...sometimes your...

    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 1, 2011 at 6:45 am

    #1346991

  • RE: Restrict Linked server user to see system tables and views

    Syed Jahanzaib Bin hassan (7/1/2011)

    if you have passed the T-sql GRANT SELECT ON TO then he cant access the systems databases and systems objects even other...

    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 1, 2011 at 6:20 am

    #1346982

  • RE: Restricting DBA from accessing SQL DB objects

    you cannot encrypt a "table definition" (CREATE TABLE.....).. the column types and table name are stored in sys.tables and sys.comluns., and all the related obejects like constraints and indexes are...

    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 1, 2011 at 6:14 am

    #1346974

  • RE: LastYearYTD Sales

    part of what you posted says Year(today) -1

    that would be 2010, correct? isn't that what you want?

    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!

    June 30, 2011 at 2:54 pm

    #1346763

  • RE: Advice for a very nervous first time consultant

    as far as not breaking anything, if you were going to do an UPDATE, or add a job or reindex that wasn't one of the famous scripts here on SSC,...

    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!

    June 30, 2011 at 12:16 pm

    #1346688

  • RE: Advice for a very nervous first time consultant

    first i'd suggest practicing on a completely unfamiliar system; you get tunnel vision looking at your own laptop and machines, and make assumptions aobut what is in place and what...

    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!

    June 30, 2011 at 12:06 pm

    #1346681

  • RE: ADO.NET errorwhen reading table

    are you using a SQLCcmdObject with parameters to call the proc, or as a text command with ExecuteNonQuery??

    show me the code you are using to call the proc, i'd...

    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!

    June 30, 2011 at 11:10 am

    #1346666

  • RE: ADO.NET errorwhen reading table

    i'll bet at least one row is an empty string;

    an empty string can be converted to Integer, but not Numeric:

    SELECT CONVERT(int,'')--works! value = 0

    SELECT CONVERT(NUMERIC(8,0),'') --fails! Error converting data type...

    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!

    June 30, 2011 at 10:59 am

    #1346662

  • RE: Query to get a specific word....

    ok since we are showing off all our cursor abilities, here's my contribution to the same issue:

    mine is designed to search the db, and provide you with follow up SQL'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!

    June 30, 2011 at 10:31 am

    #1346651

  • RE: Adding Quotes around Every Column

    it depends completely on how you are exporting the data; you never mentioned what you are using.

    Are you using SSIS? bcp? your own application?

    bcp requires a format file to describe...

    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!

    June 30, 2011 at 10:21 am

    #1346646

  • RE: Getting email notification if SQL service gets stopped

    third party tools exist that are specifically designed for this.

    What's UP! and SQLPing are two that come to mind,and both are either free or have free versions.

    otherwise, if you are...

    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!

    June 30, 2011 at 9:07 am

    #1346607

  • RE: Create linked server to Avaya CMS database

    no, if you have already installed the ODBC driver on your server, you don't need any SDK or anything else.

    all you need to do is use the screenshots int hat...

    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!

    June 30, 2011 at 9:03 am

    #1346606

  • RE: Error: Could not create constraint

    the errors pretty clear.

    you are trying to create a unique primary key on an existing data. but at least one combination of those two columns are not unique. the values...

    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!

    June 30, 2011 at 8:39 am

    #1346580

  • RE: Create linked server to Avaya CMS database

    the IBM website has a walk through on using the SSMS GUI to create a linked server;

    does this help?

    https://www-304.ibm.com/support/docview.wss?uid=swg21195578

    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!

    June 30, 2011 at 8:03 am

    #1346552

  • RE: Backup file size 150 GB - Restore requires 3 times that size on disk

    you can create a database that researves a ton of freespace for future growth; when you restore that backup, it requires all that reserved free space as well...so getting 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!

    June 30, 2011 at 7:21 am

    #1346527

Viewing 15 posts - 7,231 through 7,245 (of 13,460 total)