Forum Replies Created

Viewing 15 posts - 8,431 through 8,445 (of 13,460 total)

  • RE: set password for particular db

    SQL server is already like that...once the sysadmin restores or creates a database, NOONE has access to it, except the sysadmins.

    as long as no one except the dba has sysadmin...

    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!

    November 15, 2010 at 4:49 am

    #1250627

  • RE: which datatype is suitable to store more than 8000 char in sql server 2008

    Rajendra.soni (11/15/2010)

    Hi,

    in SSMS, Tools --> Options --> Query Results --> Results to Grid --> Max characters Retrieved --> Non XML Data ,

    it...

    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!

    November 15, 2010 at 4:41 am

    #1250622

  • RE: Where is place to store description of Columns?

    there is a view you can select from, and a function that you can use as well:

    select * FROM fn_listextendedproperty (NULL, NULL, NULL, NULL, NULL, NULL, NULL);

    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!

    November 15, 2010 at 4:34 am

    #1250621

  • RE: set password for particular db

    like i mentioned before, the only solution is to take away the sa login from everyone, and make them login with something else.

    in a place where everyone has been using...

    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!

    November 15, 2010 at 4:27 am

    #1250619

  • RE: I'm trying to create Full-text catalog

    it sounds like the password that is stored for running the full text service is out of date/changed;

    Control Panel>>Administrative Tools>>Services>> find the full text service (my 2008 was named "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!

    November 14, 2010 at 9:32 am

    #1250439

  • RE: set password for particular db

    jangidsatish148 (11/14/2010)

    how to set password for particular db in sa login

    you'll want to revamp how you are currently doing access;

    first, to be clear, a login has one password only. 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!

    November 14, 2010 at 9:18 am

    #1250438

  • RE: white space in path

    what you'll need to do is make sure any paths for file names exist in double quotes...that is what the OS requires for file names with spaces; my dbl quotes...

    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!

    November 14, 2010 at 5:28 am

    #1250418

  • RE: Removing invalid entry from System Catalog

    the problem is not about cleaning system views; it's that the old views can now give you inaccurate information; using the newer correct views will solve the issue.

    the trouble is...

    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!

    November 11, 2010 at 3:05 pm

    #1249752

  • RE: Sending email and setting calendar from trigger

    i thought this was interesting; from what i read on the Wikipedia you have to create a plain text attachment, with specific tags/formats inside that file, and the name of...

    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!

    November 10, 2010 at 10:23 am

    #1249038

  • RE: Julian date to regular date conversion

    it depends on the format of the julian date; here's a couple of examples, but post back how your data is formatted;

    DECLARE @sdate int

    SET @sdate = 109252

    --in AS400/DB2 date is...

    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!

    November 5, 2010 at 3:07 pm

    #1247348

  • RE: trigger taking forever

    can you show us the real trigger instead of pseudocode?

    it's running too long because there's an issue, but translating the real trigger to pseudo masks the real problem.

    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!

    November 5, 2010 at 7:04 am

    #1247095

  • RE: Alert to monitor DBCC CheckDB

    Gianluca Sartori here on SSC posted the code below in another thread, and i really like how well it works. this might help you with what you were after...it...

    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!

    November 4, 2010 at 2:09 pm

    #1246843

  • RE: Is xp_cmdshell the only option?

    GSquared (11/4/2010)

    Since VB.NET can create text files pretty easily, a CLR proc would do the job, and be more secure than xp_cmdshell.

    how would you get the CLR to write 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!

    November 4, 2010 at 1:55 pm

    #1246832

  • RE: Select * from a table with one billion rows failing

    maybe he was doing a select * from BillionRowTable so he could see the column names, and the error threw him off.

    He may not be familiar with sp_help [TableName] yet.

    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!

    November 4, 2010 at 1:31 pm

    #1246797

  • RE: How to store 1/3rd in the database

    i would consider leaving the transaction table alone, with one row per transaction, and add a payments table with a FK to the transaction.

    that way you can have one to...

    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!

    November 4, 2010 at 12:28 pm

    #1246753

Viewing 15 posts - 8,431 through 8,445 (of 13,460 total)