Forum Replies Created

Viewing 15 posts - 12,991 through 13,005 (of 13,459 total)

  • RE: Listener on port 1434

    i know the default UDP port is 1434, but could not find it anywhere in my registry;

    i've pasted a script below that finds the TCPIP ports being used, but i...

    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!

    August 4, 2006 at 2:09 pm

    #653431

  • RE: MINIMUM SECURITY REQUIRMENTS TO GENERATE SCRIPTS

    the public role is sufficient to give the user access to create the DDL for any table/view/proc;

    I just created a new user and gave them the public role to 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!

    August 4, 2006 at 7:22 am

    #653314

  • RE: Neighboring counties

    an interesting idea; i've got databases that have a lat/longitude for each county, so you could calculate where nearby counties are < 40 miles or something; but that's not 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!

    August 3, 2006 at 1:28 pm

    #653195

  • RE: TRUNCATE and FOREIGN KEYS

    to get the fk constraints related to a specific table, use the proc sp_fkeys:

    use pubs

    sp_fkeys titles

    results:

    pubsdbotitlestitle_idpubsdbo

    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!

    August 3, 2006 at 7:39 am

    #653089

  • RE: Single files defragment for SQL Server

    well my dev machine is just that...development, sample data, and if i take the service down to defrag, there's no real impact. , so i have a scheduled task of...

    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 24, 2006 at 10:48 pm

    #651252

  • RE: Need Expert Advice

    sounds like the application needs to be tweaked so that the name/connections to the server are parameterized and placed in an ini file, instead of hardcoded. an app should NOT...

    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 24, 2006 at 10:35 pm

    #651250

  • RE: Sql Server Access across remote machine

    you have to open a port in your firewall to allow your sql server to be visible to an outside IP address; further, if you are going to do this,...

    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 24, 2006 at 9:00 pm

    #651235

  • RE: Single files defragment for SQL Server

    if the file is in use, contig will skip the file, so yuo'd have to stop the server to defrag the mdf/ldf files;

    i have it scheduled on my dev machine...

    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 24, 2006 at 8:45 pm

    #651234

  • RE: Create and Execute permissions for stored procedures

    granting someone the role ddl_admin allows them to create procedures i believe, and by default anything they create they can execute.

    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 20, 2006 at 8:43 pm

    #650582

  • RE: Can this Query be tuned ? Mystery

    here's my suggestions, but by no means do i purport to be the ultimate guru of query tuning;

    #Source D and #Calculator_Table C are temp tables,make sure you put indexes...

    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 20, 2006 at 12:00 pm

    #650488

  • RE: Restore records

    to expand on what SQLZ said, with an ugly example:

    do this on test copies until you are sure:

    --identify the missing records, change the tablenames and dbnames to what is appropriate

    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 19, 2006 at 8:25 am

    #650121

  • RE: Installing SQL Server on windows xp sp 2

    installing SQL Server on a non-Server operating system automatically dummies itself down to MSDE; no need to download a dedicated executable. are you getting the dialog where you can install...

    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 19, 2006 at 8:17 am

    #650114

  • RE: sqlserver has been optimized for 8 concurrent queries

    SQL Server Express/MSDE has a limit to the number of concurrent queries,

    it's designed so a developer can test with the same codebase, but not with the same workload as...

    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 18, 2006 at 8:04 am

    #649793

  • RE: Collation problem with "like"

    i would have thought that differences in collation are what is breaking your comparisons.....but if all the columns are the same collation as the database, i would think that 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!

    July 18, 2006 at 7:56 am

    #649787

  • RE: Windows Permissions

    our shop thinks of DBA's as two different categories....there's development DBA's, which only need access to the databases in order to create schemas, write procs,review other developers code, etc.. That role...

    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 18, 2006 at 7:30 am

    #649774

Viewing 15 posts - 12,991 through 13,005 (of 13,459 total)