Forum Replies Created

Viewing 15 posts - 7,816 through 7,830 (of 13,460 total)

  • RE: Issue with CDC

    When SQL server runs out of disk space, it stops and tells you it ran out of disk space...it doesn't automatically disable CDC, trace, jobs or any other service from...

    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 6, 2011 at 6:05 am

    #1307950

  • RE: How to write a decent script to generate a cross reference?

    can you change things like the connection string of the web application?

    if you could get the web application to change the Application Name attribute on a per-page basis, you'd have...

    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 5, 2011 at 3:12 pm

    #1307741

  • RE: Link Server Issue

    you had previously said you had this setting "Be made using login's current security context" set."

    The typical issues for linked servers tend to be related to which security context you...

    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 5, 2011 at 2:04 pm

    #1307692

  • RE: Data from dataset to destination server table

    Steve how good are you with programming?

    I use this function as part of a larger ETL program i wrote; once I have a datatable, i can pass it to 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!

    April 5, 2011 at 12:31 pm

    #1307642

  • RE: Find who alter procedure

    if not too much time has passed, the default trace keeps track of DDL(CREATE/ALTER/DROP object changes)

    the easiest way is with a report that exists in SSMS:

    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 5, 2011 at 12:19 pm

    #1307639

  • RE: Creating a Cross-Reference table with the OUTPUT clause

    any chance of changing the schema? at least adding a column to be removed after the data transfer?

    whenever I've done a data migration like this, I've always added a column...

    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 5, 2011 at 10:06 am

    #1307569

  • RE: SQL Select part of string!

    what you want to do is wrap this up into a stored procedure, and use parameters;

    here's an example of the code, and then how to call it: note the procedure...

    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 5, 2011 at 9:18 am

    #1307525

  • RE: database tracing (sp_create_trace) not working as expected

    Dave did you get this settled and working?

    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 5, 2011 at 6:22 am

    #1307389

  • RE: How many SQl Servers install in LAN,

    finding network objects like SQL installations is one of those things that's actually easier to do outside of TSQL.

    I have used SQLRecon[/url] to discover all the servers on a given...

    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 5, 2011 at 6:13 am

    #1307386

  • RE: database tracing (sp_create_trace) not working as expected

    dave-dj (4/4/2011)

    Evening all,

    I'm trying to set up and SQL server trace using the create trace stored procedure. I generated the script in SQL Profiler and exported it.

    In 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 4, 2011 at 12:32 pm

    #1307119

  • RE: HELP ME !

    we need an evil version of "let me google that for you" that gives wrong answers.....it would be ideal for these situations.

    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 2, 2011 at 5:21 am

    #1306768

  • RE: if a database in use

    you can use some DMV's to see what has been used since the last time the server was started:

    if it's not on the lsit, it has not been accessed...but 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!

    April 1, 2011 at 12:33 pm

    #1306653

  • RE: Create a Read Only User on SQL Server 2005

    see this post that i did recently on creating a read only user that also could EXECUTE procs and functions;

    http://www.sqlservercentral.com/Forums/Topic1084522-5-1.aspx#bm1084563

    what you are asking is exactly the same, with one more...

    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 1, 2011 at 8:53 am

    #1306534

  • RE: Improving SQLServerCentral

    hehe reminds me of that previous April fools day when they said that Red Gate was taking over SQLServerCentral.com...

    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 1, 2011 at 7:06 am

    #1306453

  • RE: Creation date of a row

    to help you visualize, here's a prototype to review and get your head around it.

    assume you added a CreatedDate column today to a specific table.

    you restored a backup as suggested...

    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 1, 2011 at 6:31 am

    #1306432

Viewing 15 posts - 7,816 through 7,830 (of 13,460 total)