Machine Learning (ML)

Technical Article

RE: Need Guidelines For Using SELECT INTO

  • Reply

Large tables is relative. How do you define "large table"?Like Allen, I would be interested in knowing what blocking issues have been observed. And I would also be interested in the statements those analysts want to use. Will this be stored procedures? Do they *really* need the most recent data or might they be able to […]

2005-04-29

Technical Article

RE: Scripting question

  • Reply

For the database, create a user-defined database role. Assign it the permissions currently granted to AcmeCorp\SalesUsers. Then make the AcmeCorp\SalesUsers user a member of that role. You can use sp_helprotect to list out all the permissions AcmeCorp\SalesUsers currently has and with some text manipulation you should be able to create the GRANT EXECUTE statements needed […]

2005-04-08

Technical Article

RE: Can all permissions to Public role be safely removed?

  • Reply

Short answer, no. Microsoft made minimal changes to earn a C2 compliance standard. Public was largely unaffected. SQL Server 2000 C2 Administrator's and User's Security Guide If you want more details, my GSEC practical looked at this issue... SQL Server 2000: Permissions on System Tables Granted to Logins Due to the Public Role

2005-03-29

Technical Article

RE: nvarchar formatting?

  • Reply

You might want to check out this page to verify that you are actually using Unicode http://mysecretbase.com/ColdFusion_and_Unicode.cfmAlso, storing a resume in a nvarchar column might be a tight fit. You can try ntext for more space.You also might want to research collations in the SQL Server manual. It may provide you with some key insight.Good luck. 

2005-03-03

Technical Article

Database Location query

  • Topic

Morning AllWhen I run the following TSQLselect * from sysdatabasesit give me the location for my master Database asd:\mssql\MSSQL\data\master.mdfHowever, if I check the Db properties through Enterprise Manager, it reports it asd:\sql\MSSQL\data\master.mdfBoth files exist, have virtually the same timestamp, and are the same size.  How do I establsh which is correct?ThanksGary

2005-01-31

Technical Article

DBO_DDLADMIN Role

  • Topic

I am currently experiencing some problems using the database role of dbo_ddladmin in SQL2K. I am adding an NT user group/ad group to the ddladmin role and the users are telling not only can they not add new objects they can't even do a simple select statement. I am not too familiar with SQL2K but […]

2005-01-21

2 reads

Technical Article

Strange problem with extended property

  • Topic

Hello, I have a problem with extended property MS_ConstraintText. MS_ConstraintText property is not shown to other end users except for my own login (which have created the extended property). Another extended property, caption, is displayd correctly for all users. Here is example code: -------------------------- CREATE table T1 ( id int identity not null primary key […]

2005-01-16

2 reads

Blogs

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs

Forums

Re-creating AG after server loss

By izinger

We recently had to rebuild servers that were configured with AG. I built everything...

Cannot run DynamicSQL Statement to merge table with JSON

By Weegee71

Hi there I have a problem with a dynamicSQL Statement. In this code, I...

find connection details for all ssis jobs

By Bhagat

Hi, is there are way using sql that brings a list of the ssis...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers