Database Discussion Boards

how i can do this?

<< never believe a lie >>

Have a look at this CP article[^]

Bob
Ashfield Consultants Ltd

<< never believe a lie >>

Now I'm confused - and not a little annoyed. I point you at an article that gives loads of info about using notification services and you reply with a load of confused.

You could also try google, or even buy a book - there are several gopod ones on the market

Bob
Ashfield Consultants Ltd

Have you studied SQL Server development at all?

“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan

I had an empty SQL database created on one of our internal machines. The admin gave me dbowner rights. At this point I need to know how to go about creating tables, queries, etc in that database. The last time I used MSSQL (8 years ago), I had physical access to the machine and could mess with it all I wanted. That's no longer the case. Is there something that I can install on my desktop to management it (so that I do not have to get the admin involved for every little change I need)?

Thanks.

DC

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

I'm in the same boat you're in...but I have a few words for you as a gift from one SQL Server newbie to another: "Microsoft SQL Server Management Studio Express" Smile | :)

Yes, I had previously seen this tool and it looked promising. My only reservation was that it was for MSSQL 2005 Express. Currently I do not know what version of MSSQL we have.

Thanks for the confirmation.

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

David is right, Management Studio is the tool you are looking for. I have a personal question for you. MVP, 5 years membership, 21 articles and you are a SQL newbie. Just what have you been doing, oh wait read the articles - Big Grin | :-D

Never underestimate the power of human stupidity
RAH

Mycroft Holmes wrote:
Just what have you been doing...

Not that it's any of your concern, but what I've been doing does not involve databases of any sort.

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

You're right it is none of my business but I'm so steeped in LOB applications that are all database oriented I was curious is all.

Never underestimate the power of human stupidity
RAH

Hey Guys,

I am trying to enhance queries that uses linked server (both servers aare SQL Server) and i am looking for fresh Ideas. I am working with a lot of data.

- I tried to copy data to a temp table and then use the temp table (with appropriate indexs) instead of querying the table in the remote server directly

- using OpenQuery - bad in loops

Would setting up views be a good idea? Any thoughts?

The most imprtant goal you have is that you don't fetch all the data through linked server and then perform joins, where clauses etc. Try to fetch only the data you need. This may require views and stored procs on both sides that help you eliminate the unnecessary rows as early as possible.

Mika

The need to optimize rises from a bad design.

My articles[^]

Thanks for your reply. If we have say 1 remote table that we are working with, I was thinking of creating a view of this table on the local server and then just query the view. But I am not sure if this will enhane the perfromance or not.

It's quite impossible to generally say if it helps or not. If you can write the view so that it restricts rows on target, it will help. What I'm after is for example something like this:

On local server
- SELECT * FROM View WHERE ... (returns 100 rows)
- view on local server fetches all rows from linked server based on a view on linked server

on linked server
- a view fetches only those rows that are potentially needed on the other side (let's say 1000 rows)
- the table on linked server has for example on million rows

So in the case above, there's only need to transfer 1000 rows (or less, depending on the view and the conditions in the select statement) through the link instead of million rows. This will greately speed up the operation.

Try using Query Analyzer (execution plan) to investigate what actually happens. This will give you a good idea about the bottleneck. If you cannot see operations performed on the linked server side via execution plan, you can bring all the data to the same database, investigate it and when row elimination is done as early as possible, implement the solution on both sides.

Hope this helps,

Mika

The need to optimize rises from a bad design.

My articles[^]

Thanks Mika, you were of great help. Thats exactly what I will try to do.

No problem Smile | :)

The need to optimize rises from a bad design.

My articles[^]

I often use table-valued functions rather than views because they allow parameters for more fine-grained filtering of rows.

We are currently using SQLServer 2000 and SQLServer 2005 with Microsoft Exchange as the mail server.

However, by year end, we must switch to the new corporate standard of Lotus Notes (do not know the version).

Assuming it IS possible to configure SQLServer to use Lotus Notes, can anyone provide insight and/or steps to configure this?

And, yes, I have searched for this; just asking for some advice from the trenches.

Any help is appreciated,

Tim

Sorry, no useful advice just sympathy, at a guess your company has just been taken over and had Notes imposed from above, sorry.

Never underestimate the power of human stupidity
RAH

HI,

Having the following issue and would really appreciate any help/guidence..

We have one SSIS package it will print an html page located in specific location according to the printer name getting from the table. This is working fine and printing to the installed printer on the server.

When we have scheduled a job , which executes the SSIS package it was printing fine in one server and which is 32 bit machine and not printing in 64 bit machine.

In more detail, the job is executing fine and showing the steps success. The log file showing the status that send to the printer. but in 64 bit machine it is not giving print out..No issues with the printer..

Suspecting some permission issue with sql agent on that machine..

Please help me to fix it out as it is eating my head! Confused | :confused:

Thanks,
Rahul.

SoftwareDeveloper(.NET)

If the printer is not connected directly to the server, but is a ntwork printer, check that the account you are using for agent has access to the printer in the domain. For example the account isn't local system, but a domain account and has sufficient privileges on domain level.

The need to optimize rises from a bad design.

My articles[^]

Hi Mika,

Thanks for the reply.Appreciating.

The printer is a n/w printer. The account used for the agent has access to the printer. The account used is the admin user for the server.

Another one thing I have noticed is that, when we execute the package as sql utility it is not printing but when we execute the package manually from the folder it is printing..

Will this info help you to provide some more guidence?

Thanks,
Rahul.

SoftwareDeveloper(.NET)

What is the command you're using for printing (sp's involved etc)?

The need to optimize rises from a bad design.

My articles[^]

Here is the code used in the SSIS to print. Procedures used to retrive the printer name. The thing is that , it is updating the log file as doc send to the printer.. for eg: doc1 send to the printer \\nw path\printer name. One more differenc I noticed is that, in that 32 bit machine where it is printing fine having IIS installed but the 64 bit machine not having IIS installed..Will this affect when print using a job ?

PrintStatus("PrintStatus").Value = 3
flgFindPrinter = False
AttemptCount = -1

While (Not flgFindPrinter And AttemptCount < MaxRetryAttempts("MaxRetryAttempts").Value)
    Dim prnDoc As New System.Drawing.Printing.PrintDocument
    For Each prn As String In prnDoc.PrinterSettings.InstalledPrinters
        If prn.ToLower = PrinterName("PrinterName").Value.ToString.ToLower Then
            flgFindPrinter = True
        End If
    Next

    PrintStartTime("PrintStartTime").Value = Date.Now

    If flgFindPrinter Then
        defaultPrinter = prnDoc.PrinterSettings.PrinterName

        Dim wsNetwork As Object
        Try
            wsNetwork = CreateObject("WScript.Network")
            wsNetwork.SetDefaultPrinter(PrinterName("PrinterName").Value)

            Dim IE As Object = CreateObject("InternetExplorer.Application")
            IE.navigate(FolderPath("AbsoluteFolderPath").Value & DocName("DocName").Value)

            While (IE.QueryStatusWB(6) <> 3)
                Threading.Thread.Sleep(500)
            End While

            IE.ExecWB(6, 2, Nothing, Nothing)

            Dts.Events.FireInformation(1000, "Print Document", FolderPath("AbsoluteFolderPath").Value & DocName("DocName").Value & " Successfully Printed to " & PrinterName("PrinterName").Value, "", 0, False)
        Catch ex As Exception
            Dts.Events.FireInformation(2000, "Print Document", ex.Message, "", 0, False)
            PrintStatus("PrintStatus").Value = 2
        Finally
            If wsNetwork IsNot Nothing Then wsNetwork.SetDefaultPrinter(defaultPrinter)
        End Try

    Else
        Dts.Events.FireInformation(2000, "Print Document", PrinterName("PrinterName").Value & " Not Found", "", 0, False)
        PrintStatus("PrintStatus").Value = 2
    End If
    AttemptCount += 1
End While

Dim strLog As String
If flgFindPrinter Then
    strLog = FolderPath("AbsoluteFolderPath").Value & DocName("DocName").Value & " Successfully Printed to " & PrinterName("PrinterName").Value
Else
    strLog = FolderPath("AbsoluteFolderPath").Value & DocName("DocName").Value & " Failed to Print on " & PrinterName("PrinterName").Value
End If
If AttemptCount <> 0 Then
    strLog &= " With Retry Attempts " & AttemptCount
End If

LogDescription("LogDescription").Value = strLog
RetryAttempts("RetryAttempts").Value = AttemptCount

Dts.TaskResult = Dts.Results.Success

SoftwareDeveloper(.NET)