Forum Replies Created

Viewing 15 posts - 7,096 through 7,110 (of 13,460 total)

  • RE: Cannot do a simple BULK INSERT!

    also, there's two places to look;

    I believe if you have set up a proxy account, if you are sysadmin, it will use that account no matter what, and that account...

    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!

    July 22, 2011 at 2:07 pm

    #1357291

  • RE: SQL server interview question!

    my answers:

    Hi,

    I am new to sql server administration. And I was asked this question in one of my interview.

    You are unable to connect to sql server. Where do 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!

    July 22, 2011 at 12:32 pm

    #1357235

  • RE: Regular activities of SQL DBA (L1 person).....

    take a look at Brent Ozar's Blitz! 60 Minute Server Takeovers , he's got a nice analysis script of stuff to look for when you walk into a new...

    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!

    July 22, 2011 at 11:40 am

    #1357208

  • RE: URGENT, delete reports from report server programmatically

    Ninja's_RGR'us (7/22/2011)

    I don't think VB can work here.

    Even tho the files are in "folders" it's all kept in the RS database so there's nothing to loop through on the HD.

    ahh...my...

    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!

    July 22, 2011 at 10:06 am

    #1357167

  • RE: URGENT, delete reports from report server programmatically

    here's a simple example in VB: if you're not familiar with programming , you might want to call upon a peer to do the deleting for 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!

    July 22, 2011 at 9:59 am

    #1357160

  • RE: Migration of databases

    don't forget to script your logins from the old server to the new one with sp_help_revlogin

    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!

    July 22, 2011 at 9:51 am

    #1357155

  • RE: Microsoft offering $250,000 reward

    hmmm.. running a huge botnet like that ...i think you'd have to be an MCTS ...maybe a MCITP....youknow BSCS and OCA/OCP might be handly...hm....

    who do i know that fits those...

    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!

    July 22, 2011 at 9:48 am

    #1357149

  • RE: how to move resource database

    resource database is small to begin with;

    i'd look at whatever is eating up your disk space.

    where are the backup files being created?

    look for log files from traces you forgot about...

    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!

    July 22, 2011 at 8:20 am

    #1357078

  • RE: Grant permission to access only 2 tables in a database

    SQL is very restrictive rights wise...users only get what you give them access to. You want to avoid things like just granting a user db_owner status or any other roles...

    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!

    July 22, 2011 at 7:40 am

    #1357042

  • RE: Audit, track database connections / logins to a table ?

    win your triggers pretty close to mine, it just has few issues:

    permissions: MOST users will not have access to that audit table you are inserting into...so the end result 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!

    July 22, 2011 at 7:14 am

    #1357033

  • RE: Query fail when using only table name

    i beleive the fix is to change the users default schema...which doesn't necessarily allow them to create tables.

    http://msdn.microsoft.com/en-us/library/ms176060.aspx

    --from BOL ~ slightly changed

    ALTER USER Mary51 WITH DEFAULT_SCHEMA = dbo;

    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!

    July 22, 2011 at 6:35 am

    #1357007

  • RE: Query fail when using only table name

    isdn't the core issue that the user is not using the default dbo schema, so , for example, the user "Orange" creates a table Orange.Invoices instead of the expected dbo.Invoices.

    compatibility...

    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!

    July 22, 2011 at 6:24 am

    #1356998

  • RE: User Defined Function called from a Stored Procedure only returning a single character.

    ALTER function [dbo].[udf_parseWidth](@strvalue varchar(500)) returns varchar as

    in this case, a varchar with no size is a varchar(1)

    explcitly change it to returns varchar(500) as or whatever you are expecting.

    you might be...

    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!

    July 21, 2011 at 3:02 pm

    #1356770

  • RE: need help with the code

    datetimes should be kept in the database as datetimes...otherwise you get this kind of issue, where you have to convert it to datetime,a dn then convert it back out 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!

    July 21, 2011 at 2:58 pm

    #1356765

  • RE: sql inbound error while executing - please help

    you'll have to explain what the actual error message is...i cannot think of what an "inbound error" might be.

    your query doesn't join sep5.V_ALERTS ti sep5,V_SEM_COMPUTER...so that's an ugly cross join...

    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!

    July 21, 2011 at 1:35 pm

    #1356700

Viewing 15 posts - 7,096 through 7,110 (of 13,460 total)