Forum Replies Created

Viewing 15 posts - 4,531 through 4,545 (of 13,459 total)

  • RE: Grant Permission to a table with restriction to data

    kapil_kk (10/22/2012)

    how can we restricted a view to a particular user only?

    you can do that either by checking the suser_name(), or comparing it agasint a table of permissions you create.

    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!

    October 22, 2012 at 11:13 am

    #1551549

  • RE: Create and populate a Zip file

    Jim the single set of double quotes is an xp_cmdshell thing;there's only the classic extra-step work arounds.

    the work around is to either use a variable, or create 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!

    October 22, 2012 at 11:06 am

    #1551541

  • RE: Clearing out msdb.dbo.sysmail_mailitems...

    jasona.work (10/22/2012)

    My thanks to Lowell!

    Using your Delete commands, plus adding one to delete from dbo.sysmail_mailitems, the DB is down to about 23GB from 133GB!

    Set up an Agent job to run...

    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!

    October 22, 2012 at 9:54 am

    #1551484

  • RE: Stored Procedure Generator

    the http://www.ssmstoolspack.com/ is free and very popular among some of the psoters here.

    it has a built in CRUD generator, so you can right click on a given table and 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!

    October 22, 2012 at 9:03 am

    #1551418

  • RE: SQL Parse??

    i've played with Microsoft.SqlServer.Management.Smo.Scripter that is part of the microsoft.sqlserver.managment.sdk.sfc ;

    using that, you can tokenize any SQL statement.

    i did it when i was playing with making my own SQL reformatter/prettifier,...

    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!

    October 22, 2012 at 8:27 am

    #1551396

  • RE: Changing setting for first day of the week

    matt.gyton (10/22/2012)

    Hi Lowell,

    These are just standard SQL Agent Jobs being run on a schedule, so I'm assuming I could just change the default language setting for the login they are...

    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!

    October 22, 2012 at 7:09 am

    #1551361

  • RE: How to convert the integer value to datetime

    sanjay.dakolia (10/22/2012)

    this value was suppose to be datetime but by mistake the column datatype was given integer so now i want to convert it back to datetime

    um, i don't think...

    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!

    October 22, 2012 at 6:30 am

    #1551339

  • RE: How to convert the integer value to datetime

    sanjay.dakolia (10/22/2012)

    hi i am new to sql and i have the following problem

    i am using the following query :

    select cast (1157068800 as datetime)

    but i am getting this error :

    Msg 8115,...

    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!

    October 22, 2012 at 6:21 am

    #1551331

  • RE: Reading a string from windows command variable

    you mean like resolving %appdata% or %path% from a command line or something like that?

    yes, assuming you've enabled xp_cmdshell;

    create table #Results (

    ID int identity(1,1) NOT NULL,

    TheOutput varchar(1000))

    insert into #Results (TheOutput)

    exec...

    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!

    October 22, 2012 at 6:17 am

    #1551326

  • RE: Changing setting for first day of the week

    those set options are connection specific; they are not server wide.

    just because you set it someplace, does not mean it's going to affect jobs or anything else on 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!

    October 22, 2012 at 6:10 am

    #1551323

  • RE: Extract text which is between 1st and 2nd comma

    probably the best most recommended way would be using the delimited split function.

    there's also a CHARINDEX2 custom function you could use as well.

    /*

    --Results

    val ...

    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!

    October 22, 2012 at 5:44 am

    #1551314

  • RE: rssbus Quickbooks Connection Error

    Jeff when i did a project using rssbus for quickbooks i ended up writing an applicati:-Don that read qb info into tables on my server, so i had snaphots 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!

    October 21, 2012 at 7:36 am

    #1551156

  • RE: Database Mail Error

    relaying is forwarding/sending to email addresses that are not administered by the specific server you are conecting to...for example, if my server is the google's gmail, then emails to @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!

    October 20, 2012 at 5:49 am

    #1551110

  • RE: Extract .DOC files from database to File System

    Aijaz Ahmed Mir (10/19/2012)

    thanks for your reply. is there any tool/script to extract the documents.

    regards

    aijaz

    this is a job for a programming language; here's an example in vb.net for 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!

    October 19, 2012 at 1:52 pm

    #1551048

  • RE: How can I create registration and login in SQL server 2008?

    we don't know what your preferred programming language is;

    here's a link to an article on how to make a registration form in asp.net;

    if you prefer php or something else, just...

    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!

    October 19, 2012 at 12:27 pm

    #1551011

Viewing 15 posts - 4,531 through 4,545 (of 13,459 total)