Viewing 15 posts - 16 through 30 (of 469 total)
vidya_pande (3/17/2010)
You can have another database created from full back up. Then restore log backups on that up to...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 17, 2010 at 3:07 pm
The error 15105 means - the SQL service account does not have permission on the folder where the files are now. Can you check that and let us know...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 12, 2010 at 9:38 am
Please help me soon...
please provide the table structures soon..;-)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
March 5, 2010 at 7:29 am
Did you find a working solution yet?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 6, 2010 at 12:46 pm
I guess I overlooked your criteria of a Non SSIS based solution :hehe:
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 3, 2010 at 2:46 pm
You can use SSIS to accomplish this.
Use a flat file source(Delimited) and specify column size to say 5000.
Then use a derived column task and create columns on a fixed width...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 3, 2010 at 2:45 pm
Why are you reorganizing the indexes after rebuilding them?, apparently that's what the green arrow between Rebuild and Reorganize does.
Instead take out the green arrow and redirect it to maintenance...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 25, 2010 at 1:32 pm
Check if moving tempdb to new location works..USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = 'D:\tempdb.mdf'); --new location
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = 'D:\templog.ldf') --new...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 25, 2010 at 1:12 pm
Firstly, why did you increase the size to 100gb?
You can alter the db file size to a value higher than the existing size.
DBCC Shrinkfile only reclaims the empty space...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 25, 2010 at 10:14 am
For that you need to specify each column names instead of * and then at the date field use the custom date, something like below
insert into desttable (col1,col2,date,col4)
select
col1,col2,convert(varchar,getdate(),101),col4 from sourcetable
HTH...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 25, 2010 at 10:06 am
Try this...
Select Distinct(DG.UserID)
, DG.UserName
, DG.LastName
, DG.FirstName
From DGUsers DG
where DG.UserID in (select UserId from Orders)
Order by DG.UserID
Gail, I think I missed it completely. I removed the distinct from the second query...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 25, 2010 at 10:02 am
Sorry Gail..I guess i posted my reply about the same time as you asked us to redirect our replies..
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 25, 2010 at 9:59 am
Let me know if the below script works better...
Select Distinct(DG.UserID)
, DG.UserName
, DG.LastName
, DG.FirstName
From DGUsers DG
where DG.UserID in (select distinct UserId from Orders)
Order by DG.UserID
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 25, 2010 at 9:58 am
Below script can be used to find the number of records and the size of each table in a database
CREATE TABLE #temp (
table_name sysname ,
row_count INT,
reserved_size VARCHAR(50),
data_size VARCHAR(50),
index_size VARCHAR(50),
unused_size VARCHAR(50))
SET...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 22, 2010 at 3:30 pm
It seems there is a DDL trigger that is aborting such operations. Check with the Sr DBA if you can be allowed to Disable Triggers otherwise you will keep getting...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 22, 2010 at 3:19 pm
Viewing 15 posts - 16 through 30 (of 469 total)