I just installed SQL Server 2008 Management Studioand I can connect to SQL Server 2005 with a SQL account, but when I go to open the databases I get the error below. The instance of SQL Serve...
I am having problems installing Microsoft SQL Server 2008 x64 Std, on a clean installation of Windows Server 2008 64 Bit Service Pack 1. With .NET Framework 3.5sp1, and all updates run on it....
Hi,
I was just wondering if it is possible to retain my existing SQL server 2005 and install 2008 to try it out. Any information will be very helpful.
Thanks
I am trying to upgrade a SQL Server 2005 Standard x64 instance running on Windows Server 2008 Enterprise x64 running on VMware ESX 3.5 Update 2. At first I thought it was a bad ISO and so redo...
We have a new report in SQL Server 2008 reporting services that was built using the SQL Server reporting services 2008 Report Builder. The report points at an analysis services cube data sour...
I have a newly built Windows Server 2008 Enterprise server built on a VMware ESX virtual machine running SQL Server 2008 Standard. This server is a member of our Active Directory domain and t...
First of all, here is the architecture I am using:
--SQL Server 2005 database (production), 2008 database (development)
--C# (Silverlight) code on client/application side
--Entity Framework...
I'm trying to schedule a daily job to pull out specific data from a table that gets added every night. I accessed Jobs icon under SQL server agent and proceeded to creating a job using 'new jo...
I have developed a system with a front of Access 2003 with visual basic code accessing data on SQL server 2000 (enterprise).
I am in the process of migrating to Access 2007 and SQL server 200...
In SP Central Administration > Operations > Reporting section, selected Set Server Defaults. Received error, "An unexpected error occured while connecting to the report server. Verify that t...
I am getting this error and can figure it out, I am new to SQL so please be detailed on resolution.
Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 1
The EXECUTE permission was den...
Hello,
I work on sql server, and we have a table with a column that store a number from a java code with Date.getTime() function (it returns a long data type).
A previous solution seems to...
brand newbie w/sql v2008. i did what seems to be a pretty vanilla installation -- it all looks good local, but i can't connect to it. the protocols are each enabled (tcp/ip, named pipes), an...
I'm trying to install SQL Server 2008 Express and I've already installed .NET Framework 3.5 SP1
I get this message even when I've done what it has asked....
"SQL Server 2008 Setup requir...
I have just installed sql server 2008 onto a vista ps. There is no other instance of sql running (I removed 2005 and all references to SQL and then reinstalled) The installation would not star...
When I was trying to install SQL Server 2008 Enterprise Edition into my machine (32bit Windows XP SP3) by clicking "setup.exe" from installation directory of SQL server 2008. An error message ...
Let me start off by saying I am a complete novice to Sql Server. I have no problem connecting to SQL 08 on a my standalone computer but what I would like to do is have it on a LAN and be able...
I am testing maitenance plan on SQL server 2008 that also includes backup. It fails with the following message: "BACKUP failed to complete the command BACKUP DATABASE dbase1. Check the backup ...
I have a foreach loop task that I am passing a variable object to.
I want to dump the contents of the variable object to another table on another server:
Here is a breakdown of what my...
Hello,
We are on SQL Server 2008 and we get an error when running a newly configured maintenance plan. (See below)
When we run each of the T-SQL command individually in query analyzer it...
Please provide code for connecting a project developed in Visual Basic 6.0 with SQL Server 2008.
Hi
I did not create any SQL trigger or procedure before. What I need is that I three tables as:
1- Parent [Employee]: EmpID (PK), EmpName ...etc.
2- Child [EmpCourse]: EmpID (FK), CourseN...
i tried to install sql server 2008 but i get an error every single install..
i tried over 15 times,different settings,but still get error..
OS - Windows XP SP 3
Hardware is enough for...
In my SQL Server 2005 Tables, there are some date and time columns with the follwoing shape: 1217147736160
How can I change it to a meaningful date and time format such as 'DD/MM/YYYY'?
I need to create a System DSN to connect to a database running in an instance of SQL Server 2008 Express. The SQL server is running on the local machine.
Here is what I have done so far:
1...
