SQL 2012 :: Powershell Command To Install Specific KB
Jul 1, 2015My system is windows 2012 core, no gui installed..I need to install missing kb through powershell. Need the powershell command to install specific KB
View 1 Replies
ADVERTISEMENT
Command Line Printing To Specific Printers, And Specific Trays
Jan 23, 2007Hi All,
Could you guys please help me with printing reports invoked thru command line/ URL access to print automatically to specific printers and specific trays and also is it possible to set the specific printer and tray as parameters.
Any suggestions is appreciated
Thanks A lot in advance
e,g :
http://localhost/reportserver?/testreports/employee sales&UserID='ABC'&LName=Lastname='victor'&rs:Command=Render
SQL 2012 :: Sorting In Powershell
Aug 20, 2015i am using powershell to get the output..I am planning implement sorting to my output.below is the format I am writing my objects to html file.I want sort the object of lastrunoutocome field.
foreach($item in $sqlServer.JobServer.Jobs)
{
Write-Host $sqlserver $item.name $item.OwnerLoginName $item.IsEnabled $item.LastRunDate $item.LastRunOutcome
writeDiskInfo $ServiceFileName $sqlServer $item.name $item.OwnerLoginName
}
SQL 2012 :: How To Insert Powershell Output Into A Table
Mar 20, 2015I'd like to know how to get windows events script below into a SQL Server Table.
Get-WinEvent -LogName application -MaxEvents 200 | where {$_.LevelDisplayName -eq "Error"}
SQL 2012 :: Named Pipes Error From PowerShell
Jun 15, 20151) I can connect to SQL Server 2012 named instance from SSMS.
I can launch Power shell in any of the supported data contexts, for example from the named instance.
However when I try to run a query in Power Shell, I get the named pipes error.
2)I can also provide a connection string and connect to the SQL Server Instance form Windows PowerShell after launching SQLPS, the same as in the above. I can open the connection and verify its state, but trying to run a query results in the same error.
I also see that named pipes is enabled in the SQL Server Configuration Manager.
Some of this is the result of some ambiguity in the Windows User Account in Windows 8 computer. Some of this is documented in more detail here: [URL] .....
This link is not directly related to the above problem, but arises out of the ambiguity in the Username retrieval: [URL] ....
SQL 2012 :: Powershell Script To Verify Showplan Enabled For User?
May 18, 2015I am looking for a sample PowerShell script that allows me to verify that showplan is enabled for a user on a SQL Server 2012 instance. Haven't figured out how to code it.
View 2 Replies View RelatedIntegration Services :: Deploy SSIS Packages 2012 And Run Job Through Powershell
Jun 1, 2015Any script in ssis 2012 packages deployment and create the jobs though power shell script.
View 3 Replies View RelatedReporting Services :: Powershell Script To Configure SSRS 2012?
Jun 12, 2015We have 15-20 report server environments including Dev/SIT/UAT/PROD/DR etc. so instead of configuring it on each servers, we would like a script to use with parameters.
After installing the SSRS 2012 package on each server with given instance and service account, I would like to configure the SSRS through script instead on running the Configuration manager RSConfigTool.exe manually.
we already have created the database beforehand using the scripts provided by WMI. do we need db_owner permission on msdb and master database to configure SSRS?
Data Mining :: Deleting Old Data From Adventure Works 2012 With Powershell
May 3, 2015I am trying to delete tables from data where the ModifiedDates older than 9 years in AdventureWorks2012 database . I get console notified that foreign keys are dropped but the delete statement is throwing errors. I am sure that somewhere the key constraints are not getting altered, but i'm not able to figure it out as i'm a relative beginner to T-SQL. The error and code:
The DELETE statement conflicted with the REFERENCE constraint "FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID". The conflict
occurred in database "AdventureWorks2012", table "Sales.SalesOrderHeader
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null
$option_drop = new-object Microsoft.SqlServer.Management.Smo.ScriptingOptions;
$option_drop.ScriptDrops = $true;
[Code] ....
SQL 2012 :: Monitoring Tool Using Powershell And Performance Monitoring
Sep 15, 2014We are in plan to build a Monitoring tool using PowerShell and Performance Monitor which could monitor 10 to 20 servers. Do you have any reference of any existing tool using Performance Monitor to monitor the SQL Server and available for free? I didn't want to put some effort, if something is available already.
View 2 Replies View RelatedSql Install From Command Prompt
Jun 18, 2008Please let me know how to install sql server by using command prompt.
View 4 Replies View RelatedCommand Line Install
May 4, 2007I am trying to create an quiet install for SQL Server Express. The install is being run under a local administrators account. However, when a user, who is only in the local users group, accesses the application using ClickOnce deplolyment, it says SQL Server Express Edition is not installed.
-Dan
To Install SQL2005 SP2 Via Command Line.
Feb 13, 2008Hi,
I have a problem about the SP2 installation with using command line in vbscript.
In the vbscript, I use the command line as follow.
'Command line parameters to install SQL Server 2005 Service Pack 2
Set WSHShell = WScript.CreateObject("WScript.Shell")
strAppsp2 = "c:sqlsetupSP2SQLServer2005SP2-x64.exe /Passive /quiet"
WSHShell.Exec(strAppsp2)
set shell = createobject("wscript.shell")
...
But it cannot install the SP2.
Then I tried to test the command line again at the command prompt
c:sqlsetupSP2SQLServer2005SP2-x64.exe /allinstances /passive
After that the SP2 installation box is shown but I need to install in unattend mode.
Would you please suggest me the command line to install the sp2 in unattend mode.
Regard,
How Can I Install DTS Packages From The Command Line To MSSQL2005
Dec 12, 2007Hi there
I've just finished writing a script to install our SSIS packages using dtUtil.exe
We also have a whole bunch of legacy dts packages that we maintain. At the moment we rely on these being manually installed - I'm looking to automate this effort (I'm holding back a rant about 6hr production deployments due to people not being able to follow simple instructions)
Didn't find too much out there on this.. unless I'm missing something obvious, it wouldn't be the first time.
Anyone else out there have a solution to this?
thanks
SSE: Command Line Install: MixMode Authentication
Apr 25, 2006Greets everyone...
I am using the Command Line to install SQL Server Express (SSE) on client machine. Below is long Command Line we are using.
setup /qb ADDLOCAL=SQL_Engine,Connectivity SQLXML SECURITYMODE=SQL SAPWD=#SmartPlus01# INSTANCENAME=SPSERVER DISABLENETWORKPROTOCOLS=0
When I try to connect to SSE from a client's machine using the 'sa' account, I get a connection failure message. Interesting enough, when I fire up Management Studio, it shows (under the server properities) that the server is still using "Window Authentication". I want to force Mix-mode authentication. According to SQL-BOL I need the SECURITYMODE=SQL and the SAPWD =<StrongPassword> params to use MixMode. Am I missing something in the command line to use MixMode authentication?
Another pair of eyes looking at this would be great.
P.S. Although Windows Authentication is the prefered method, sometimes it just doesn't fit for everything we need to do.
Thanks in advance
-Juan Garcia, MCP
Arbitron, Inc
juan.garcia@arbitron.com
SQL 2012 :: Output In Specific Format
Dec 12, 2014I have sample data like 'J.S.xxxx','J.xxxx.'
Want to separate the . in the middle of word with single space and display results in following way.
J. S. xxxx
J. xxxx
Need the code in optimized way.
SQL 2005 Express Command Line Install SAPWD
Mar 10, 2008
Hi,
I am trying to setup my install script to install SQL Express 2005 using the SQL Security Mode
and setting the SA Password by passing in parameters from the command line.
setup.exe SECURITYMODE=SQL SAPWD="123456"
This runs the install, but still prompts me during the installation to enter an SA Password.
Thanks.
Same problem with
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194313&SiteID=1
SQL Tools :: Install SSMS 2014 From Command Line
Aug 11, 2015trying to run ssms.msi failed with code 29506....then i am trying to use command line but i do not know how to do this.
View 4 Replies View RelatedSQL Server 2012 :: Find First Value Greater Than Specific Value
Dec 19, 2013I need a query to get the first value greater than a specific threshold value
LoadTemp1 LoadTemp2 LoadTemp3 LoadTemp4 TimeStamp
300 200 100 320 12-10-2013 13:30:29
100 250 113 340 12-10-2013 14:20:12
114 339 209 345 12-10-2013 14:45:01
I need to get the first value >= 340 threshold
I need to make a Benchmark on when the first LoadTemp crosses Threshold of 340 and capture the time.
SQL Server 2012 :: Get Results In A Specific Order?
Sep 11, 2014I have a simple example of what I am trying to do. Here is some code to make a quick table to demonstrate:
create table #students
(
lastname varchar(50)
,firstname varchar(50)
,address1 varchar(50)
[Code].....
I want to select all the records, and them them be in alphabetical order first by lastname, then by firstname, then by address. HOWEVER, and this is the tricky part, I want to group names together that have the same address. So, in this example, I want the results to be in this order:
HallC6309 N Olive
HallP6309 N Olive <---- grouped with the C record because they have the same address
HallE5488 W Catalina <---- back to alphabetical by first name
HallJ7222 N Cocopas
SQL 2012 :: Remove Character From Specific Column
Nov 18, 2014How to remove Character From Column,Just Character. I want to work with number.
View 4 Replies View RelatedSQL 2012 :: Restore Specific Columns From A Database
Dec 15, 2014I have an SQL .bak file and I would only like to restore specific columns as one of the columns is a free text field and is substantially increasing the size of the file. I can't restore it due to disk space constraints so dropping the column isn't possible if I can't get the table into a database locally.
View 1 Replies View RelatedSQL 2012 :: Using Resource Governor To Limit A Specific DB?
Jan 13, 2015I was looking for a little insight on Resource Governor. I have a request from my manager to limit the resources a certain third party's DB can use on our system. We allow them to keep a DB on our SQL 2012 server so they can run query's to compare data to their server without linking the two machines.
I was looking into resource manager to perhaps accomplish this task but I'm not real familiar with it. If Resource governor can be used to only allow a DB named UserDB1 to use only 1GB or Memory at any one time?
Or perhaps there is another way aside from Resource governor?
SQL 2012 :: JOIN If Specific Table Exists
Jun 9, 2015I have standard SQL query for clients, but sometimes a client does not have a specific table.
How do I deal with that? (creating the table is not an option)
SELECT
A.Col1
,A.Col2
,B.Col3
--> Col 50
FROM
TableA A Join
TableB B ON A.ColA = B.ColA
Suppose in some cases TabelB does not exist. How do I make sure the rest of the query runs okay and does not result in an error?
SQL 2012 :: Query To Filter Out Specific Data?
Aug 21, 2015I need to return 1 ip address for each machine. I can easily achieve this with using group by and return max(ipaddress) however I would like to filter out specific range '192.168.%' but only want to do that if machine has more then 1 ip address. If the machine has only 1 ip address then it can return it even if its '192.168.%'
below is test table to show sample data
CREATE TABLE dbo.[testip](
[machineid] INT NULL,
[ipaddress] [varchar](20) NULL
)
GO
INSERT INTO [dbo].[testip] ([machineid],[ipaddress]) VALUES (1,'155.119.1.22')
INSERT INTO [dbo].[testip] ([machineid],[ipaddress]) VALUES (1,'192.168.1.5')
[code]....
Reporting Services :: Command Line Install Option Not Working
Oct 25, 2011I am trying to push the install for ReportBuilder 3.0 and am having an issue with the REPORTSERVERURL option for installing via command line.I have a batch file that works fine, however when I launch the app it does not have a report server configured. I have verified I can connect to my report server if I enter it manually.
View 3 Replies View RelatedSQL 2012 :: How To Find Unique Rows Considering Only Specific Columns
Apr 18, 2014write a query which retrieves only unique rows excluding some columns.
IdStatusmanager Team Comments Proj number Date
19391New XUnassigned One 3732.0 16-Apr-14
19392Can YCustomer Two 3732.0 17-Apr-14
19393Can YCustomer Two 3732.0 17-Apr-14
19394Can YCustomer One 3732.0 18-Apr-14
19395New YCustomer One 3732.0 19-Apr-14
19396New YCustomer One 3732.0 21-Apr-14
19397New ZCustomer One 3732.0 20-Apr-14
In the above table project number and id shouldn't be considered and I should get the unique rows considering rest of columns and sorted based on date. Expected result is
IdStatusmanager Team Comments Proj number Date
19391New XUnassigned One 3732.0 16-Apr-14
19392Can YCustomer Two 3732.0 17-Apr-14
19394Can YCustomer One 3732.0 18-Apr-14
19395New YCustomer One 3732.0 19-Apr-14
19397New ZCustomer One 3732.0 20-Apr-14
19396New YCustomer One 3732.0 21-Apr-14
SQL 2012 :: Selecting From Linked DB2 Server / Specific Column
May 13, 2014I've got an OLEDB DB2 linked server to a db2/AS400 instance and selecting from a table on the server has never caused problems before. One of the columns is a large text field. If I select all the columns but the large text field, it returns as normal, but including the large text field now, I get:
"Transport error: shared memory provider error: 0 - no process is on the other end of the pipe"
The largest entry in the text field is about 5k characters, and there don't appear to be any strange characters.
SQL 2012 :: Kill Processes At A Specific Time Then Log To A Table
Apr 3, 2015So I have a job that shows active processes
INSERT INTO Query_results(login_name, total_elapsed_time, total_elapsed_time)
SELECT login_name, total_elapsed_time, total_elapsed_time FROM
sys.dm_exec_sessions
I need to then kill all sessions at 11:59pm then log all those that are killed. This is so I can schedule a job at that time, I have sessions that are blocking my job.
SQL 2012 :: Track Blocking Details At A Specific Time?
May 28, 2015In sql 2012 i want to track the blocking details at a specific time is any query to get the data ?
View 6 Replies View RelatedSQL Server 2012 :: How To Hide Specific Record(s) From Results
Nov 2, 2015I have written a SQL statement.There is a table called customer.It contains all customer data with customerid as PK.There is another table called logs and it contains customerid as foreign key and it contains a field to keep more than 90 days older user accounts.That field name is "Checked"
What I need get all records from these 2 tables and remove/hide more than 90 days older customers from record set.See my illustration.
I have written this code but I dont understand how to remove more than 90 days older user from result (because customer table doesnt contain a record called "Checked")
SELECT *
FROM [dbo].[Customers],[dbo].[VIESLog] WHERE [dbo].[VIESLog].[Checked] < DATEADD(day, -90, GETDATE())
SQL Server 2012 :: Output Of Table Required In Specific Format
Apr 17, 2014I need to display the output of a table in a specific format, I have attached the sample screenshot and code for reference.
I tried with pivot but does not seems to be working.
SQL 2012 :: Recovery Advisor Won't Open Or Start For Specific Database
Jul 1, 2014Today we were trying to use restore wizard (recovery advisor) to restore a database which is over 80 GB, but the wizard won't load or start. However the wizard dialog box opens without any problems with all other databases stored in the instance. Is there any problem or reason to why the restore wizard won't come up?
This is SQL 2012 enterprise version we are running.