Forum Replies Created

Viewing 15 posts - 9,031 through 9,045 (of 13,460 total)

  • RE: Stop Devs from using Service account in prod

    take a look at this thread about logon triggers...

    you could make a trigger like the example that refuses a connection if they are using the specific SUSER_NAME() of the account...

    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 15, 2010 at 12:31 pm

    #1193706

  • RE: How to distribute data among different servers uniquely?

    we have a handful of tables that require what you are asking;

    what we did was add an additional column to the table, where the default value is the location/server/identifier for...

    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 15, 2010 at 12:25 pm

    #1193702

  • RE: Pair of dbs; need sandbox

    jvanderberg (7/15/2010)

    You could install another database instance (possibly even express edition), and copy the databases using the same names. I can't imagine your website code likes different database names...

    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 15, 2010 at 12:13 pm

    #1193694

  • RE: Issues creating tables with table owner as DBO

    here's some code that will change every non-dbo schema-ed table to be in the dbo schema again. you'd need to tweak it to cover procs/views/functions, if that is an issue...

    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 15, 2010 at 12:11 pm

    #1193691

  • RE: Pair of dbs; need sandbox

    i think you'll have to script out all the functions,views and procedures to a file, then do a find and replace...

    P1. -->[P2].

    [P1] -->[P2]

    then replace each CREATE PROCEDURE/CREATE FUNCTION/CREATE VIEW with...

    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 15, 2010 at 11:43 am

    #1193668

  • RE: Frequent blocking in SQL Server 2005 instance having Share Point databases

    Auto update stats only gets triggered when 20% of the rows in a table are modified...on small tables, that's fine, but on a big table, say a million rows,...

    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 15, 2010 at 11:32 am

    #1193661

  • RE: Can you 'Select' from a stored procedure

    personally I usually put the results of a proc into a temp table, like this:

    CREATE TABLE #WHORESULTS (

    [WHORESULTSID] ...

    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 15, 2010 at 11:23 am

    #1193656

  • RE: Update trigger with cursor problem

    i have yet to find a situation where a trigger featuring a cursor cannot be replaced with a set based operation. Usually a trigger might have a cursor because 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!

    July 15, 2010 at 11:18 am

    #1193651

  • RE: Any way to Pass Parameters to Jobs?

    you cannot get it to prompt for a value. it's not designed that way...it is designed to run unattended.

    what you can do is make the job check a value in...

    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 15, 2010 at 9:52 am

    #1193593

  • RE: Migrating from SQL 2005 Express to SQL 2008 Standard with Blackberry Enterprise Server Express Running

    well, because Express does not HAVE analysis services or SSIS, getting an error message about being unable to analyze them for upgrade is a non issue.

    I don't see anything preventing...

    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 15, 2010 at 9:42 am

    #1193587

  • RE: Invisible stored procedure

    the devil is in the details...

    what is the real name of the proc?

    for example, you know that anything that starts with "sp_" is assumed to be in the master database...maybe...

    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 15, 2010 at 5:49 am

    #1193391

  • RE: Find dependencies of an object across the database

    sp_depends is 100% accurate for tables functions and views. you cannot create any of those things with a dependency to another object unless the object exists.

    because of the way...

    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 15, 2010 at 4:55 am

    #1193363

  • RE: computed column "Version" from table sysdatabases

    also i'm under the impression that verswion is more tied to the SQL the db is restored on...i took my SandBox from 2005, restored it on my sql 2008, 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!

    July 15, 2010 at 4:47 am

    #1193355

  • RE: Rows to Columns (The simplest way please)

    also consider this: change the presentation so it is not user centric...make it functionality centric.

    a tree view with branches and sub branches of your modules and sub modules would probably...

    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 14, 2010 at 5:42 pm

    #1193195

  • RE: Rows to Columns (The simplest way please)

    from a security presentation standpoint, I'd think that seeing 22 rows one for each security module, and having usually 4 security points, but sometimes 7 or 8 points would 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!

    July 14, 2010 at 5:30 pm

    #1193192

Viewing 15 posts - 9,031 through 9,045 (of 13,460 total)