Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
I am using SQL Server 2000, and my question is: is there any way to call a stored procedure in a SELECT list?
I need to use sp_start_job to schedule two jobs in SQL Server: the second job may run only if the first succeeds. Can you give me an example of a job running this store procedure to do this? Is there another method to do this in SQL Server? Thanks in advance!
I receive the following error when installing SQL Server. I have installed .net 4.0 full x64 bit as some sites suggest but I can't get past the failure. The following error has occurred: An error occurred during the installation of assembly 'policy.8.0.microsoft.vc80.crt, version='8.0.50727.4027',...
What is seeding and reseeding in SQL Server? How to use it? Where is it used? What is the purpose?
How do CRM systems help firms achieve customer intimacy?
How do I move a user from one OU to another OU?
How can I utilize a Net Zero wireless/no port hotspot with a router that I would plug my VoIP phones into? I need a router or something to capture the Net Zero signal wirelessly.
Does anyone know the format for an MVL 3D ultrasound file? It is binary. I am trying to figure out the format but if someone knows, please tell me....
I have implemented a few Java applications now, only desktop applications so far. I prefer to use immutable objects for passing the data around in the application instead of using objects with mutators (setters and getters), also called JavaBeans.But in the Java world, it seems to be much more...
What does this mean: USRPRF disable often after enabling.
This IT answer entry is an on-going wiki page that highlights capabilities and vendors for the 6 functional areas in the realm of Data Center Automation. There are two ways to contribute. 1) you can "create answer" where you write directly into the wiki page 2) you can "add to discussion" where you...
What is the current value of a package of VISICALC, for Apple II PLUS 48K, ® 1981Software Arts, Inc.
Hi guys, So, I have home lab set up with Windows Server 2008R2. I've created a bunch of users. I also set a group for help desk. In that group I added one of the users as members which I will be using to delegate limited administrative abilities. I then went into the User Accounts OU where all the...
There is a (another) study going on to try to determine how we should best "modernize" for the future. We have been a COBOL and CL shop for more than 30 years, but the "dinosaurs are dying off", kids in school don't learn COBOL anymore so thus another study...Someone selling XYZ servers would...
Hello, I recently read Jeremy Kadlec great article titled, "Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard". Question for anyone: I used the wizard to copy 12 databases from ServerA to ServerB. However, I now want to set the order of those databases. Unfortunately, I...
How do I create a user in SQL Server 2000?
I need to update Column A1, Column A2 data in table A with Column B1, Column B2 data in table B for over 100,000 rows. How do I write a procedure to accomplish this in SQL Server 2005?
Is there to achieve On Error Resume Next? insert into table1 select top 1000 columnname from table2 It should continue inserting the next record even if there is an error. It should not stop the execution. It should simply skip the errors. Thanks in advance.
Could you please educate us on how to restore a database using a backup? We have a Mambilla PR software (.NET application) and SQL Server 2000 back end. We run the backup before any major change to the database.
In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?