Forum Replies Created

Viewing 15 posts - 28,771 through 28,785 (of 39,771 total)

  • RE: Sharing data between two databases

    One more thing, if you are accessing lots of data from other databases because there are separate apps, then you can combine those into one database using schemas IF your...

  • RE: Sharing data between two databases

    go into the Database, select the Security folder, there's a Schema folder under there. You can create, set an owner, grant rights to a role (NOT users), etc.

  • RE: Running an external exe file using XP_CMDSHELL

    It should work as you've pasted in. I get a command string of:

    "C:\Program Files\KeyGen\vgenlic.exe" pippo pppppp 3

    If that runs from a command prompt, it should work. I'd perhaps grab the...

  • RE: How do I put the Server back into multi user mode?

    As my Zoo keeper friend mentioned, remove the -m parameter and you should be ok.

  • RE: What's important for monitorring?

    I like Kyle's thoughts. Backups are the most important. Be sure you know that every database has been backed up or you get a notification and can do something immediately.

    I've...

  • RE: Cannot generate SSPI context error message

    SSPI are Windows authentication errors and, I believe, issues with the Kerberos ticket.

    I've seen this act strangely in a variety of ways. Perhaps the client can't get the SPN for...

  • RE: Database backups best practice

    Mike,

    I've never had issues restoring from a good file, but I have had files get corrupted and be unable to back up to them. granted it's typically when I've walked...

  • RE: registration

    Mike,

    Sorry for the delay and it's good to get the info from your side. I haven't seen that behavior, but I'll pass along to our support people and see if...

  • RE: Identity Columns

    Easiest depends on the answers given. We don't try to always pick the best of all possibilities. We try to pick questions to get you to think or help you...

  • RE: IT salary is going down !

    I'm not sure that I think salaries are going down for talented workers, especially in data fields. I think the sysadmins, especially MSCEs might get paid less, and workers in...

  • RE: SQL Server 2005 Express on XP SP 1

    Use Virtual PC (free), and install XP SP2 in that. There's no way around the XP SP2 limitation. Some of the things they need in SQL Server 2005 are in...

  • RE: Restoring an SQL database

    I think George it right. be sure you're restoring from the clustered server and not one of the instances on one of the boxes.

  • RE: synchronize login process

    The statement "synchronize login process" doesn't mean anything by itself. Ask someone specifically what they want you to do, or what effects they mean (same logins on two instances or...

  • RE: DBCC Checkdb consistency errors

    Repair is a bad idea. As Paul gave a talk last year at TechEd and walked through what happens. Basically they have no idea how to fix things and they...

  • RE: Help on writing code in a way other than using SQL cursor

    This is really a crosstab report and the new PIVOT command can help here. I'd look that up and try a few possibilities with your table.

Viewing 15 posts - 28,771 through 28,785 (of 39,771 total)