error creating a linked server from sql server 2005 to 2000
Ok, I'm trying to create a linked server connection going from a 2005 to a 2000 server. This is what I'm doing and here's what I'm getting any ideas?
2009-12-03
314 reads
Search results for "4679.com.cn"
Your search for "4679.com.cn" returned 6 results:
2013-03-05
236 reads
Export Table data in to Excel using T-SQL
I am trying to export my table data in to excel through T-SQL query Below is the query which I am using for the same When I execute the above query I am getting the below error Any solution to fix this problem is highly appreciated I am running this query in SQLServer 2012 . […]
2016-10-13
1,974 reads
Last day of month in a WHERE clause
Hi all! Have looked a bit around to find something here, but only found something about how to calculate last day of month. Given this extremly simple table: CREATE TABLE [dbo].[a_dates]( [id] [int] NOT NULL, [Check_date] [datetime] NULL, CONSTRAINT [PK_a_dates] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = […]
2016-08-11
1,496 reads
Help Needed in Processing Data
Hi, I have a text file which has 1 million records in the below format. The technology what am using is , VS.Net 2012 with C# language and Sqlserver 2008 R2. Name|Age|DOB|Salary|Address|PhoneNumber Destination table I would be getting this file every week. so logically i need to process 1 million records every week and sometime […]
2015-08-13
62 reads
Power BI Export Data
If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is...
2016-01-22 (first published: 2016-01-13)
2,225 reads
Blogs
DBA and Developer: Allies or Adversaries?
By Rohit Garg
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and...
New Pluralsight Course - Certified Kubernetes Administrator - Working With Your Cluster
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...
Friday Basics: the CIA Triad
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
Forums
Query about GAC (Global Assembly Cache)
Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL...
How to check for data loss after rollback
Hello SSC, I am not a DBA,. I have some DBA knowledge, but my...
How to create a baseline using counters to analyze server performance?
I am currently working on creating a baseline for our server, using various counters...
Question of the Day
Reporting Services Editions
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers