Forum Replies Created

Viewing 15 posts - 2,176 through 2,190 (of 13,460 total)

  • RE: Need to REVOKE SELECT on all tables for all users in a database

    REVOKE would remove a GRANT that was already created;

    you can get that list from sys.database_permissions, and script the DENY's from there.

    but what about users who were simpyl added to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 26, 2014 at 8:28 am

    #1761112

  • RE: optimisation query

    if you

    select * from MillionBillionRowTable

    That takes a lot of time.

    period.

    you are returning a ton of data, and that requires resources.

    the only way to speed that up is with...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 26, 2014 at 8:22 am

    #1761108

  • RE: Creating a Query to show data side by side

    Meatloaf (11/26/2014)

    Hi Lowell,

    Thank you for your reply. The data each have their own columns.

    My current query is: SELECT EID, LName, FName, Phone FROM EmployeeContacts ORDER BY LName

    How would...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 26, 2014 at 8:17 am

    #1761105

  • RE: Creating a Query to show data side by side

    it depends on the data.

    if you are smart, and are storing them as three distinct strings in three columns, then yes of course. you simp-ly select three columns.

    if you are...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 26, 2014 at 7:52 am

    #1761096

  • RE: problemi dopo migrazione da sql server2008 a sql server2014

    best i can do ?

    translate.google.com

    Hello everyone!

    I wanted to let you know of a problem I had after migration!

    I had a select that in the previous version worked perfectly!

    After the change,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 25, 2014 at 6:58 am

    #1760782

  • RE: Can an sproc have more than one cached instance?

    i believe if you call the same procedure with different ansi settings(ansi_null, etc), you get a different plan cache for each combination, which is created as they are called the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 24, 2014 at 1:47 pm

    #1760608

  • RE: Problem using bcp

    this looks wrong.

    it should be either localhost\instance or machinename\instance

    so i'd expect some of these to be right:

    -S localhost\SQLEXPRESS

    -S .\SQLEXPRESS

    -S PSIMONDS\SQLEXPRESS (asuming your machine is named PSIMONDS!)

    -S 127.0.0.1\SQLEXPRESS

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2014 at 11:07 am

    #1760243

  • RE: Remove ---- from output file

    i've seen this before, i think this is part of sp_send_dbmail when you use the @attach_query_result_as_file = 1 option alongside @query_result_header = 1.

    as i remember it, you have to NOT...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 20, 2014 at 5:50 am

    #1759800

  • RE: Carriage Return in SQL Server

    you also need to be aware of the number of fields in your splits...

    if osmeone doesn't have a two part address, before the city, your fields could not line up...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2014 at 5:14 am

    #1759225

  • RE: Getting directory information for Data/Log/TempDB/Backup/etc

    when i query my dev server for tempdb, for example, i get three locations:

    select * from tempdb.sys.database_files

    D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\tempdb.mdf

    L:\Logs\templog.ldf

    E:\MSSQL\Data\tempdb2.ndf

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2014 at 4:58 am

    #1759217

  • RE: Getting directory information for Data/Log/TempDB/Backup/etc

    well, i know three of them are stored in the registry, o a per-isntance basis.

    EXECUTE [master].dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory';

    EXECUTE [master].dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2014 at 4:53 am

    #1759214

  • RE: Fetch only country name

    yep your error goes directly to y assumptions: based on the sample data, the desired string always exists at the beginning.

    Koen's suggestion is easily the fastest, but there's probably other...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2014 at 4:13 am

    #1759206

  • RE: Fetch only country name

    by making the assumptions outlined below, you can use patindex to find the beginning of the first non-character letter, and grab the substring.

    the desired string always starts the string.

    some character...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2014 at 3:10 am

    #1759194

  • RE: Get name of user with excel file open

    i've used Process Explorer from sysinternals in the past

    , as well as OpenedFilesView

    http://technet.microsoft.com/en-us/sysinternals/bb795533.aspx

    http://www.portablefreeware.com/?id=1030

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 17, 2014 at 7:46 pm

    #1759137

  • RE: Monitoring Tool For SQL Server

    it depends on what you want to monitor, of course.

    so general tools i'm aware of are like this one...

    Dell's Spotlight Freemium is pretty good for free, i kind of like...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 17, 2014 at 5:19 am

    #1758936

Viewing 15 posts - 2,176 through 2,190 (of 13,460 total)