SQL Server 2008

SQL Server 2008: SSIS pakage with parameters

I need to create SSIS package with user entered date parameter. I have two questions: 1. How I can promt the parameter when I test the package in debyg mode. 2. How can I put on the begining of the package design condition: Global Variable gvar_Date datetime; If @p_Date is null Then gvar_Date =...

The hierarchyid data type in SQL Server 2008

In regards to the hierarchyid data type in SQL Server 2008, what is the solution if the parent node gets deleted?

What Is Your SQL Server 2008 Adoption Rate?

http://benchmarkitconsulting.com/colin-stasiuk/2009/02/19/please-vote-what-is-your-sql-server-2008-adoption-rate/ SQL Server 2008 RTM is over 6 months old now and I’m wondering what people are seeing so far in terms of adoption rate. What I’ve seen so far in the environments that I’ve been...

SQL Server 2008 Export data problem

Hi I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy. Firstly I created a new empty db on the local machine. Then I scripted...

SQL Server Agent job Failures

I would like to know if there is any way to get Agent jobs such as backups, Update Stats jobs to write to the error log on failure. I have written a monitoring program that looks in the errorlog and alerts on pertinent errors. I would like to be able to use this solution for agent job failures...

Can you replicate SQL 2003/8 to SQL 2000

I am upgrading a server running SBS w/SQL2000. New server will be 2003 or 2008. Would like to use old server for backup off site. Can I replicate, or would I need a new 2003/2008 license to accomplish this?

Database Mirror connection string in sql 2008

Hi All, I have three databases which i have configured mirror on sql server 2008 for all the databases. Manual Failover with one principal and mirror. (Witness planning in the future) Using Windows authentication (Since same login and pass, neither new endpoints are created and not certificate...

Kaplan IT Learning SelfTest software

Hallo community, 70-448 Microsoft Certification Practice Products 70-432 70-433 have you purchesed this software ? what is your experience? I want to prepare for these exams. Thank you very much in advanced for the Answer. DeshRaja

Copying view from remote to local SQL Server with SSMS

Hi I'm currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I'm used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. But using...

Error message when finding a database on SQL Server 2008

I have installed the Small Business Edition of SQL Server 2008, and I have created a Microsoft Dynamics NAV database on this SQL Server. However, when trying to locate the server from a pc in the office, it does not find the database. The error message is: "The 192.168.0.7" server cannot be...

SQL Server 2008 compression experiences?

We are about to migrate a database from SS2005 32-bit to 2008 64-bit. One of the biggest drivers for this is the compression capability in SS2008. We expect to shrink our 2TB database down to about 500GB (proven in testing), and get the comparable IO performance improvements (4x faster reads - also...

AS/400 to SQL Server 2008

Hi, Is there a way to pull an AS/400 File into SQL server 2008? From within SQL 2008 we do not see an ODBC connection that will work for the 400(??) I am not familiar with SQL server and we need to get some data to it. Can anyone shed some light on what I may be missing in regards to the link...

Transferring a database and writing a database script in SQL Server 2008

I want to transfer a database from one server to another server using SQL Server 2008, and then I want to write a script which i can update the database daily automatically. How can these be done?

Different SQL Versions on the same server.

I was hoping someone could tell me if its ok to install SQL2008 Standard for use with company accounting and billing applications and also install SQL2008 Express for use with Sharepoint 3.0 on the same server. I could put the versions of SQL on different volumes if that helps. The load Sharepoint...

SQL SERVER 2000, 2005 & 2008

Can Sql Server 2000/2005/2008 exist on the same machine

Storing large data files in SQL Server

What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?

Building reports in SQL Server 2008

I am on SQL Server 2008, and we want the clients to be able to build their own reports whenever they want. Are there any tools out there that can do this?

Can we migrate already encrypted data from SQL Server 2000 to MS SQL Server 2008

I have encrypted data in MS SQL Server 2000. I want to migrate in MS SQL Server 2008. I have migrated successfully through the attach/dettach process but when I am trying to decrypt the data. is it giving different result or value. is the right process to migrate the encrypted data? Please suggest...

SQL Server 2005 or SQL Server 2008

I hav been trying to learn sql 2005 from lyk a month or two and i think i have done a good job. Now i was about to try some security stuff in it but i saw that sql 2008 is in market. Can any body suggest me that what is the difference between the two and can I swich to sql 2008? what ever i learned...

SQL Server 2008 SISS error row handling

Struggling with SISS I have data source and data destination With some bad data, I can't figure out how to set up sending the bad row to another destination There are over 50 columns. Sorce is a tab delimited text file Desitnation is SQL Table