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 Solution

BCP with Format File works but why is it adding spaces?

Related question to this:
Troubleshooting Solution

How do I use "format file" with BCP command?

This is a related question to this
Troubleshooting Solution

Can BCP command  place data in specific positions in text file?

We have a stored proc that does this:

1. inserts data into a temp table
2. creates a text file3. …
Troubleshooting Solution

What do other companies do about having test databases?

We've been having a discussion at work about restoring the Production database in a test environment …
Troubleshooting Solution

Determine if a string is just a repeating character

I would like to have a function that I feed in a string
And if that string is simply the same …
Troubleshooting Solution

Format(date, 'mmddyyyy:HHmmss') not working

Format(date, 'mmddyyyy:HHmmss') not working.  The date and time 2020-12-01 00:00:00.000 is …
Troubleshooting Solution

Accessing Server error logs over network. Network discovery is turned off but I have access through SSMS Does the ReportServerDB have the same error log data?

I have access to several servers over the network and can Connect to DB Engine & SSRS locally to …
Troubleshooting Solution

SSRS separate install from SSMS in SQL 2017?

1. Is this correct SSRS install is separate from SSMS starting with SQL 2017?
 (Someone on the team …
Troubleshooting Solution

What are the best SQL tools to compare SQL Queries Side by side. Line By Line?

I have heard of WinMerge and used it in the past. Are there any better tools or ways to use SQL …
Troubleshooting Solution

Subscription Failure Error - Just want to verify what this means.

Last Status - Failure writing file …
Troubleshooting Solution

Ambitious Database Project. I need help.

In my quest to learn how to do things, be a better man, a better SQL querier and leader. I wanted to …
Troubleshooting Solution

extract email address from the string

I have the string from the MS exchange server which lists the email address. However, the email …
Troubleshooting Solution

Microsoft SQL Servers across a network should I be able to see the ErrorLog files locally or not?

I have access to Microsoft SQL Servers across a network and I can RDP into the server and see the …
Troubleshooting Solution

should i do anyhting on switch side after doing nic teaming in server ?

i got server 2012 with 3 network cards and a dlink managed switch. 
i am planning to do nic …
Troubleshooting Solution

looping thru all table fields and constructing a SQL where string

Hi Experts,

I am looking to dynamically construct a SQL string based on two tables as follows.

Having …
Troubleshooting Solution

Group by (only group-by one column) - is this correct?

This isn't hard but I'm being rushed to get something done. I want to double check this is correct.

Troubleshooting Solution

sp3 for sql 2008 r2 download

I am unable to find a working link online for sp3. Does anyone know where I can find it? Yes I know …
Troubleshooting Solution

How do I attach MS SQL Server 2008R2 database files to an MS SQL Server 2017?

I have experienced a hard drive crash while running MS SQL Server 2008R2.  My database files were …
Troubleshooting Solution

I need SQL Server 2008 R2 Developer Edition

Points of My Scenario:
1. I have Microsoft Volume Licensing access to Microsoft business software …
Troubleshooting Solution

Keep getting "The multi-part identifier 'xref.DisplaySetupID' could not be bound."  SQL Server

Hi all.

I am trying to get this SQL query to run but keep getting the error, "The multi-part …

Do more with Experts Exchange.

Get Answers

Take a Class


Monitor your Site

Explore solutions and more