Viewing 15 posts - 61 through 75 (of 88 total)
Thsi may help you.
January 13, 2012 at 6:10 am
@@servicename-Returns the name of the registry key under which SQL Server is running.
@@servername-Returns the name of the local server that is running SQL Server.
January 13, 2012 at 3:36 am
BUILTIN\Administrators Group might be not added while installation.
January 12, 2012 at 5:09 am
January 12, 2012 at 4:56 am
can anyone help me what's the impact of using "WITH(nolock)" in distinct ?
why is it returning duplicate rows ? and why is it returning more than 1 row when the...
January 12, 2012 at 4:38 am
jberg-604007 (1/9/2012)
January 10, 2012 at 11:56 am
Why dont you go with database mirroring?
January 10, 2012 at 11:14 am
that login might be disabled in sql server . Check this.
January 10, 2012 at 11:03 am
sqlquest2575 (1/9/2012)
i am trying to check if the Check_Policy and Password_expiration is enabled or Disabled for a particular login. I can do this through SSMA but i would like...
January 10, 2012 at 6:50 am
SQL_By_Chance (1/9/2012)
Hi,I wanted to know if we can select percent of records for each group?
something like :-
SELECT TOP 30 PERCENT *
FROM LOCATION_TABLE
GROUP BY STATE
ORDER BY CITYNAME
As you...
January 9, 2012 at 10:45 am
This may help you.
http://www.sqlservercentral.com/articles/Backup+%2F+Restore/72234/
January 9, 2012 at 7:28 am
January 9, 2012 at 6:02 am
Do you have any backups (Full,Log) prior to delete? if yes then restore the backup in any other machine like on UAT or dev then transfer the data using import/export.
January 9, 2012 at 5:58 am
Viewing 15 posts - 61 through 75 (of 88 total)