The Patch Wild, Wild West
Microsoft might be changing their patching process for applications. This has Steve Jones worried they may move towards an Apple/iOS like model, which would not be good for server systems.
2013-04-17
149 reads
Patching
Steps to Apply a Service Pack or Patch to Mirrored SQL Server Databases
Planning on patching my SQL Servers to the latest service pack, but not sure how to complete this for a environment that is using database mirroring? In this tip, will outline the environment and then walk through the process of patching mirrored servers.
2012-06-22
3,569 reads
RE: Query relational data
I assume you are referring to metadata. Take a look at the INFORMATION_SCHEMA views. For example: SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' This will show you all tables in the database. Look up INFORMATION_SCHEMA in Books Online.
2005-05-26
PTS and Excel
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2005-03-14
RE: Windows Authentication versus specifying userid/password
For info:To use WIndows Authentication you'll first need to ensure that the SQL Server is set-up for it:Right click on the SQL Server in Enterprise Manager and select the SECURITY tab and check the setting is set to "SQL SERVER AND WINDOWS".For Windows Authentication to work the SQL Server and the PCs that want to […]
2005-03-14
DMO JOBs Script method differs from EM Generate Script
I want to generate scripts for my jobs. I've found a couple of differences between using EM to Generate Script and DMO.Using EM I get : -- Add the Target Servers EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)' Using DMO Script method I get : execute @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, […]
2005-03-10
1 reads
RE: FTP HELP!!!!
When doing a manual transfer of the small data sets (up to 30MB) on each node, is there any significant difference in speed/throughput?
2004-12-17
RE: xp_cmdshell & ODBC WrapperRead() error...
hi,It seems to be either an old MDAC or a security problem ( is the user granted to execute xp_cmdshell and does he have privs to access the files ). If not it can be a network issue.BTW; how dit you establish to connect the SAN to a Standard Edition. Regarding the documentation on this […]
2004-11-17
RE: need help in writing join select query
this article might help:http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q175/5/74.asp&NoWebContent=1
2004-10-18
RE: Sp3a on Client SQL Server 2000
I looked in the registry under:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\tools\ClientSetup\CurrentVersionI would have tougth that:If 8.00.194 Then SQL Server 2000 original releaseIf 8.00.384 -> SP1Si 8.00.534 -> SP2Si 8.00.760 -> SP3 ou SP3ABut this value did not changed.But the new value CSDVersion was set to 8.00.761Any idea?Best regards,Carl
2004-10-18
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers