Questions tagged [sql-server-2008]

SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.

Filter by
Sorted by
Tagged with
1 vote
0 answers
36 views

Query to Extract all Values below Certain Amount ignores 0-values

Trying to write a query in SqlServer Dev 2017 with SSMS with Object Explorer. I'm trying to extract all members ( PK) with totals ( Sum(ColumnValues)), below a certain amount. My code extracts all ...
  • 845
0 votes
0 answers
70 views

What can cause cyclical CPU spikes on a SQL Server precisely every 5min

Setup Microsoft SQL Server 2008 on Windows Server 2008 (Yes I know I need to upgrade). The server is accessed by a single Linux/Apache web server. Problem Starting about a week ago and slowly getting ...
0 votes
1 answer
85 views

Cannot Insert it into in my table for Special characters when ANSI_WARNINGS is Off even with nvarchar

I want to insert a data row into my table as name: DSKWOR00 , but I get this error : String or binary data would be truncated. so I turned ANSI_WARNINGS OFF and it inserted the row but the result ...
2 votes
1 answer
272 views

Why SERIALIZABLE level does not lock the table for other session in SQL Server

I want to Prevent concurrency in my table for Delete, Insert, Update, and Select so I tried to use SERIALIZABLE for the table before transation, but that didn't lock the table for other processes! how ...
0 votes
1 answer
71 views

Anything but small ODBC queries failing over long distance VPN after SQL Server Swap

I recently swapped database servers (restored databases from old to new and then swapped IPs)... Old: Sql Server 2005, Windows Server 2003 New: Sql Server 2008, Windows Server 2012 All processes ...
  • 619
1 vote
2 answers
225 views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGIN'

I'm facing a very specific issue on my SQL Server instance. Recently, I had to create a Linked Server (referencing server B) in my server A, to connect to a database in B through A. Everything worked ...
0 votes
0 answers
29 views

Remove requirement to specify [default] MS SQL port in vb and vbscript connection strings

I need to 'swap' an old database server (Windows Server 2008, SQL Server 2005) with a newer/better one (Windows Server 2012, SQL Server 2008) I tested this swap yesterday and everything worked on the ...
  • 619
0 votes
1 answer
53 views

schema ownership/permissions in MS-SQL vs Oracle

Hopefully I'm using the write terms here. I'm pretty good with concepts usually but don't always know the technical terms to describe it correctly. Here goes... I'm used to working in MS SQL Server ...
  • 173
0 votes
0 answers
65 views

Unable to attach other 2nd MDF file Error It is not a primary Database

The windows got crashed and we copied the file from hdd to other machine..... Let me explain you .. We have this db since many years one day the c:drive got full so the dba make changes and create new ...
0 votes
1 answer
84 views

Most recent version of SQL Server Management Studio that works with Windows 7 pre SP1?

I am trying to do some work with SQL Server 2008 (not 2008 r2, just 2008) that is installed on a Windows 7 Pro 32-bit PC. It's just Windows 7 with no Service Pack 1 applied. I have no option to update ...
-5 votes
2 answers
1k views

Select rows with a duplicate ID but different value in another column

I have a table like this I would like to select the Itemid that occurs more than once with a different Rate with group by Masterid The output should be something like:
  • 5
0 votes
2 answers
326 views

Is there any way to get current transaction id in SQL SERVER 2008?

I want to get current transaction id to log something in another process. The code is actually run in .net, but in SQL Server it will be similar to the following pseudo code: BEGIN TRAN <GET ...
  • 1
1 vote
0 answers
76 views

Create Calendar with Pivot or function in SQL SERVER

Is it possible to get a calendar with this structure from my AUT_CALENDAR table? I am applying PIVOT to obtain a calendar with the following query. DEMO SELECT IDCALENDARIO,NombreDia, [Lunes], [...
  • 119
1 vote
0 answers
96 views

Migrate MSSQL 2008 database to MySQL 5.7 or 8.0

I am trying to migrate an old database runing in SQL Server 2008, to MySql 5.7 or 8.0 using MySql Workbench (Migration wizard). It gave me this errors Traceback (most recent call last): File "...
0 votes
0 answers
69 views

Can't connect to SQL Server using its actual server name

I have a SQL Server instance, its actual server name (@@servername) is actual_name, and its alias is alias. When using SSMS to connect, I can only connect using alias, but not using actual_name. ...
  • 23
0 votes
2 answers
130 views

How To trim last two digit of the varchar in SQL SSMS? [closed]

I have a column [CALMONTH] which is a varchar in SQL Table. Data is like "202003" where 2020 is the year and 03 is the respective month. I need to trim the month'03' alone to use it in the ...
0 votes
0 answers
87 views

Microsoft SQL Server - Recovery MASTER Database

I have backuped "master" database from 1 server and need to recovery it to another server. In "master" database or in another database - not matter. Just i need access data. When i ...
's user avatar
0 votes
1 answer
56 views

SQL Server Access Database in Filesystem

We have a Windows Server 2008 which is offline. We no longer have access to the server OS, or any GUI tools, but we do have a backup of the entire C:/ of this server. This server used to host an SQL ...
-3 votes
1 answer
62 views

Sql 2008 export table csv with headers and data

I need to export a table in SQL Server 2008 with headers and data delimited with | ( pipes ), but some information inside of this table have , ( comma ) and CR or LR, it's possible to put it a "&...
  • 1
1 vote
2 answers
68 views

Replicate one database in one server to 2 other servers SQL2008

In product ion, we have a transactional replication between 2 servers with data from one database going from server A to Server B. We now want to add another server C for the short period of time ...
4 votes
1 answer
223 views

Changing SET options within cursor - Different behavior based on compatibility level

I have found a difference in behavior on a piece of code between database compatibility levels and wondered what the cause of this is. Below is a simple example that iterates through a tally table and ...
  • 1,575
0 votes
1 answer
54 views

I want to pull a report from multiple sql servers, where the Database owner and job owner is not SA

I want to pull a report from multiple sql servers, where the Database owner and job owner is not SA. I need a report from a Central monitoring server, if the database owner and job owner is not SA, I ...
0 votes
0 answers
14 views

Collection Targets on the basis of Previous Months Sales Figure

I have having following Yearwise and Monthwise Sales Figures. +-------+-------+------+---------+ | S. No | Month | FY | SaleAmt | +-------+-------+------+---------+ | 1 | Jan | 2020 | 500 |...
's user avatar
0 votes
0 answers
14 views

3 select and collate the result of the query or organize (order by) by fields of the tables

I have 3 tables and each one with different structure and number of different columns, but the first 4 columns are the same in all tables. For instance Table 1 Type id1 id2 Period FirstName LastName ...
0 votes
2 answers
81 views

Finding groups which have two values in another column

Given the following sample rows: MTYPE RNO VAL S 1 V1 S 1 V2 S 1 V3 R 1 V4 S 2 V5 S 2 V6 R 3 V7 R 3 V8 How can I list groups of RNO which has both 'R' ...
-1 votes
1 answer
101 views

Need best practices to maintain TempDB which is growing to 100GB now, is moving Tempdb to 35GB drive have any limitations? [closed]

Can moving TempDB to smaller drive cause failures? How can TempDB be configure to use 35GB drive without any issues? Please suggest if something needs to be taken care for this smooth transition of ...
0 votes
1 answer
157 views

How to delete duplicate from 140 GB SQL server table where 30% records are duplicate without causing overheads like transaction logs full? [closed]

How to delete duplicate from 140 GB SQL server table where 30% records are duplicate without causing overheads like transaction logs full? table doesn't have primary key.
1 vote
1 answer
52 views

Separate Specific Indexes VS Single Inclusive Index

I have four tables, all of which have around the same large number of rows (except Customer): Shipping (PackNumber, PackLine, OrderNumber, OrderLine, CustomerID) Orders (OrderNumber, OrderLine) ...
0 votes
1 answer
23 views

Migration db (error when alter DB)

i am new as DBA. i want to migrate db, can i do one time alter for all data ?. or must one alter to one data ? this my query. DECLARE @name VARCHAR(50) DECLARE db_cursor CURSOR FOR SELECT name FROM ...
-1 votes
1 answer
41 views

restore a corrupted page

I have Damaged a page in my database and now I want to restore it let me get this straight 1- I created a full backup 2- then insert info in some tables 3- creat a deferential backup 4- specific a ...
-2 votes
2 answers
562 views

How to join two tables and rename the new table? [closed]

I want to join two tables in sql and want to connect it with my .net project where I used web forms. help is needed. thank you
3 votes
3 answers
1k views

Copy tables to another SQL Server keeping the identity property

Objective I want to make a exact copy of 10 tables from a database on a SQL Server into my local SQL Server. The local copy is used for testing. Problem The copied tables all have the identity ...
  • 133
-2 votes
2 answers
32 views

Codeignier---sql database [duplicate]

[Microsoft][SQL Server Native Client 11.0][SQL Server]Column 'TantraBackup00.GuildName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause....
0 votes
1 answer
170 views

Breaking down SSIS keystring values for connection manager between Server2000 and Server20008

I have an SSIS package between a SQL2000 and SQL20008 server that cannot connect since migrating to VM. The SSIS package runs a data transfer between the two servers using 3 Connection manager strings....
  • 75
0 votes
0 answers
31 views

Changing SQL Server2000 settings after converting to VM?

We have migrated a SQL 2000 server to VM and I am wondering what changes will need to be made on the VM? After the VM migration an SSIS package that transferred data from the 2000Server to a ...
  • 75
0 votes
1 answer
42 views

issues with subquery sql

Hi im getting this error: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. this is my current SQL query: DECLARE @UgpEntry VARCHAR(50) SELECT @...
's user avatar
0 votes
1 answer
74 views

Can SSIS packages call other SSIS packages in the connection string?

I am running an SSIS package that transfers data from one (SQL2008) server to another (SQL2000). However after P2V conversion the SQL2008 server cannot execute an SSIS package due to a user ...
  • 75
1 vote
1 answer
339 views

Able to connect with connection manager but SSIS package does not authenticate

I have an SSIS package that connects MSSQL2008 server to MSSQL2000 and pulls data off the 2000 server and transfers it to the 2008 server. The 2000 server was recently virtualized and since then the ...
  • 75
3 votes
2 answers
120 views

Max Server Memory configured but it increases more of its configuration

Following a previous post I've written, I've configured my server with the following parameters: I put 22497 as MAx Server Memory, disable AWE, since it runs in 64 bit environment and it's a ...
  • 123
0 votes
2 answers
2k views

SQL Server Setup failure - Cached MSI files are missing

Trying to apply SQL Server 2008 SP4 to an old instance I now have to look after, but the installer is failing with TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error:...
-1 votes
1 answer
2k views

Migration from SQL SERVER 2008 R2 to 2019 with Log Shipping [closed]

Is possible to run swing migration from SQL SERVER 2008 R2 to 2019 with Log Shipping?
9 votes
2 answers
868 views

SQL Server Instance How to recover memory used [duplicate]

I know that may be this question has been answered a lot of times, but I need a better way to solve it or to demonstrate to my boss that this is a normal behaviour or there is something that I'm ...
  • 123
1 vote
0 answers
75 views

Stored procedure to delete the 4 large table records in small chunks

As I am new to procedures, I request your help on below pls. There is a requirement to delete the records from a large table in small chunks like 10 Million records at a time. For example, if you have ...
  • 11
3 votes
6 answers
4k views

MS-SQL-Server 2019 is slower than SQL-Server 2008

Since we updated from SQL Server 2008 to 2019, the queries have become much slower. The following query ran for ten minutes on version 2008. On version 2019 it runs for over 30 minutes. Until ...
  • 69
0 votes
1 answer
342 views

SSIS 2008: Illegal characters in path when trying to rename a file

I have a task that should rename a file I have a variable called RenameFileName \\servername\csv\BACKUP\" + (DT_WSTR,4)DATEPART("yyyy",GetDate()) + RIGHT("0" + (DT_WSTR,2)...
  • 194
-3 votes
1 answer
127 views

Change Consecutive Row Value [closed]

I am trying to change value of Consecutive AA to first AA as AA1 and second one as AA2, if only one AA then it should be as AA1, its possible to change all AA to AA1 and then search for 2nd ...
0 votes
2 answers
28 views

Extract insertions that failed because of size limit from SQL Server Express Transaction Log

I have a SQL Server Express database with Full Recovery Model. Several months ago, the database hit it's size limit (10GB) and some data did not successfully get added to the database. Several weeks ...
0 votes
1 answer
83 views

DB autogrowth issue

I have a database that will growth in 1 month time the autogrowth was set to 500MB but as I monitored it, the consumption is 1GB+ per day. Should I wait for it to auto grow or is it better to set the ...
0 votes
1 answer
276 views

Minimal logging for bulk inserts?

I have many scripts running that truncate entire tables and rewrite data daily, however this fills my transaction logs very quickly. All these scripts use INSERT INTO .. SELECT. So recently I've ...
0 votes
1 answer
183 views

The transaction log for the database fills up overnight everyday

Lately my server is overloaded because of daily running SQL jobs, my transaction log grows very large throughout the night and I run out of disc space. The short term solution was to shrink the log ...

1
2 3 4 5
78