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"...
<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...
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...
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:...
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...
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...
My cowoker (yes, honestly, this is my coworker doing this [<img src='/community/emoticons/emotion-2.gif' alt=':D' />] ), used the select statement in...
You know how when we create tables, we can have column descriptions... where's that stored..looked at sysobjects but dont think it's there.
I was just looking at a client's database, sql2000. They had a problem running a stored procedure for some users. They have a proprietary software...
I like to know if this is wrong before i open my mouth to my coworker [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />He has...
ok, this is my coworker has ..this is his first time writing a sql stored proc... declare @mindate as Datetime Select @mindate=-53690 Then in his...
My coworker has a sql statement like this: Select Distinct col1,col2 from Table1 --Table1 has more than 2 columns... I thought "distinct" will...
I need this advice my manager actually. This is our situation : SQL2000 was designed by a company that's actually does AS400/iSeries databases. SQL...
We have 3 client databases. D1, D2, D3. This is what I wanted to do: 1.Create D1NEW, D2NEW, D3NEW. 2.Transfer Data from D1 to D1New, D2 to...
I have a stored proc. I have 3 updates in it. If the first update casues an error like "duplicate" error, I want to still continue to the second and...
I have this update statement but I want to skip records that already exist and not update them.. is this correct? Update LETRACTV set L1DBTR =...
Wonder how this is doable: If i have a table like this: Old New A B B C C D D E X Y E MMM So,A -->B --> C-- >D-->E -->MMM. X...
Our vendor has a view with this code. The lowest date they use for SQL Server is 1753-01-01 (i think because they come from AS400 world and wanted...
I'm adding a column thru QA: Alter TABLE [AGNGROU] Add [GRPTYPE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT...
Not sure why this isnt working: Create Procedure Test @lib VarChar(10) AS Declare @App VarChar(300) Declare @SQLStmt VarChar(5000) Set...
Separate names with a comma.
