New answers tagged sql-server-2008
0
votes
Restrict access for Windows administrator
Enable Sql authentication and then disable user login.
Security => logins
right click on sa click on properties then click on status then restart the sql server services.
before you move on to the ...
- 101
1
vote
Best approach for populating date dimension table
Here is a single SELECT query that uses the WITH RECURSIVE statement. It does not require loops, procedures etc.
A RECURSIVE SQL common table expression (CTE) is a query that continuously references a ...
- 111
-1
votes
Reset the numbering at the tabs of the Microsoft SQL Server Management Studio
select * from sys.dm_exec_sessions
will return all of the sessions open on that particular sql server
The tab # is the # of your own session.
Other user will receive their own session #.
- 1
2
votes
Accepted
conversion failed when converting date and/or time from character string only on one of the server
when i enter date manually like '01/06/2023' it shows data in table but whenever i enter getdate() function to get current date automatically it shows no data
GETDATE() returns the current system ...
- 29.6k
Top 50 recent answers are included
Related Tags
sql-server-2008 × 3912sql-server × 2367
sql-server-2008-r2 × 343
performance × 210
t-sql × 207
sql-server-2012 × 185
sql-server-2005 × 149
index × 127
replication × 111
backup × 106
stored-procedures × 95
restore × 93
database-design × 92
ssis × 88
security × 79
ssms × 73
query-performance × 67
permissions × 59
mirroring × 55
linked-server × 52
transaction-log × 49
ssrs × 44
trigger × 39
deadlock × 39
query × 38