we have a client who used the maintenace plan like this link: http://www.mssqltips.com/tip.asp?tip=1013 They have "reorganize data and index pages"...
hmm..."Users", I clicked "Permissions" and for that object these were checked: Select, Insert, Update, Delete and DRI.. I Unchecked DRI and now it...
<br /> I dont know what's going on with a Login...<br /><br />Under Security, I double click the Login XXX and and it's marked as "Public" and...
are you sure you're running the SP in the correct database? have u looked at in QA?
He wants to check the "AWE" in sql2005, i found this : "The AWE memory above 3GB functions as an extension of the BPool and provides additional...
read it but didnt understand it much...we're on sql2005/64bit...in sql2000, we could right click on the server, choose properies and then change...
This is related to the question i asked here: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=14561&SearchTerms=g512 my coworker was...
I did this: select * from sys.database_permissions where grantor_principal_id = user_id ('user to be deleted'); Igot 4 rows back with these columns...
I ran that select from sysobjects.. I got no rows back. I double clicked on the user and db_owner was not checked. There's no Login for it . I want...
you're kidding..wow..didnt know.. thanks.
I ran sp_server_info on both sql2000 and sql2005... IDENTIFIER_CASE is mixed in both servers... our app sends upper-case string... so howcome when...
We have a sql2000 and sql2005.. I created a login in 2000 and password is lowercase, the first letter of login name is upper case ..so for example:...
so I have to find out what that login owns and then change the object ownership? if so , anyway to find out what that login is owning?
My manager created a login for himself on our new sql2005 server, he marked it as "db_owner". I want to delete this but i get the msg that the login...
I did test the code suggested but I misread the "month" and the "day"[B)] [:I]<br /><br />Yes, i didnt add "easy"...next time [<img...
oh yeah, silly me![<img src='/community/emoticons/emotion-2.gif' alt=':D' />]
Roji- dont think that's correct. What you have subtracts 15 from the year, not from the days. This one works: select CONVERT(CHAR(10), DATEADD(DAY,...
no, not impatient but sometimes u have a client who wants whatever done NOW. and I think Chappy is correct, it's dateadd, not datediff..so maybe Joe...
I dont want to be a DBA!...I'm a dotnet developer... and we have no DBA's here. I'll google as I dont have time to read BOL from start to finish now
This shouldnt be too hard but i cant figure it out... I have a date : mydate in a table, 2006-03-28 00:00:00.000 I want to subtract 15 from 28. I...
Separate names with a comma.
