Viewing 15 posts - 466 through 480 (of 961 total)
Try replacing the IP with the server name. Are you able to access other procs within the server ?
February 23, 2012 at 11:49 pm
BuiltIn\Administrators should not be added as SQL Login, add it as a windows login.
Check if the user who is trying to connect belong to the windows admin group.
February 23, 2012 at 11:40 pm
Is the service using a windows logon to start ( has any passwords changed recently). Have you tried refreshing the service icon. Sometimes the icon doesn't change even if the...
February 23, 2012 at 11:38 pm
Perosnally I'd say its split even between these categories
DB maintenance : 33 -- Used where more professional monitoring and administering tools are not available or for smaller systems
OLTP Systems...
February 23, 2012 at 11:26 pm
The best way is to limit the input of the parameter value by having the values returned as part of a query.
The user may choose to ignore the prompt...
February 23, 2012 at 2:05 am
if ur using sql server 2008 , you should try using table data type , in which you can now pass a array as the input to the proc and...
February 23, 2012 at 1:59 am
bulk insert madworks.dbo.[table4]
from 'D:\New Text document.csv'
with
(
keepnulls,
FIELDTERMINATOR = ',',
ROWTERMINATOR = '',
DATAFILETYPE = 'char',
FIRSTROW = 2
--ERRORFILE ='Drive:\folder_name\err.txt'
)
February 23, 2012 at 12:59 am
What about the number of concurrent sessions now on the server or the impact on temp db and the time taken to complete nightly maintenance tasks.
Have you taken care...
February 22, 2012 at 4:31 am
sheesh
update table
set columnname = value
where columname = filter
please lookup BOL for UPDATE.
You could use the replace function too or simply update nilly willy.
February 22, 2012 at 4:26 am
A VLDB requires that you need to be more proactive , make sure that a lot of the problems associated with the database are identified before hand.
for
Example the sizing...
February 22, 2012 at 3:26 am
you might want consider the below query to understand how the results meaning while change
CREATE TABLE #testdates (
startdate DATE
,enddate DATE
, descript VARCHAR (100)
)
INSERT INTO #testdates (startdate, enddate, descript)
VALUES ...
February 22, 2012 at 3:17 am
Since multiple packages can use the same config file and since there could be external dependencies on batch files or xml files there is no once one solution on how...
February 22, 2012 at 2:02 am
why are you shrinking the database. Its been discussed quite a bit in this forum that its a bad idea.
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
read more
February 22, 2012 at 1:31 am
That's not a good idea, a table like employee id could stop at 150 today but might need to be able to store 1231321 at a later date.
choosing int...
February 22, 2012 at 1:28 am
Viewing 15 posts - 466 through 480 (of 961 total)