Forum Replies Created
Viewing 15 posts - 5,956 through 5,970 (of 7,502 total)
-
RE: Optimizations job error message
this could be your test-script ....
print '00 Creating dbo.test';
go
create table dbo.Test (col1 int not null )
go
print '01 inserting rows into dbo.test';
go
insert into test values(1);
go
print '02 Selecting from unqualified table test';
go
select...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Error 21776: [SQL-DMO] The name ''''dbo'''' was not found in the Users collection
I guess that's what the "true" parameter is for in
use exec sp_changedbowner 'sa', true.
You can use sp_changeobjectowner @objname = 'oldowner.object' , @newowner = 'newowner'
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: How to query file name used for a particular backup?
making this #é&() mistakes, you can immagine the rest of my day
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: How to query file name used for a particular backup?
Still early on the day
SELECT BS.database_name
, BMF.physical_device_name
, BMF.device_type
FROM msdb.dbo.backupset BS
INNER JOIN msdb.dbo.backupfile BF
ON BF.backup_set_id = BS.backup_set_id
INNER JOIN msdb.dbo.backupmediafamily BMF
on BMF.media_set_id = BS.backup_set_id...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: How to query file name used for a particular backup?
SELECT BS.database_name
, BF.physical_name
FROM msdb.dbo.backupset BS
INNER JOIN msdb.dbo.backupfile BF
ON BF.backup_set_id = BS.backup_set_id
WHERE BS.database_name = 'MyDB'
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Optimizations job error message
- If you're using a "sqlserver maintenance plan", it will optimize _all_ objects of the selected databases.
- verify that they don't drop and recreate their tablesat runtime ! because then...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: permission to access .BAK files for test restore
- your sqlserver-serviceaccount or your sqlagent's (if you're using a job) need read-auth for the .bak-file
- you as sql-user ... you need to be at least db-creator or database-owner...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Optimizations job error message
This is one of the enoying things where they use actual "work"-tables in stead of #-temp-tables.
So the create them on the fly, use them and drop the at the end...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Error 21776: [SQL-DMO] The name ''''dbo'''' was not found in the Users collection
use exec sp_changedbowner 'sa', true.
Keep in mind this is one of the flaws of EM. You'll have to disconnect an reconnect to see the correct results.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: permission to access .BAK files for test restore
If you want to restore using EM, you'll need to have the backup-file(s) at the server itself.
If your bak-files are on a remote location, you can use e.g. QA and...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: change name on server running SQL2000 and Biztalk
check http://www.databasejournal.com/scripts/article.php/1496451
to apply the rename of your windows server in your sqlserver instance.
According to my biztalk-admin changing the biztalksettings to connect to the new servername should be a peice...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Achieving Repeatable Reads in Snpashot Isolation
- Oracle does not have locking, it has versioning ! Different concept.
- SQL2005 Snapshot isolation level mimics this behaviour.
maybe these art. clarify a bit :
http://www.databasejournal.com/features/mssql/article.php/3560451
http://msdn2.microsoft.com/en-us/library/ms130975.aspx
http://msdn2.microsoft.com/en-us/library/ms189050.aspx
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: The lady vanishes...(her row!!)
If you're alowed, you could also quickly create a delete-trigger to log all deletes from that table (maybe even narrowing the rows to the ones you want to) into a audit-table....
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Attach Database: specify database owner
after the attatch you'll have to use this :
use yourdb
exec sp_changedbowner @loginame = 'sa' ,@map = 'true'
Also keep in mind EM does not refresh db-owner info ! You'll have to...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Help filtering important details from system table data
how about just adding startupparameters to your sqlserverinstance ?
add -T1204 and -T3605 so deadlock info lis logged into the sqlserver errorlog.
(
1204 Returns the type of lock participating in the deadlock... Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 5,956 through 5,970 (of 7,502 total)