Forum Replies Created

Viewing 15 posts - 8,266 through 8,280 (of 13,460 total)

  • RE: product key

    I have this appllicaiton in my PortableApps collection: it finds keys for 2000/2005/2008, and ifg you know where the key to anything is stored, you can add it to 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!

    December 22, 2010 at 8:53 am

    #1265558

  • RE: SQL Mail Server with outlook pop3,smtp

    Elliott Whitlow (12/22/2010)

    Ok, SQL Sever must be using an either local account (created on the machine) or a domain account to login. This account is what the services use....

    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!

    December 22, 2010 at 8:10 am

    #1265534

  • RE: Whats the idea with this deterministic stuff????

    it has to do with your function...if you did not use WITH SCHEMABINDING in the definition, i'm sure the function is non-deterministic, and thus any column that uses the function...

    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!

    December 22, 2010 at 5:44 am

    #1265452

  • RE: Deny user to start and stop SQL services

    SSMS uses the extended stored procedures master.dbo.xp_sqlagent_monitor and master.dbo.sys.xp_servicecontrol to stop and start the services for the agent or the service on the server.

    those procs are called without...

    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!

    December 21, 2010 at 1:20 pm

    #1265255

  • RE: Deny user to start and stop SQL services

    Geoff A (12/21/2010)

    the ability to control SQL services via SSMS has nothing to do with SQL permissions.

    it is based on windows level permissions. local security and domain security policies.

    users in...

    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!

    December 21, 2010 at 1:03 pm

    #1265249

  • RE: Deny user to start and stop SQL services

    only a sysadmin has the ability to start and stop the server via SSMS; so do not give their login sysadmin and you are all set; just make them 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!

    December 17, 2010 at 1:49 pm

    #1264242

  • RE: Created database but used Model

    Kricky (12/17/2010)

    When I ran that query, I didn't get any results returned, so I will just let it finish. Thanks Adiga.

    kill it! kill it with fire!

    it doesn't matter 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!

    December 17, 2010 at 12:47 pm

    #1264217

  • RE: Indexed Views that contains a linked server

    for an index to be created, it has to be on an object that exists inside the database; that way constraints can be enforced.

    constraints cannot be created accross db boundaries.;...

    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!

    December 17, 2010 at 10:00 am

    #1264151

  • RE: Trigger on SELECT

    you might use soemthing like this to help track it down.

    this can give you the spid of who ran the offending statement if it was recently run:

    SELECT

    ...

    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!

    December 17, 2010 at 9:54 am

    #1264147

  • RE: Searching encrypted data in SQL server 2005, HELP!!!

    sangerex (12/17/2010)

    Thank for your reply, but i know that already and my supervisor required me to find a way solving that problem 🙁

    yep caught between the proverbial rock and 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!

    December 17, 2010 at 9:41 am

    #1264140

  • RE: Searching encrypted data in SQL server 2005, HELP!!!

    any field that needs to be searched should not be hashed; otherwise you are right, you can only get an exact match of hashed values; hashes are not sequential so...

    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!

    December 17, 2010 at 8:46 am

    #1264108

  • RE: Looking for a Simple Web Development Environment for SQL Server 2008

    there are some free reports from Microsoft that you can add to your Reporting Services:

    SQL Server Health and History Tool (SQLH2)

    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!

    December 16, 2010 at 2:20 pm

    #1263730

  • RE: DDL Trigger

    looks like the insert statement from your ddl audit has a table that doesn't allow nulls for the object name;

    i'm thinking that the creation of statistics might not generate 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!

    December 16, 2010 at 1:37 pm

    #1263699

  • RE: Add variable to @body in msdb.dbo.sp_send_dbmail

    it is actually deceptively simple...you just repalce a palceholder in the msg body with the variable actuial value ...just make sure the variable values cannot be null, and 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!

    December 16, 2010 at 1:29 pm

    #1263690

  • RE: Assign schema to tables without using commands

    From the GUI, you cannot; switching a table from one schema to another, at least in 2008, requires a script; there's no GUI to help you do it.

    The GUI lets...

    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!

    December 16, 2010 at 1:17 pm

    #1263682

Viewing 15 posts - 8,266 through 8,280 (of 13,460 total)