Questions & Answers
Active Directory, AS/400, Business Intelligence, Career Development, CIO, Cisco, Database, DataCenter, DB2, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, 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 have an table in sql-server 2005, in which my one field is storing csv values.Suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in csv format. now my problem...
I need Java code to access and copy an AS400 file to SQL Server database/table. It must also copy a specific amount of records from the SQL Server side.
In the most recent edition of SQL in Five, Mark Kromer, national platform architect at Microsoft, discussed his top three features for the upcoming SQL Server 2014. These included: Hekaton Big data Data Explorer Which feature are you most looking forward to in SQL Server 2014?
Currently, I’m running SQL Server 2012 with Visual Studio Beta 11 as well as SQL Server 2008 R2 version of the .mdf file because the staging server uses R2. I’ll be moving up to SQL Azure for a project I’m working on. What is the best way to port files over? Do I actually need to make changes...
How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?
Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select...
Hi Folks,I got the valuable information about WebLogic Server Admin online training. It is nice, brief and interesting. for more info regarding WebLogic Server Admin check out http://weblogic-onlinetraining.com/
I was under the impression you could do this but now I am having trouble finding it. I want to ONLY allowed whitelisted (manually by IT) devices. I don't mean type of devices. I mean my specific phone and nothing else. if you get a new phone you bring it to IT and we enroll it. I don't want any...
I have removed Oracle from system, but when I try to install it again, I'm getting the error as an instance of Oracle already there please remove the files and re install again. I have delete all files, but I'm still getting same error. As suggested above, I have try to run sc delete...
Hello, I have a problem when i am inserting a string date ie 19/9/2010, which is stored in table as 9/19/2010. i want to insert dd-mon-yyyy format. can i insert dd-mon-yy format,please replay.
I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish...
In SQL Server 2005, I am not able to access the Northwind database. Some people have said that it is built into the SQL Server, but I can't access it. How would I do so?
How can I backup the Programmability (functions, triggers stored procedures etc.) as part of a schedule job? Do I need to write code or can I use the wizard?
Dear all, I have problam to connect SQL 2000 server with jdbc driver.\ i m using windows 2003 server SQL server 200000 and jbuilder. anyone have jdbc driver for the same environment thnaks
When attempting to install the client tools for SQL Server 2000 onto an XP desktop, I get an error stating that “A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.” Rebooting only leads to the same...
I've just installed SQL Server Express and I want to create a local instance. I would like to use SQL Server to do my analysis in running queries instead of Microsoft Access. I want to import my tables from Access to SQL Server Express. How can I migrate from MS Access to SQL Server?
I have email rules setup in Lotus Notes that keeps me from getting 100's of our system emails by sending them to other folders and has been working that way for years. Last week even though Notes is still sending the emails to the correct folders, those emails have started going to my BlackBerry...
Whenever a user accepts a calendar invite from outside the organization, the following happens: - the meeting posts to the calendar correctly - the acceptance message is sent as coming from firstname.lastname@example.org Regular mail is sent as coming from email@example.com Why is the...
When agent schedule then export not coming to directory.
I'm having difficulty with a select statement. As below, it works . If I remove the '//' comment-out tags, it doesn't, so obviously there's an issue with those statements. I'm trying to populate an output 3-char field with either Yes, No, or N/A. The Y/N comes from the contents of a field...