Forum Replies Created

Viewing 15 posts - 7,831 through 7,845 (of 13,460 total)

  • RE: Customizable Insert Script For Procedures

    adding the column to every table, or the parameter to every procedure could be scripted from the meta data,but...

    the procedures are the problem; every procedure has to be hand...

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

    #1306424

  • RE: link to proteus (unix) server

    spin, yes, it's sounding like you need the specific drives;

    as you were setting up , you saw there is a selection of some possible drivers, but when you connect to...

    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 1, 2011 at 4:53 am

    #1306392

  • RE: capture PK of inserted records

    you want to use the OUTPUT Clause; it's especially helpful when you insert more than one row.

    from what I've read recently, even SCOPE_IDENTITY() function can fail to return correct 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!

    March 31, 2011 at 12:35 pm

    #1306157

  • RE: Database Architect..Need help

    then you'll have to slow down, take a deep breath, and start identifying the objects/data they need to capture. call another meeting for exactly that: ask those who know 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!

    March 31, 2011 at 10:01 am

    #1306077

  • RE: SQL editor for MSaccess

    If you are not going to install SSMS for them, then something like LinqPad might work. It supports multiple languages, including TSQL, and it is a Decent SSMS replacement: 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!

    March 31, 2011 at 9:57 am

    #1306075

  • RE: link to proteus (unix) server

    this link shows another forums building a linked server to that type of db; it's got a description for both SQL Server gui settings and then a scripted linked...

    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!

    March 31, 2011 at 9:50 am

    #1306067

  • RE: Create a foreign key from two tables

    can you exec sp_help fogos ?; isn't that FK already there? i think that;s what that error means.

    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!

    March 31, 2011 at 8:17 am

    #1305997

  • RE: Create a foreign key from two tables

    this error means the FK already exists:

    Unable to create relationship 'FK_AVALIACOES_FOGOS'.

    The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_AVALIACOES_FOGOS". The conflict occurred in database "SGIPU3", table "dbo.FOGOS", column...

    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!

    March 31, 2011 at 7:56 am

    #1305982

  • RE: Create a foreign key from two tables

    a foreign key has to reference either a primary key or unique constraint in a single table

    so if the predios.ID_predios is one of those, you could have a FK to...

    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!

    March 31, 2011 at 6:56 am

    #1305934

  • RE: Find unused databases or when last used in a instance?

    Nice usage of a pivot there Gianluca, I really need to get PIVOT into my scripting usage a bit more.

    I built something similar without the pivot, yours makes it very...

    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!

    March 31, 2011 at 6:51 am

    #1305931

  • RE: how to encrypt column of a table

    for most encryption types, youll end up changing the datatype of your column to varbinary to store the newly encrypted value. google "sql 2008 encryption for examples, as it's 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!

    March 31, 2011 at 5:16 am

    #1305900

  • RE: Do sql server Roles are copied into secondary server when a manual failover is done in Log shipping?

    roles and users are stored inside the database, just like any other table or view object, so yes, roles/users will exist on your standby server.

    the LOGINS are stored in 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!

    March 31, 2011 at 5:12 am

    #1305899

  • RE: Oracle 10g vs SQL Server 2008 Disk Space estimate

    they are very nearly the same, i believe; after all, the amount of space needed store any given data type(int/number, varchar/varchar2 is the same in both systems, so 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!

    March 30, 2011 at 6:42 pm

    #1305756

  • RE: How to allow a SQL login access to a folder on another server.

    there is a way, but it exposes a users passwords in code; that makes it extra creepy with a domain password

    it's possible to map a network drive with a domain...

    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!

    March 30, 2011 at 1:12 pm

    #1305640

  • RE: force select permissions on table creation

    i've played with a database trigger that adds permissions to a role when a DDL event like creating a table occurs;

    this would also do what you are asking:

    CREATE TRIGGER...

    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!

    March 30, 2011 at 11:04 am

    #1305571

Viewing 15 posts - 7,831 through 7,845 (of 13,460 total)