SQL Server 2008 Questions and Answers

Recent IT Questions

1 - 20 of 55
<<PREVIOUS 1|2|3 NEXT>>

Composite foreign Key in SQL Server

I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel,...

asked by GabyCostilla

  5 pts.

vb.net 2008 and sql server 2008

How can i connect to the sql database using the app.config file over a network and also have the ability to edit the app.config during installation or when the application is installed on another machine on the lan Software/Hardware used: vb.net 2008, sql server 2005

Answer Question   |  Oct 5 2009  12:00 AM GMT
ADO.NET, VB.NET 2008, VB.NET
asked by Semauel85

  15 pts.

Complete System Backup SQL Server

We are running SQL 2008 on Dell Servers with a wholesale Distribution Package Software by Activant Solutions Called P21 (Prophet 21) Our question is this! WE have a SQL Server and a TS Terminal Server running our Distribution Software and off of this equipment was recommended by the Activant...

View Answer   |  Sep 17 2009  9:03 PM GMT
Dell servers, SQL Server 2008, Backup
asked by ITKE

  10230 pts.

Why should I use SSAS for Predictive Analytics?

We are considering tools for Predictive Analytics in Law Enforcement, and I have been asked to find the advantages of SSAS, especially in SQL 2008. What are your thoughts on the product and what can it do for us? Software/Hardware used: SSAS 2008, Microsoft SQl Server 2008, Windows Server 2008

Answer Question   |  Sep 8 2009  2:30 PM GMT
SSAS 2008, Microsoft SQL Server, SQL Server 2008
asked by Bubbuh

  5 pts.

CLR Assembly in MS SQL 2008

I have a problem with COM-objects which i create in CLR-assembly in VB.NET via CreateObject. When I compile this assembly as console project and run loging under any account on server, it works ok. But when i run this file from MS SQL, it can not create object. What may be reason for this?

Answer Question   |  Aug 31 2009  7:29 PM GMT
SQL Server 2008, CLR, SQL
asked by Dalex

  35 pts.

SQL Server 2008: Difficulty setting mixed mode authentication password

I am attempting to install SQL Server 2008 (64-bit) on Windows Server 2003 SP2 (64-bit). During the installation, I get stuck at the step where it asks for a mixed mode authentication password. Following the requirements, I have tried a strong password but I am still getting the error message,...

asked by SQL Server Ask the Experts

  2445 pts.

unable to connect to SQL from Access

I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version of...

Answer Question   |  Aug 3 2009  6:10 PM GMT
SQL Server 2008, Access 2007, Microsoft Access
asked by Standaman

  15 pts.

Filling data in datagridview in vs2005 with windows develpment

HI all I have a more than 80000 data in sql server 2008 in a single table. Then i have to show that data in datagridview. But the performance has very slow some time my machine hang. It has taking several minute. So i have to improve this performance could anybody help me. For information i am...

Answer Question   |  Aug 1 2009  6:56 AM GMT
VB.NET 2005, VB.NET, DataGridView
asked by Visualpro

  5 pts.

SQL server 2005 to SQL server 2008

I am following using sql server 2008 but following some lessons written by BOB Taybor. Is MyCompany.mdf for 2005 abailable in 2008 format?

View Answer   |  Jul 16 2009  4:35 PM GMT
SQL Express, SQL Server Training, SQL Server 2005
asked by Standaman

  15 pts.

Free Chapter - Beginning Spatial with SQL Server 2008

Another free chapter download is available on the IT Bookworm Blog. Written by: Alastair Aitchison Book: Beginning Spatial with SQL Server 2008 Overview: "Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the...

View Answer   |  Jul 16 2009  12:09 AM GMT
SQL Server Spatial Data, Alastair Aitchison, Apress
asked by BrentSheets

  6535 pts.

Software to automate backups for SQL Server 2008 databases

I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up to do this? It's not...

View Answer   |  Jun 26 2009  4:44 PM GMT
SQL Server 2008, SQL managment Studio, Automated backup
asked by Phrathepmali

  30 pts.

Backing up SQL Server 2008 databases to a tape drive

I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

View Answer   |  Jun 24 2009  10:36 PM GMT
Backup to Tape, SQL Server 2008, SQL Server database
asked by Phrathepmali

  30 pts.

Retrieving System information

I need to retrieve logins and users for all databases by server for SS2000 - 08. Querying the system tables sysservers, sysdatabases, sysloginns and sysusers provide the information. But how do I collect all that information with one query hopefully that I can run against all serves in the...

Answer Question   |  Jun 18 2009  5:53 PM GMT
SQL Server 2000, SQL Server 2008, SQL Server 2005
asked by Calcindor

  5 pts.

How to automatically update Child Table with Insert Trigger and Table-UDF

I have SQL Server 2008 and Visual Studio 2008 and am trying to automatically insert new records into a child table based on new inserts into its parent table. I know that this should be simple: via an insert trigger. However, the complexity is that the new records into the child table need to be...

Answer Question   |  Jun 12 2009  3:14 PM GMT
T-SQL 2008, UDF, SQL Server 2008
asked by Ironryan77

  5 pts.

Errors creating database with SQL Server 2008 I&M Training Manual

I'm going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here's what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N'TK432_Data', FILENAME = N'c:\test\TK432.mdf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ), FILEGROUP...

asked by Howhighthemoon

  20 pts.

Free Chapter - Hardening a SQL Server implementation

Another free chapter download is available on the IT Bookworm Blog. Written by: Ross Mistry and Hilary Cotter Book: Microsoft SQL Server 2008 Management and Administration Overview: “If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based...

Answer Question   |  Apr 23 2009  3:24 PM GMT
SQL Server security, Ross Mistry, Hilary Cotter
asked by BrentSheets

  6535 pts.

Transaction log for read only database...

Hello there, I am currently studying for the 70-432 (MCTS SQL Server 2008 I&M) exam and I am using Microsoft 70-432 Training Kit by Mike Hotek. At some point the book claims "when a database is placed in READ_ONLY mode, SQL SERVER removes any transaction log that is specified for the database....

asked by Dallasfb

  15 pts.

SQL Server 2008 extended stored procedures

I have created several extended stored procedures in SQL 2008 which when i run always return a NULL. I call these XP's from within a stored procedure. They work fine in SQL 2005 and SQL 2000. One thing i have noticed is when i click on the properties of the xp the path to the DLL is not there is...

asked by KH

  50 pts.

SQL Server with domain accounts

When we install SQL 2005 servers, we usually have a collection of domain accounts for the services that will be running on that server. We usually log on to the server using a local account without logging into the domain. However, it seems to not recognize the domain user accounts and we end up...

asked by Andrewn2000

  5 pts.

Looking for detailed synchronization logging in SQL Server 2008

We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the...

asked by SBatSI

  370 pts.

1 - 20 of 55
<<PREVIOUS 1|2|3 NEXT>>