Server Configuration

SQL 2005 32 bit code vs 64 bit code
Hello everyone. We have developed and application in 32 bit SQL 2005 some of our clients are using 64 bit SQL 2005. My question is: if I transfer my 32 bi DB into 64 but enviroment would it work or I might have issues? TIA Igor F ... 3 Jul 2008 10:27

Backup file
Hello, in SQL Server 2000 what is the difference between a backup file that has the '.bak' extension versus one that doesn't like 'backup.bak' vs 'backup'? And is it better practice or advantage to use one over the other? Thanks in advace. ... 2 Jul 2008 21:10

getting the aggregate from a grouping
I have this query where I can see the duplicate car_sightings because they are grouped together. However, what I want is the aggregate. One record with the count of how many duplicate sightings for each car, with the same mark, number and sighting date. I tried one column as count(car_mark, car_number, car_d... 2 Jul 2008 18:06

SQL2005 profiler filtering
Hi, Is there a way to enter more than one condition when you create a filter in a Profiler Template? I want to enter a number of different application names in a missing stats template but I cannot see any way to do this using the GUI. Thanks Chris ... 2 Jul 2008 18:05

SQL 2000 accessing DB2
I have a stored procedure that calls remote query using a linked server. It works fine when I run it manually through the Query analyzer window, but when ever I try to schedule it as a job it fails with: Could not create an instance of OLE DB provider 'IBMDASQL'. [SQLSTATE 42000] (Error 7302) (Error 7302) OLE DB... 3 Jul 2008 15:36

Authentication failure for perfectly good server
Hi, I have really weird issue. SQL server is in workgroup, my account in local administrator's group on machine, default setup so I'm sysadmin as well. I can register to server with MS just fine, I can not all operations just fine. But when I try to delete Maintainance Plan (some of them only) I get fol... 2 Jul 2008 20:09

Problem with the cursor and dbname
Hi, I have the following cursor is running on my server and revoking access for all users. However, two of my databases are named: MY Mas and MY San. There is a space in the name (don't ask - it was named before I got here). We can't change the name of the database but when I run the code below it give me the... 2 Jul 2008 12:56

Time when automatic file growth occurs
Please, where I can see times when automatic file growth occurs? I searched it in SQL-server Log and EventLog, but didn't found. ... 3 Jul 2008 04:18

MSSQL code to find all records within 1 year
Does anybody have a good code for defining records to those within 1 year. We have a field (closingdate) and so we need to show all records for up to 1 year after their closingdate. Thanks ... 3 Jul 2008 09:25

Performance of application ?
Will the increasing of database size affect the performance of application ? Where can I get more information to improve performance of application ? Regards, Tee ... 2 Jul 2008 11:54