Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. paskuda

    Reconnecting network drive on wireless connection

    Hi, We're having a painful problem here. There is a network drive on the workstation mapped to a share on a server, say, \\server\myShare. The connection between workstation and server is wireless - workstation connects to a Linksys AP. The drive is set to reconnect after windows restart. The...
  2. paskuda

    Control .AVI playback in the movie

    OK, I found some suggestions to use .wmv instead, I converted my clip and now everything's working great. Still I wondr - why isn't it possible to control divx in the same way? Or is it? Mike
  3. paskuda

    Control .AVI playback in the movie

    Hello, I'm a total beginner, so sorry if I'm asking a stupid question, but I've been googling for two hours now on and can't find the answer. My problem is: I imported a movie into the cast, it's a DivX movie. I placed it on the Stage and it's playing fine, as soon as I start the movie. What...
  4. paskuda

    A little different table rotation ...

    ESquared, Yeah, I tried doing that, whatever. That was not what I meant, try creating the table I posted and rotate it with PIVOT the way I want - if you can, that's great, give me the code and make me happy :) I couldn't achieve that with PIVOT. Anyway, I solved the problem by writing a custom...
  5. paskuda

    A little different table rotation ...

    Pivot needs some aggregation. I do NOT want to aggregate anything. I just want to rotate the table, so values in column one become column names, and values in column2 create ONE single row. I don't think I can achieve that with pivot ...
  6. paskuda

    A little different table rotation ...

    Suppose I have a table like this: ID NAME 1 John 2 Ann 3 Mike etc, etc ... ID column is unique I need a query to return a table like this: 1 2 3 John Ann Mike The IDs become the column names and there is only one row of data. Any ideas? I...
  7. paskuda

    Requirements for dtsx execution

    Thanks :)
  8. paskuda

    Requirements for dtsx execution

    Thank you for the answer. Than means, that if I have a package which is prepared on a machine with SSIS installed and all I want to do is run it on another computer - no modifications - SQL GUI is enough. The package will be fully functional, but I will not be able to redesign it. Did I get it...
  9. paskuda

    Requirements for dtsx execution

    Hi, recently I had an opportunity to talk to MS trainer about SSIS, he told me that an advantage of .dtsx packages is that it's possible to run them from any computer - I just have to prepare a package and then I can distribute it to other computers and run it. Some things are a mystery to me...
  10. paskuda

    how can i allow domain users to acces ms sql server 2005?

    First, create the login for a user. CREATE LOGIN [Domain\User] FROM WINDOWS If you want to give that user a fixed server role use: EXECUTE sp_addsrvrolemember loginname, rolename If you want to give access to database you have to create user in the database for the login and grant him a role...
  11. paskuda

    Deleting File on FTP Server after DTS Pull

    Read Priyank Gajera's post at the end of this thread. He wrote a script task to remove the files. The problem you have is well known issue with non-windows ftp servers and is not fixed yet.
  12. paskuda

    Login to an FTP site, Retrieve and then remove a file

    You can use a ftp task to delete remote files, just set the operation to DeleteRemote. There's only one problem - if the remote machine is non-windows then you will probably get an error "FTP Task: Unable to delete remote files", which is a known issue and should be fixed in next major release...
  13. paskuda

    SQL Server 2008 and Security

    I have SQL Server 2008 CTP installed but haven't tested any of the new features yet.Some of them are, or at least seem to be, pretty interesting. Transparent data encryption is one of them, MS states that it will be possible to encrypt whole database, data files or log files transparently to...
  14. paskuda

    Error setting up Distributor

    As far as I remember, that happens when the network name of the machine SQL Server is working on is different from the value of @@SERVERNAME global variable. I found that script: USE master DECLARE @network_name varchar(100), @sql_server_name varchar(100) SELECT @network_name =...
  15. paskuda

    Line drawing problem - pen changing color

    Chip, Thank you for your reply. 1. It's an LCD display, I'm working on IBM R50e laptop 2. I didn't have it on, now it's o, no change I uploaded a screenshot of my form - it's here. I know it's large, but I didn't want any compression, I wanted the image to be exactly the same as in my program...
  16. paskuda

    Line drawing problem - pen changing color

    Hello, I just started learning C# and have a problem with drawing. I have a small piece of code where I draw to a bitmap defined in memory and then draw the bitmap on the form using the Paint event. I have a piece of code like this : Graphics objGraphics; Pen mypen; // some code I cut mypen =...
  17. paskuda

    Database design question - 1:2 relation

    Hello, Thank you all for your help and suggestions. I decided to use Olaf's design 1. I'm going to write the application using the database, so I can programatically limit the amount of teams assigned to one fixture. It's more important to keep team+fixture data in separate rows. ceh4702, I'm...
  18. paskuda

    Database design question - 1:2 relation

    Hello, I'm designing a small database where soccer results are going to be stored. I have created following tables: FB_Teams, with primary key I_TEAM_ID, storing team data. FB_Competitions, with primary key I_COMPETITION_ID, where I want to keep details of leagues, cups, etc. As most of you...
  19. paskuda

    Formatting query output in Query Analyzer

    I think I have accidentally changed something in query analyzer settings and can't find the way to return to previous settings. Whenever I select data from integer type columns return is formatted as a float value. For example - if value stored in a row is "20" then the result in output table is...
  20. paskuda

    check constraints

    Try this: USE your_database_name select constid,[id],colid,status from sysconstraints constid is a constraint id, id - table id, colid - column id, status - indicates a constraint status. Possible status values (from Books Online): 1 = PRIMARY KEY constraint. 2 = UNIQUE KEY constraint. 3 =...

Part and Inventory Search

Back
Top