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
-3
votes
1answer
24 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
vote
2answers
36 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
1answer
144 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 ...
0
votes
1answer
34 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
0answers
5 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 |...
0
votes
0answers
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
0answers
21 views

script only works with execute as SA

I created a simple script to send us disk alerts when a disk is almost full ( i know there are better ways to do this, this is just a simple question ) EXECUTE AS login = 'SA' CREATE TABLE ##...
0
votes
2answers
34 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
1answer
49 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
1answer
104 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
1answer
45 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
1answer
22 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
1answer
38 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
2answers
58 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
3answers
317 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 ...
-2
votes
2answers
31 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
1answer
41 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....
0
votes
0answers
28 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 ...
0
votes
1answer
21 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 @...
0
votes
1answer
40 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 ...
1
vote
1answer
61 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 ...
0
votes
0answers
25 views

SSIS package run error indicates wrong credentials after VM migration

First, I am not a SQL DB admin. I inherited this system and working to migrate away from it...that said: I have an old MSServer2000 SQL DB we migrated to VM. That server offloads data to another SQL ...
3
votes
2answers
94 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 ...
0
votes
2answers
682 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
1answer
671 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
2answers
640 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 ...
1
vote
0answers
60 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 ...
0
votes
0answers
18 views

Enable query logging for single user on SQL server 2008 and SQL server 2016

I need to monitor queries executed by a specific set of users on a database. I need to check them on a weekly base. Is that possible on SQL server 2008r2? And 2016?
2
votes
6answers
2k 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 ...
0
votes
1answer
103 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)...
-3
votes
1answer
53 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
2answers
26 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
1answer
50 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
1answer
110 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
1answer
56 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
vote
1answer
144 views

Store Decimal values without Trailing Zeros

I am using SQL Server 2008 R2 version. Is there any method to store decimal value in SQL without extra trailing zeros(like Float data type format). I have created a column with decimal data type with ...
0
votes
1answer
55 views

SQL 2008 permissions - cumulative or not?

I have a SQL 2008 production database which gets replicated using log shipping to a second, completely different SQL 2008 server. There is also another copy which is restored at irregular intervals to ...
0
votes
3answers
274 views

How to remove sysadmin from sa login in sql server

I have a requirement wherein I need to remove sysadmin server role from sa login. I created 1 more user and gave the sysadmin role to the user. When I uncheck sysadmin from sa login it throws an error....
0
votes
1answer
173 views

Log File Size and dbcc sqlperf (logspace)

Consider the following log file setting for a database named XYZ: Initial size = 250MB, Autogrowth by 500MB, Limited to 1GB I have created a SQL Job to monitor the size of XYZ database ldf using the ...
0
votes
1answer
663 views

Extracting string after and before a character '-' or '<' using Sql Query

I have table with one column 'UDF_WorkLocation_6' which contain string.Please Review following table. UDF_WorkLocation_6 MUMBAI - Maharastra<6> AHMEDABAD - Gujarat<1> MUMBAI - Maharastra&...
0
votes
1answer
144 views

Delete records from table A where col 1 and col2 are in table B

I am wanting to delete records from a table if multiple columns in this table are in another table. Currently, I usually just concatenate the columns and use the WHERE IN method: DELETE FROM TableA ...
2
votes
1answer
476 views

Does SQL Server Support Parallel Bulk Inserts From Multiple Connections?

Does SQL Server support parallel bulk inserts into the same database table? Some clarifications for my particular use case: The table has a clustered index composed of two distinct index keys, and ...
0
votes
2answers
114 views

T-SQL query must include and exclude child rows

I have simple parent -> child (one to many) relationship. Need to return children that have all given attributes, in this case red hair and brown eyes. Table: CREATE TABLE [dbo].[children]( [...
0
votes
1answer
29 views

Where to find the whole log of a maintenance plan package job that failed with error?

I have a maintenance plan that runs on SQL Server agent as a the job and finishes with error. However the error is not visible in job history in SSMS, the text of Message is seemingly truncated. How ...
-3
votes
1answer
519 views

RESTORE HEADERONLY is terminating abnormally [closed]

I am unable to restore my database. I am getting this error message: RESTORE HEADERONLY is terminating abnormally(Microsoft SQL Server, Error: 3242 Please help with a solution. Version is 2008. Am ...
0
votes
1answer
46 views

Table size increasing drastically in sql server

When I ran: SP_Spaceused TEST. I got this output which is very strange for 20918 rows. Output: name rows reserved data index_size unused TEST 20918 6240816 KB 6235480 KB 2304 ...
3
votes
1answer
91 views

How can I go about building a relationship with variable but ordered number of columns in a table?

First, I'm not a DBA or even much of an SQL person, so I apologize if this is too much of an entry-level question! I have been tasked with redoing an old csv file and turning it into a relational ...
0
votes
1answer
87 views

Restore Database without taking RDP [closed]

I have a DB server 192.168.X.X, Now due to some Issue with the domain user we are unable to get the RDP of that server. but we can get the DB connected from other server which is there on the network. ...
-1
votes
1answer
179 views

MYSQL Error: Incorrect usage of UNION and ORDER BY?

Am trying to randomize my first query but ran into an error "Incorrect usage of UNION and ORDER BY" Kindly find below my queries: SELECT * FROM( SELECT deal_page.id, ...
0
votes
1answer
37 views

SQL Merge Replication Issue - problem where backup and maintenance job which is running till morning and most of the server jobs are stuck

We have a merge replication environment which includes Publisher: Server1 where only one database of 125 GB in replication and also Distributor is also configured on same server hosted in a HyperV ...

1
2 3 4 5
78