Forum Replies Created

Viewing 15 posts - 4,936 through 4,950 (of 13,460 total)

  • RE: Find Usage of Column in Related Views

    ok hang on, i believe that code returns procedure or function dependancies...testing it now;

    i have a couple of otehr examples too.

    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 15, 2012 at 1:31 pm

    #1526199

  • RE: Find Usage of Column in Related Views

    there sure is:

    this example will give you all columns that have a certain name;

    if you want to specifically limit it to a specific table also, simply uncomment out the table...

    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 15, 2012 at 1:28 pm

    #1526196

  • RE: How to copy all objects from one server to another server?

    the best, most foolproof way is to backup the database, and restore it on the other server, with whatever name you would like. That is the standard recommendation.

    everything other than...

    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 15, 2012 at 12:28 pm

    #1526152

  • RE: How to escape the ^ symbol in the following function

    would you expect your function to remove high ascii characters as well?

    i had posted a solution in your other thread on a similar strip function;

    what would you expect 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!

    August 15, 2012 at 10:52 am

    #1526110

  • RE: How was the record deleted!!

    if a transaction rolls back or fails, the identity() columns still increment.

    it sounds like an error occurred inserting the data that was not handled/reported by the .net application.

    i've seen...

    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 14, 2012 at 3:39 pm

    #1525820

  • RE: error using linked server and EXECUTE AT

    linked servers are slow for updates; it's usually because the far table (which might be huge) gets copied over into a local temp table, then the data is merged 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!

    August 14, 2012 at 3:22 pm

    #1525810

  • RE: error using linked server and EXECUTE AT

    lets double check some settings...by abstracting out your code to be anonymous (SERVERA and SERVERB, something got lost, i think.

    first, i don't think its necessary to use EXECUTE AT.

    you can...

    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 14, 2012 at 3:04 pm

    #1525804

  • RE: Issue with Linked server permissions

    i think only simple DML queries will work on 4 part names;

    you have to issue commands like that with EXECUTE.. AT for commands, SET or DBCC options.

    EXECUTE ( 'set IDENTITY_INSERT...

    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 14, 2012 at 11:46 am

    #1525699

  • RE: Linked Servers and Security Concerns

    sandeep rawat (8/14/2012)

    I do agree on the point in case of if linked server is also SQL server .

    But in that case u should have same set of user name...

    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 14, 2012 at 8:40 am

    #1525561

  • RE: Alternative to cdc for Standard Edition - Output clause or Triggers?

    check out this project over at codeplex:

    http://standardeditioncdc.codeplex.com/

    it is a project that someone built that ads a CDC-equivilent to 2008 Standard.

    StandardCDC is a project to enable customers on Standard Edition SQL...

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

    #1525552

  • RE: tablet ipad or nexus 7 or kindle fire ?

    I've got the Kindle Fire, it's great for what it does. I got mine at Christmas 2011, so I've had it for 8 plus months.

    Email, web, some cute apps all...

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

    #1525492

  • RE: Checklist to troubleshoot low disk space issues in SQL server

    well, it depends on how your server is used.

    C:\Windows\System32\LogFiles is the default location for some log files, and the IIS and the ftp service might generate log files in some...

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

    #1525348

  • RE: Checklist to troubleshoot low disk space issues in SQL server

    things i would look for

    :

    review each database on the server. How many have huge log files? this post from today is a nice start:

    http://www.sqlservercentral.com/Forums/Topic1343996-391-1.aspx

    how many of the databases 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!

    August 13, 2012 at 6:56 pm

    #1525346

  • RE: Trigger to rollback if no PK assigned

    ok, inside a DML trigger, here's what is happening in SQL server:

    the values someone changed, are already in the table WHATEVER. if you query the table inside the trigger, 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!

    August 13, 2012 at 3:26 pm

    #1525310

  • RE: Trigger to rollback if no PK assigned

    you shouldnt' assume the commands start with your expected keyword..comments, whitespace, lots of other things can prevent you from determining it was insert/update.delete.

    i would do it like this, using 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!

    August 13, 2012 at 3:02 pm

    #1525298

Viewing 15 posts - 4,936 through 4,950 (of 13,460 total)