Forum Replies Created

Viewing 15 posts - 12,316 through 12,330 (of 39,963 total)

  • RE: Tempdb issue

    If you grow the files, they should be at that size on restart. Are you sure you manually grew them and didn't just assume they'd stay the same because they...

  • RE: SQL 14 Installation

    The Azure test is interesting, however I'd recommend you set up a virtual machine. Lots of free players, including Virtual Box.

    you can then go through the install yourself.

  • RE: Creating Deployment Change Script from the Source Database Only

    I assume you want a create or alter script of some sort. the problem is that you are always working with two versions to generate changes. Otherwise, how can you...

  • RE: Your Frame of Reference

    Jamie Ingram-729524 (7/8/2013)


    Can I just whinge about the link to the updateable snapshot?

    What's wrong with updating the base table and then regenerating the snapshot? This is a far better solution...

  • RE: Update Novell eDirectory from a SQL Server database

    How does the eDirectory process work? Something there must be reading data from SQL Server. Once you understand how the process works (maybe use Trace), you can move forward.

    duplicating this...

  • RE: log differences

    First, if this is interview/homework, please identify it.

    Second, you should do some research yourself. There is a lot of documentation.

    Third, semantically, I'm not sure what you mean. SQL Server has...

  • RE: stored procedure unable to find file on another server

    Jim has given you good advice.

    Note that when you run something, it isn't your account that runs it. It is the service account for SQL Server, not the user connected....

  • RE: prerequisites

    Note that in addition to sean's reference, there isn't just "replication" in SQL Server. There are different types, and the complexity, monitoring, and administration is different for them. You should...

  • RE: Are the posted questions getting worse?

    Notifications working for people? Seem like the queue might be stuck.

  • RE: Depending on CurrentStatus will determin where to pull the values from

    Not sure if this is more efficient and you'd have to test, but you could join with an OR and then use a CASE statement.

    Select

    case

    ...

  • RE: SQLServerCentral Runs sp_Blitz - Informational Items

    TheSQLGuru (7/6/2013)


    I am wondering why you are using the older 1204 for deadlock information instead of (usually more useful) 1222.

    No idea. I'll have to ask.

  • RE: issue with tempdb

    You are right (as usual), Gail. I thought it would start in read-only mode, but sure enough I get a failure.

    The problem is probably rights. Your system cannot open c:\xxx.mdf...

  • RE: issue with tempdb

    There should be information in the SQL Server error log about it starting. Look for that. tempdb being broken doesn't prevent the instance from starting.

  • RE: Independence Day 2013

    jasona.work (7/5/2013)


    Hmm, can we amend that to be:

    We hold these truths to be self-evident, that all men are created equal, that they are endowed by their Creator with certain unalienable...

  • RE: Are the posted questions getting worse?

    Hope everyone had a good Fourth. My day?

    We leave late for the mountains (1), hit traffic (2), Tia's hungry, but everywhere in Idaho Springs is packed and busy (3). Hit...

Viewing 15 posts - 12,316 through 12,330 (of 39,963 total)