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 Rhinorhino 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: *

  • Users: Andel
  • Content: Threads
  • Order by date
  1. Andel

    Slow Replication Monitor (SQL 2005)

    In replication monitor, when I expand a Publisher to see my publications, it will take too much time to expand. The monitor shows "<MYSQLSERVER> (expanding...)" for a long time then eventually expands. Is there any setting for this to make it faster?
  2. Andel

    Splitting One Column into 4 columns

    Hello, I have a table with one column and i want to split it into 4 columns. Values are comma delimeted. Is there a way using SQL query alone? Column1 ====================== C,18432,6196,12236 E,409595,112464,297131 H,407548,11915,395633 I want the output to be: Drive Capacity Used...
  3. Andel

    Assigning a default value on RadioButtonList

    I'm trying to assign a default value to my radiobuttonlist but for some reason the following code gives "Build Failed" when I publish my web. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If IsPostBack = False Then...
  4. Andel

    Working with UniqueIdentifier field (UserID)

    I ceated a table with a UserID field. This is a uniqueidentifier type field. (I would use this as foreign key of the UserID from aspnetdb..aspnet_users table.) The problem is that I can't figure out how to insert data in it. Here's my current code. Protected Sub btnSubmit_Click(ByVal...
  5. Andel

    Is there any way to Resize a LoginView control?

    I cannot figure out how to resize my loginview control. I want to make it wider so that i can position my texts better.
  6. Andel

    RAISERROR within SQLServerAgent job

    Hello folks, I'm trying to use RAISERROR on my stored proc to log an error message to the event log. This is fine. The problem is, when I use SQLServerAgent to run the stored proc, the sqlagentjob reports failure everytime. How can I use the raiserror command and have the sqlagent job reports...
  7. Andel

    Changing Database Owner

    Is there a way to change the database owner using sp_changedbowner stored proc without having to be executed in the current database? I have a script that creates a database and suppose to change the db owner right after creation. I cannot use the 'USE <Dbname> command because it requires a...
  8. Andel

    Text field won't display correctly

    Hello, I have a text field which hold a whole body of an Article. When I display this field using DataList, it becomes 1 paragraph. Seems like the 'enter' key disappear. In classic ASP, I have this function to resolve that. <% Function PrepForHtml (strDirty) Dim strClean If IsNull(strDirty)...
  9. Andel

    How to Retrieve Data from SQLDataSource Directly?

    I have a SQLDataSource which returns only one row. From that row, I'd like to read a column and display that into my page using a label. Here's my current code that doesn't work: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load...
  10. Andel

    How to access the selected value in a GridView in VB

    How could I access a cell value in a GridView control using VB? Basically, i have a gridview that displays records from a table. When I select a record from the Gridview, I want a certain column (from the selected record) to be displayed in a label control. Thanks in advance. Andel...
  11. Andel

    How to round numbers to the nearest integer?

    For example, 956 should round to 950 985.5 should round to 1000 145 should round to 150 and so on... How to script this in sql? I'm trying to use the ROUND function in sql but it doesn't work. Thanks for your help. Andel http://www.iluko.com
  12. Andel

    How to prevent visitors from inputting very long words in my forum?

    Some visitors are making fun of my forum, like entering any kind letters like "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx". I'd like asp to detect these long words in my forum and prevent it from being posted. Thanks in advance. Andel andel@barroga.net...
  13. Andel

    Configuring Memory for Analysis Services

    We are starting to use Analisys Services and need some recommendations from you guys. SQL Server and Analysis services sit in one server. Is there any recommended settings that I need to be aware of? Like, SQL Memory, etc??? Here's the description of the server that I got: Hewlett Packard...
  14. Andel

    How to Report Failure in a Multi Steps job

    I have a scheduled job which backup all databases on my server. I have 10 databases to backup, so I created 10 job steps -- one job step per database. If the first step fails, I want SQL server to continue on with the rest of the steps (step 2 - 9) without quiting. So, even though steps 2 - 9...
  15. Andel

    How to transfer Enterprise Manger settings?

    Is there a way to transfer Enterprise manager settings from one server to another? I registered and group a lot of servers in one of my machine and I want to transfer that same setting to my other machine. Is there a way to do that without adding them manually again? Andel andel@barroga.net...
  16. Andel

    XP files can't see Win2k3 files and vice versa

    Hello, I posted this in Win2k3 forum but this is also for XP: I installed Windows 2003 server and Windows XP on my computer with 250GB hard drive. I partition the hard drive as follows: C drive - 25GB (primary) F drive - 25GB G drive - 50GB H drive - 50GB I drive - 100GB When I installed...
  17. Andel

    XP files can't see Win2k3 files and vice versa

    I installed Windows 2003 server and Windows XP on my computer with 250GB hard drive. I partition the hard drive as follows: C drive - 25GB (primary) F drive - 25GB G drive - 50GB H drive - 50GB I drive - 100GB When I installed 2003, it only shows C, F, G, and H. Drive I is empty so I had to...
  18. Andel

    Dual boot - Windows XP and Windows 2003

    I installed Windows 2003 server and Windows XP on my computer with 250GB hard drive. I partition the hard drive as follows: C drive - 25GB (primary) F drive - 25GB G drive - 50GB H drive - 50GB I drive - 100GB When I installed 2003, it only shows C, F, G, and H. Drive I is empty so I had to...
  19. Andel

    How to Transfer a DTS package from one server to another?

    I would like to transfer a DTS package from my production environment to test environment. I tried saving it to a Structured Storage File format but when I open the file in my test environment, it screws up the transformation because the server names are different. When i change the server name...
  20. Andel

    Where to create NonClustered Primary Key?

    Which one will give you best performance: Creating Nonclustered primary key in the Primary filegroup or in its own filegroup? Thanks in advance. Andel andel@barroga.net http://www.iluko.com

Part and Inventory Search

Back
Top