Search results for query: *

My friend, who has a Compaq she barely knows how to use, asked me to do a scan of her Windows XP Home and install an anti-virus for her. I downloaded Kaspersky Rescue disk, dated 05/13/2011 and created a bootable disk from the ISO file. I successfully booted it up, and ran a scan against the C...

Hi all, I am not very good with creating databases and how they need to work to get what I need. I tend to over-do it and make things far more complicated. I don't need code, I need to get a picture in my head how to hook up several elements. Of course, this is needed yesterday, which I cannot...

I have an old Gateway, got the SMART failure, could not bypass the error so I replaced the hard drive, formatted the drive, reloaded the OS and apps, restarted computer and while loading a couple more drivers got the SMART failure again. What am I missing? Is it possible that something on the...

As I understand it from another DBA, that I cannot upgrade SQL Server 2005 Express SP2 to SP3 because the Express SP3 package is a complete database package and running it would only install/create a new instance. I also understand that moving the stuff from SP2 to the new SP3 is troublesome...

Hi everyone, I spent the last two days going through a long list, looking about for descriptions of undocumented SP/XP procedures (USP). I managed to find rudamentry descriptions for about 85%. This is for a security plan required by my organization. If anyone uses any of the following USPs...

Quick question. One of the DBA has a SQL Agent Job that runs on weekends that looks at indexes, and if there is 30% or more fragmentation, the indexes are dropped and recreated. On the other hand, as I explore the various issues we have with performance, I am seeing articles that indicate...

My friend has been using a eMachine for his business, loaded up with specialized software. The hard drive has become very noisy and sounds like it is ready to go. He has purchased another computer and would like me to transfer everything to the new computer. The new computer has Vista on it...

My friend's eMachine (T2642) will no longer recognize his digital camera when hooked up. I tried a thumbdrive, and while it recognized new hardware, it errors out. Any advice? Thanks in advance [noevil] Glen Braden

I been doing a bit of research, and I am convince this cannot be done, but I will ask away. Is it possible to set up a distributor (for replication) on it's own server, and used it to pass replication chores between servers. I am looking for publication on serverA pass a snapshot to subscriber...

I am trying to automate a process where several CSV files are loaded into a database via Bulk Insert. Using a import data wizard, the table can be created from the imported data, but I have not been able to do so via T-SQL. Any ideas? BULK INSERT dbo.tblTransactionByGift_Temp */Table to be...

We are currently building a cube in our environment that is taking about 12 hours to complete. Initially (way before my time) the cube was built using differential data, which I am assuming is the use of new data after the initial cube build for updating. Searching about on the internet, I am...

I am in need of an IT Skills sheet where user would indicate if they worked with an item, how long (experience) and last time used. I have one from 15 years ago, but it is, as you can imagine, way out of date. If your company uses one, and if you don't mind me using the info on it to update...

Out network people can't seem to make Backup Exec backup our server containing 24 databases concurrently. They are currently using tapes, but we are thinking of doing parallel disks backup for our larges databases. We would like to see multiple databases backing up at the same time on this...

I have a half dozen merge replications jobs set up and working between two servers. I been trying to setup another merge replication but keep getting the following message: The schema script '\\NVIS\$SQLDATA$\unc\NVIS_cbn_blogs_cbn_blogs\20080704040506\subtext_Config_1.sch' could not be...

I have set up transactional replication from a database located on a SQL Server 2000 to update a database every 12 hours on a SQL Server 2005. The snapshot agent works just fine but the transactional agent errors out on 'Could not drop object 'objectname' because it is referenced by a FOREIGN...

I have a table with 5 columns, and three of the columns comprise a unique key. I need to add a fourth column to that key, but I can't drop the table data. I cannot use Enterprise Manager in this environment, so I am using an ASP page with a SQL window to run my commands. Is there an easier...

Does anyone have a script that I can run on our sql server 2000 that will give me a neat (printable) report of my tables. I use to run a script on Oracle that would dump my table description by column name, data-type and length and broke by table name and was filtered by owner. [noevil]...

We have a NET2.ASP and AJAX application running with a SQL Server backend. What seems to be working fine in out test environment is causing us all kinds of grief in production, but our production environment is a controlled environment and we are restricted as to what can go (or be...

I 'ceeded my computer to my wife, and use a different emulator product on my new PC. I no longer have the original disk for the Hummingbird product suite on my computer, but it will not delete without the install CD. Does anyone have instructions to remove Hummingbird without the CD? The...

We are doing some ASPX/NET2 development with an SQL Server 2000 back-end. Our developer is using Visual Basic 6.0 which I understand, installs a copy of Express 2005 server on the PC and uses that to help debug issues with development. I am told by others, that using VS6 with SQL Server...