Forum Replies Created

Viewing 15 posts - 12,346 through 12,360 (of 13,460 total)

  • RE: Strange behavior of UPDATE statement

    you get a rows affected for every sql statement performed. that means select,update,insert or delete statements each return the rows affected.

    sounds like you had either a cursor or loop 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!

    October 3, 2007 at 8:14 am

    #738628

  • RE: How do I Change The DB\Instance name

    you cannot rename an instance, it has to be uninstalled and a new instance with the correct name needs to be created. that means backing up non-system databases, and then...

    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!

    October 3, 2007 at 5:53 am

    #738555

  • RE: replicate DEV box - job failed

    also, a DTS job is slower thant he time it takes to backup, copy and restore a database, as well as being prone to the changes you are seeing.

    I'd recommend...

    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!

    October 2, 2007 at 8:02 pm

    #738470

  • RE: Querying the max row length

    the thing about color is that you MUST enter the double quotes to get it to work.

    input = #0000FF is BAD

    input = "#0000FF" is GOOD

    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!

    October 2, 2007 at 7:51 pm

    #738467

  • RE: obtaining a users access to databases and access within a database

    you are right....the actual permissions are stored inside the database, and not in any master table.

    this is by design, so when you backup and resotre, the permissions for the objects...

    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!

    October 2, 2007 at 11:41 am

    #738301

  • RE: Dual NICs

    it's handled automatically by the operating system;

    you might have one nic that has an internal IP for your network, lets say 192.168.1.50

    the other NIC might have an IP address on...

    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!

    October 2, 2007 at 9:57 am

    #738246

  • RE: HELP WITH AUTOGENERATED INSERT

    we had a similar issue in our shop...we needed to merge two databases together, with each table having different data, but possibly the same identity() values.

    we had to build...

    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!

    October 2, 2007 at 9:15 am

    #738226

  • RE: Querying the max row length

    Jeff was just fiddling with it...add a reply, emails get sent, delete teh reply, the link in the email can't find the posted reply. expected behavior.

    WHY he was testing, we...

    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!

    October 2, 2007 at 8:07 am

    #738170

  • RE: More newbie system table help

    Jeff Moden (10/1/2007)

    Heh... those are fun but I like the real-life questions that teach why or why not to do something... for example...

    1. How many internal rows will be...

    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!

    October 2, 2007 at 7:00 am

    #738120

  • RE: count non null values

    this would give you the sample structure to test each column in a single pass...is that what you wanted, or did you want where an entire row was null?

    select SUM(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!

    October 2, 2007 at 4:54 am

    #738069

  • RE: How to migrate clipper database to sql 2000

    from what i remember Clipper was just a Visual Foxpro, right? so it's simply a .DBF file you connect to using dts and import the whole thing:

    Enterprise Manager, Select database...Right...

    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!

    October 1, 2007 at 10:07 pm

    #738008

  • RE: Restricting rights to Query Analyzer only

    you can restrict access to executables and such via NT permissions and Active directory.

    Once connected, unless you restricted his access to some objects, he's pretty much got access right?

    if he...

    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!

    October 1, 2007 at 9:34 pm

    #737993

  • RE: Querying the max row length

    creating and deleting replys, it looks like from my forum emails.

    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!

    October 1, 2007 at 9:31 pm

    #737992

  • RE: Trigger lock hint

    Serg is right; what is your trigger doing? Is it calling a stored procedure or something ?Is it using spOACreate/xp_cmdshell? trying to email something? does it declare a variable? does...

    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!

    October 1, 2007 at 9:30 pm

    #737991

  • RE: SQL Syntax for newbie...

    not sure which programming language you are using, but having a recordset/datatable with Userid, RoleId and RoleName might be more flexible;there might be other items you'd want handy 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!

    October 1, 2007 at 2:44 pm

    #737893

Viewing 15 posts - 12,346 through 12,360 (of 13,460 total)