Explore SQL Server 2008 on Experts Exchange

Expert Solutions for Your Tech Problems

SQL Server 2008Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.C...

Read more
  • 50K Content
  • 7.1K Contributors

Expert Spotlight
SQL Server Data Dude

Microsoft SQL Server database developer, architect, and author specializing in Business Intelligence, ETL, and Data Warehousing.

Troubleshooting Question
Troubleshooting Question

provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not possess a common algorithm.)

6
Since last 3 days, I am getting the error below when trying to connect SQL server 2008 from a …
Research Question

MS SQL jobs with email alert

1
hi,

I'd like to build SQL jobs alert , as long as a SQL jobs failed it will email me, without …
Troubleshooting Question

Maximum number of row you can extract from SSAS Cube into Excel

Hi Experts

Is there a limit on the maximum number of rows, data you can pull into excel in from SSAS …
Troubleshooting Question

How so I write a Select SQL Query with  and OR Clause that will return multiple  Like'%' variables

byarmgon
3
Hey there hope you can assist me with this SQL Query.

I need to be able to return all records that …
Troubleshooting Question

SQL Error value inconsistent with data type or column length

9
I have a customer who has been using our software product for years.  its a Microsoft Access front …
Troubleshooting Question

Create a formula field on Table to accommodate scheduled task

bybfuchs
5
Hi Experts,
I have a table in Caspio that contains a field Last_Updated and have a scheduled task …
Troubleshooting Question

Upgrade SQL 2008

7
I should upgrade Sql 2008-r2 to sql2016 directly in the same instance and same server
do you have any …
Troubleshooting Question

High Processor Usage in Virtual Machine

2
I am having issues with a VMware Virtual Machine.  The server is  Microsoft 2008 R2 Enterprise …
Troubleshooting Question

Index Maintenance Job hung during Server Restart - Sql 2008R2

5
Hello,
We have Sql 2008R2 and we are running Index Maintenance job (Index optimization) part of Ola's …
Troubleshooting Question

How to select data from a text file using SQL syntax.

bybfuchs
10
Hi Experts,

How can I use SSMS or similar to directly select records from a local text file (.txt, …
Troubleshooting Question

t-sql autoincrement with month

7
Hi Experts,
What i need to is when every time month start from 01 for example then reset to end of …
Troubleshooting Question

SQL trigger update insert records

1
Here is my code for SQL trigger


ALTER TRIGGER [dbo].[AfterUPDATETrigger] on [dbo].[Datatable]
Troubleshooting Question

SQL Query

7
Hey
Im looking for a way to change the fields of a Microsoft Server database table, in Design mode …
Troubleshooting Question

Need to run SSIS package from a remote computer

3
Need help running an SSIS package from a remote computer.

Hello.  I created a DTSX package that …
Troubleshooting Question

Need help with PSEXEC and MS SQL Server

12
Using  PSEXEC program with this line of code below to access MS SQLServer 2008 R2 on another …
Troubleshooting Question

I need to do authentication for WCF Services using JWT

9
Hi,
We need to authenticate our system users; System architecture is 3-tiers as follows:

Troubleshooting Question

Create a dynamic table - perhaps using Pivot

byPutoch
7
Hello,
I'm trying to create a table based on another table.
The existing table holds information…
Troubleshooting Question

SSIS Package - Dynamically passing Server, Database, Folder values to the package

3
After quite long, i started using SSIS, and ran into issue with building an SSIS package …
Troubleshooting Question

Difficulty with Variables in Dymanic Query

3
To query look-up tables for a description using its code, a SP with a dynamic query. The SP is …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more