Viewing 15 posts - 1,966 through 1,980 (of 7,168 total)
That will get you rows. You'll also need a Cross-tab to bring it back as columns:
WITH cte ( ID, Name )
...
February 13, 2013 at 3:58 pm
These are the English messages that get logged automatically.
SELECT *
FROM sys.messages
WHERE language_id = 1033
AND (
...
February 13, 2013 at 3:48 pm
The info you provided about bitness sounds OK.
From the error I am wondering about the existence of the destination Excel file. Does it exist in the prod environment at...
February 13, 2013 at 3:37 pm
I think that is up to the program being called not PowerShell. If the program wants to accept input interactively and does not provide an input parameter for the information...
February 13, 2013 at 3:34 pm
They will only be able to retrieve data from tables to which you grant them SELECT permissions.
If you are asking if there is a way to allow their database user...
February 13, 2013 at 2:41 pm
As was stated READ COMMITTED is the default iso level and the default iso level cannot be changed to something else. Once connected anyone can explicitly change the iso level...
February 13, 2013 at 1:30 pm
That looks familiar 😉
If you're happy I say send it to prod!
February 13, 2013 at 12:47 pm
I like option 2 and that can be achieved dyanmically using a DDL TRIGGER such that every time a database is created a new Database User is add for the...
February 13, 2013 at 12:45 pm
A unique index where all key columns are non-null will achieve effectively the same thing as having a nonclustered PK on those same key columns plus you can add your...
February 13, 2013 at 12:42 pm
Agreed if you only have one drive. I got the impression more drives were available or were being introduced.
February 13, 2013 at 12:33 pm
OK. I should have confirmed that from the start. My bad.
Get a command line working first, then move over to configure the Execute Process Task.
February 13, 2013 at 12:31 pm
andrew 82282 (2/13/2013)
I'm importing a number of tables with SSIS. I have a variable Filename used to select each individual file.
I want to copy the value of this variable...
February 13, 2013 at 12:30 pm
You said in the original post:
I tried to go onto the Location of Zipfile and tried unzipping it manually and it all works good.
Was that just double-clicking on the file...
February 13, 2013 at 12:21 pm
Get-WMIObject Win32_Volume -Computer COMPUTERNAME | Select-Object -Property Volume,Capacity,FreeSpace,Name,@{Name="FreeSpace(GB)";Expression={"{0:N1}" -f($_.FreeSpace/1gb)}},@{Name="Capacity(GB)";Expression={"{0:N1}" -f($_.Capacity/1gb)}},@{Name="freespace(%)";Expression={"{0:N1}" -f(($_.FreeSpace/$_.Capacity)*100)}}
You changed COMPUTERNAME in the command line, right? Namespace is not explicitly set (should be using root\cimv2 under the covers...
February 13, 2013 at 12:18 pm
Viewing 15 posts - 1,966 through 1,980 (of 7,168 total)