Search results for query: *

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...

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

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...

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...

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 ...

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...

Thanks :)

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...

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...

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...

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.

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...

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...

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 =...

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...

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 =...

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...

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...

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...

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 =...