Forum Replies Created

Viewing 15 posts - 5,566 through 5,580 (of 13,460 total)

  • RE: How to create multiple users using a procedure with a loop

    additionally, when you append strings together to create commands, you need to include spaces between the words.

    'GRANT' || staff_id|| 'TO' || username ||'';

    will make a string like "GRANTstaff_idTOLowell"

    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, 2012 at 8:27 pm

    #1477238

  • RE: Unable to view list of tables of a linked server

    Sapen (4/20/2012)

    Lowell (4/20/2012)

    i thought the catalog view he's refering to in the object Explorer returns the results of sp_tables_ex linkedservername , so whether the linked server is SQL Server, Oracle,...

    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 20, 2012 at 9:30 am

    #1476749

  • RE: Unable to view list of tables of a linked server

    i thought the catalog view he's refering to in the object Explorer returns the results of sp_tables_ex linkedservername , so whether the linked server is SQL Server, Oracle, mysql, 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!

    April 20, 2012 at 8:55 am

    #1476710

  • RE: Unable to view list of tables of a linked server

    Sapan i thought that the catalog gets populated with only the tables/objects of the default database assigned to the login you are using to connect with...so for example if my...

    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 20, 2012 at 8:46 am

    #1476699

  • RE: Logon Trigger, Restricting the connection to several IPs

    dakshinamurthy-655138 (4/20/2012)

    Hi,

    Please let me know if this logon trigger which is used to Restrict the connection to several IPs will have performance issues, where the concurrent users are more.

    You said...

    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 20, 2012 at 4:46 am

    #1476523

  • RE: Gak!

    Gazareth (4/18/2012)

    Just had a 1.4TB, (whisper it) MySQL table become corrupt. Wonder how long the repair'll take? :crazy:

    OK it's been a whole day already!

    How long did the repair take, and...

    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 19, 2012 at 5:45 am

    #1475953

  • RE: Do not grant any permissions to create or modify database objects

    your role looks fine, so it's got to be that either the individual or the group is in some other roles, like sysadmin roles, that is giving more permissions.

    run variations...

    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 16, 2012 at 3:46 pm

    #1474445

  • RE: Grant execute permission to all sql logins for a stored proc

    Pink123 (4/16/2012)

    I have to grant execute permissions to all sql logins on a particular store proc.

    Can someone help me with a query to do so.

    I am confused about how 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 16, 2012 at 9:49 am

    #1474129

  • RE: Update a column value for system table

    Pink123 (4/13/2012)

    Thanks but if I want to set the update date as some date in past ,how do I do that?

    sounds way too much like you are trying to falsify...

    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 13, 2012 at 1:02 pm

    #1473437

  • RE: Update a column value for system table

    ALTER LOGIN bob DISABLE;

    ALTER LOGIN bob ENABLE;

    after you've disabled and re-enabled the login, the updatedate will be the moment the last event occurred( the enable)

    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 13, 2012 at 12:04 pm

    #1473403

  • RE: DATABASES

    there's different ways i can think of offhand.

    one is ETL (Extract, Transform, Load); that would typically be export to a file, and an import file pulls the data into 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 13, 2012 at 11:44 am

    #1473382

  • RE: Trigger from one Db to another

    the trigger has no WHERE statement, and never references inserted or joins to the remote table...does that remote table only have one row?

    is there a realtionship between teh local...

    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 12, 2012 at 11:44 am

    #1472813

  • RE: can we use data mining for simulating football game?

    i think i will pass on downloading and running an executable from the internet, thanks.

    maybe you could post a link to the source code instead.

    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 12, 2012 at 11:40 am

    #1472807

  • RE: Issue with Identity Specification on Primary Key column...table has millions of rows

    Rich Yarger (4/11/2012)

    ...their tables, that has begun to receive millions of rows of data to this one table, a day (when I say millions I mean a million plus, but...

    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 12, 2012 at 11:28 am

    #1472796

  • RE: Need Help with the Error 'Subquery returned more than 1 value'.

    dunno if it matches the table that was posted, but here's the data as a select to show what we are looking for:

    I've got a pair of macros for hacking...

    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 12, 2012 at 10:26 am

    #1472748

Viewing 15 posts - 5,566 through 5,580 (of 13,460 total)