sql-server-2008-r2 Questions
7
How to drop all extended properties on SQL Server in a scriptable way?
Allege asked 11/9, 2012 at 11:14
6
Solved
I have SQL Server 2008 R2 inside Windows Server 2008. But when I tried to start the "SQL Server Browser" service, I got the following error:
The service cannot be started, either because it is d...
Trilingual asked 1/7, 2013 at 12:40
10
Solved
My sample query is
SELECT D30.SPGD30_LAST_TOUCH_Y
from CSPGD30_TRACKING D30
My given date format is like "2013-01-01 00:00:00.000". I need to convert this date format to "mm/dd/yyyy hh:mm AM/P...
Bounteous asked 22/2, 2013 at 9:31
5
Solved
How can i convert an SQL Server datetime value to a datetimeoffset value?
For example, an existing table contains datetime values that are all in "local" server time.
SELECT TOP 5 Change...
Buy asked 25/7, 2013 at 18:46
3
Solved
I recognize there has been many questions posted about converting strings to datetime already but I haven't found anything for converting a string like 20120225143620 which includes seconds.
I was...
Deuno asked 23/2, 2015 at 16:17
9
Solved
I am writing a Stored procedure in SQL Server 2008.
I need to check if a table exists in the database. If it doesn't then I need to create it.
How do I do this?
Worrell asked 10/5, 2011 at 14:53
3
I am getting an error while executing the query in a SQL Server job. But if I execute it directly, it works fine.
Executed as user: NT AUTHORITY\SYSTEM.
XML parsing: line 10, character 33
Une...
Interlocution asked 28/1, 2016 at 6:20
14
After installing SQL Server 2008, I cannot find the SQL Server Configuration Manager in Start / SQL Server 2008 / Configuration Tools menu.
What should I do to install this tool?
Embayment asked 23/3, 2012 at 18:40
20
Solved
Currently, my database is in Single User mode. When I try to expand me database, I get an error:
The database 'my_db' is not accessible.(ObjectExplorer)
Also, when I try to delete the database...
Chiekochien asked 23/9, 2013 at 18:10
2
Solved
I am using SQL Server 2008-R2, but I'd be interested in a more general answer too ...
I have a table with hundreds of millions of rows, each with a "DateModified" field (datetime2(7))
Now I very ...
Pit asked 5/9, 2013 at 23:5
5
Solved
I have to 2 databases DB1 and DB2.
I have a view called View1 which is stored in the database DB2. Now I want to ALTER VIEW from DB1 database.
My attempt:
ALTER VIEW DB2..View1
AS
SELECT * FR...
Ghiselin asked 28/9, 2015 at 16:50
4
Solved
I connected to to sqlsever2008 with odbc(with dsn) and php but problem is that when I retrieve information from that it has character like ���������. My datatype in sqlserver is nvarchar. Any idea ...
Namedropping asked 29/5, 2013 at 11:42
4
Solved
Who can explain list of xp_Delete_file parameters in sql server. I don't find msdn document for this stored procedure.
I got script of xp_Delete_file from maintenance plan but didn't understand fi...
Riyadh asked 5/7, 2014 at 4:32
11
Solved
I get the following message when I want to create a new publication or Subscription.
"Sql Server replication requires the actual server name to make a connection to the server. Connections through...
Wormhole asked 21/11, 2011 at 12:46
26
Solved
I have many users on my web site (20000-60000 per day), which is a download site for mobile files. I have remote access to my server (windows server 2008-R2). I've received "Server is unavaila...
Acierate asked 22/12, 2011 at 10:15
6
Solved
I have a problem with sending notification when the job fails. I created Database Mail Profile and assigned it to SQL Agent and the restarted SQL Agent.
When I run a procedure msdb.dbo.sp_send_dbma...
Backbone asked 5/4, 2013 at 15:24
33
Solved
I am having error while connecting to SQL Server:
Details in Stack Trace are:
===================================
Cannot connect to ServerName.
===================================
A co...
Saval asked 23/12, 2015 at 7:18
7
Solved
I'm trying to remove white spaces from a string in SQL but LTRIM and RTRIM functions don't seem to work?
Column:
[ProductAlternateKey] [nvarchar](25) COLLATE Latin1_General_CS_AS NULL
Query:
s...
Wyndham asked 8/1, 2013 at 8:57
20
Solved
We use SQL Server Management Studio 2008 R2. IntelliSense works with SA account perfectly. But it is not working with Windows Authentication user. The user has access master db with db_owner role b...
Kate asked 23/7, 2015 at 7:32
3
Solved
If I have a table that looks like this
begin date end date data
2013-01-01 2013-01-04 7
2013-01-05 2013-01-06 9
How can I make it be returned like this...
date data
2013-01-01 7
2013-01-02...
Touter asked 3/5, 2013 at 12:29
4
Solved
We currently execute a stored procedure against a linked server using:
EXECUTE [LinkedServer].[DatabaseName].[dbo].[MyProcedure]
For example:
EXECUTE Screwdriver.CRM.dbo.GetCustomer 619
And this ...
Nedry asked 23/1, 2019 at 19:16
4
Solved
I want to convert given date into the format YYYY-MM-DD.
Given date:
DECLARE @Date1 VARCHAR(50) = '30-01-2015'
Now I want to convert it into the 2015-01-30.
My try:
Try1:
SELECT CONVERT(VARCHAR(50...
Mickeymicki asked 28/10, 2015 at 7:11
4
Solved
I have this stored procedure:
ALTER PROCEDURE spCertificationType
@result nvarchar(15) output,
@mode int
AS
BEGIN
if @mode = 1
begin
exec spGeneratedID 2, @result output
print @result
end...
Langevin asked 26/8, 2015 at 6:47
11
I have encountered an error while working with bcp:
SQLState = 22001, NativeError = 0 Error = [Microsoft][SQL Server
Native Client 10.0]String data, right truncation
I'm trying to unpack the data...
Noticeable asked 19/7, 2012 at 17:59
6
Solved
I often check the following option in the hope that it will be implemented when the report is rendered on the RS web portal - but it never works...
The reports usually have some Row Groups - doe...
Alongshore asked 27/2, 2013 at 20:42
© 2022 - 2024 — McMap. All rights reserved.