SQL and Dates
Are you trying to find the # of days from today to the date in your table? If so use the datediff function… datediff(DAY,getdate(),BMDTOR)

View Answer   |  January 21, 2011  6:29 PM
SQL, SQL Query, SQL Server

SQL command question
Look up the JOIN syntax. That allows you to join multiple tables together to find out stuff like this.

View Answer   |  January 21, 2011  6:26 PM
SQL commands, SQL Server, SQL Server tables, SQL tables

Server Timeout on initial web connection to SQLServer
No there are no specific settings for connecting to Enterprise edition. The Express and Enterprise editions of SQL Server and the same with just some of the features disabled in Express. What is the exact error message you are getting when you try and connect?

View Answer   |  January 20, 2011  4:00 AM
SQL Express 2008, SQL Server, SQL Server Enterprise Edition, Web Server, Web server administration

SQL Server 2000 Log Shipping
If you are using the default log shipping that comes with SQL Server 2000, then the log files should be kept on both servers hard drive. Just copy the file from the production server to the backup server. You have to finish the current log file before you can bring the server back online. If [...]

View Answer   |  January 19, 2011  5:24 AM
Log Shipping, Log Shipping failure, SQL 2000, SQL Server 2000, SQL Server 2000 Log Shipping

how to use databases made in access or excel in sql
Definitely it is possible. U did not mention here which version of Access u r using ! Though try out this tricks…. There is a way called “Upsizing” which helps to convert access database into Sql (here sql means, assuming Sql Server) . To run the Upsizing Wizard in Access, Click Tools > Database Utilities [...]

View Answer   |  January 19, 2011  4:56 AM
Access, C#, excel, Import external data, SQL Server, SQL Server database

Storage Area Network Configuration IOPS
To get the best performance all volumes which are stored on the storage array should have the partitions aligned.

View Answer   |  January 17, 2011  11:40 PM
IOPS, SQL 2005, SQL Server 2005, SQL Server 2005 performance, Storage Area Networks

Running Multiple SQL statements through JCL
DB2 for z/OS has several options to exec SQL statements via batch. Take a look at DSNTEP2 and DSNTEP4. They are sample programs that come with DB2. Check them out in the APSG manual. Also DSNTIAUL with the SQL option. I also suggest you check with your DBA or other staff in house – there [...]

View Answer   |  January 13, 2011  9:08 PM
DB2 SQL, JCL, SQL error messages, SQL Server, SQL statements

Stored Procedures in SQL Server 2005
Hi The stored procedure is another way of executing a query against a database/databases on the sql server, the only difference is that query is stored on the actual server and to execute it you will need to call it. this feature is usefull for repetitive tasks and if you don’t want the query to [...]

View Answer   |  January 13, 2011  1:38 PM
SQL Server, SQL Server 2005, SQL Server stored procedures, SQL stored procedures, Stored Procedures

Adding another level of security to SQL 2005 database
No, it is a one or the other. The SQL Server can’t require both. Windows authentication is much more secure than SQL Authentication as brute force attacks can’t be used against a Windows account when connecting to SQL Server as when using Windows Authentication the user must already be logged into the domain with a [...]

View Answer   |  January 12, 2011  11:10 PM
Network security, Network Security Management, SQL 2005 Database, SQL Security, SQL Server 2005, SQL Server security, Windows authentication

SQL Server Disk Alignment
<a href=”http://www.microsoft.com/downloads/en/confirmation.aspx?displaylang=en&FamilyID=5b343389-f7c9-43d0-9892-ddcf55890529″>Here</a> is the document I used when setting up a development cluster. —— As long as it is a multiple of 64k you will be fine. Windows 2008 and higher will automatically align to 1024kb which is perfectly fine.

View Answer   |  January 12, 2011  8:16 PM
SQL 2005, SQL Server, SQL Server 2005, Windows Server 2003, Windows Server 2003 32-bit

Need project plan for Access 2007 database migration to SQL Server
Not much information to go on here but your answer is likely contained here: <a href=”http://support.microsoft.com/kb/2279654″> http://support.microsoft.com/kb/2279654

View Answer   |  January 12, 2011  7:45 PM
Access 2007, Access Database, SQL Database, SQL Server, SQL Server database, SQL Server migration

SQL SERVER 2005 Storage Performance
First your block size is crap. It should be 64k. That is the size of 99% of the IO that SQL Server will generate. Are your disks correctly alligned? How many disks are behind the SQL Server? How much RAM is in the SQL Server?

View Answer   |  January 11, 2011  8:44 PM
SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance, Windows Server 2003, Xiotech

Database file in Novell GroupWise
File extension .db is associated with Novell GroupWise. GroupWise is a cross-platform collaborative software product from Novell, Inc. offering e-mail, calendaring, instant messaging and document management. File contains address book database. File extension .db is very often used for database file formats. Here is a good administrative <a href=”http://books.google.co.in/books?id=koS-B2ZEsKwC&pg=PA688&lpg=PA688&dq=database+file+concept+in+novell+groupwise&source=bl&ots=oa0u91ClCW&sig=jMAGThoxd7bupjUkkPsy0Io6q2Q&hl=en&ei=skQsTa60K8umrAf0ovyLCg&sa=X&oi=book_result&ct=result&resnum=4&ved=0CCIQ6AEwAw#v=onepage&q&f=false”>Guide</a> Though it is based on version [...]

View Answer   |  January 11, 2011  11:56 AM
C#, Database Files, Novell, Novell GroupWise

Best tool for SQL Server 2000 – like golden is for oracle
Most people just use the tools which come with the SQL Server database. Enterprise Manager is used to manage the database, and Query Analyzer is used to write queries against the database. Many people like to use TOAD for SQL Server to query the database.

View Answer   |  January 7, 2011  11:30 AM
SQL 2000, SQL Database, SQL Server 2000, SQL Server database

Alter proc to fetch a table structure from SQL Server 2005 database
Why not just use sp_help_table?

View Answer   |  August 4, 2012  11:28 AM
FETCH statement, SQL 2005, SQL 2005 Database, SQL Server 2005, SQL Server tables

SQLCMD does not create a log file
</pre> Should have been: > %LOGDIR%RegGTNPERS_09_RATE_FIX.log 2>&1

View Answer   |  January 6, 2011  5:27 PM
SQL Log Files, SQL Records, SQL Server, SQLCMD

Migration checker tool for Sql Server 2000 to Sql Server 2008 Migration
Microsoft has a SQL Server 2008 Upgrade Advisor on their site that will check for problems with your migration. This is the site for the download: http://www.microsoft.com/sqlserver/2008/en/us/upgrade.aspx

View Answer   |  January 6, 2011  4:26 PM
Microsoft SQL Server 2000, SQL Server, SQL Server 2000 administration, SQL Server migration, SQL Server Migration Assistant

i want to develop a s/w in java and back end as sql server
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]

View Answer   |  May 17, 2013  11:00 AM
Java development, Software development, SQL Server

I need to replace a word in a Document through SQL Server 2008
You can’t use T/SQL to edit a word doc which is stored within a database table. You would need to save the document to disk as a document then edit it. Why are you storing your resumes in SQL Server anyway?

View Answer   |  January 4, 2011  7:47 PM
SQL 2008, SQL Server, SQL Server 2008, SQL Server 2008 R2

Email Notification If Scheduled Task In Windows Fails
If you can use a batch file (or other script) to determine success or failure, there are several mechanisms you can use for email notification. If you’re running Exchange, I seem to recall that there’s a command-line utility to send email – FROM a logged in machine. Netlatency.com has a sendmail command-line utility one word [...]

View Answer   |  January 4, 2011  1:16 PM
Brightmail, CipherTrust, ClearSwift, Desktops, Exchange, Management, McAfee, MessageLabs, Microsoft Office, Microsoft Windows, OS, Postini, Rockliffe, Security, Servers, Spam, SpamAssassin, SQL Server, SurfControl, Symantec, TrendMicro