Viewing 15 posts - 2,281 through 2,295 (of 6,401 total)
Crude way, but 8 input parameters, 7 IF statements
create proc InsertClassDays (@class char(1), @sun bit = 0, @mon bit = 0, @tue bit = 0, @wed bit = 0, @thur...
July 22, 2014 at 3:01 am
Can you give an example of a file path and how you want it to look as a result set?
July 22, 2014 at 1:25 am
Your ToDate is 0014, that's outside the scope of datetime
July 21, 2014 at 7:33 am
Use ISO based date formats or if you must do DMY set your connection to use DMY formatting
http://en.wikipedia.org/wiki/ISO_8601
SET DATEFORMAT DMY
Otherwise the general default is MDY resulting in 28/02/2014 being the...
July 21, 2014 at 7:22 am
You will need to modify the attached script and put in the Database names, logical and physical file paths in the ############################ areas and then stick it in the databases...
July 21, 2014 at 5:03 am
You would need to speak to your mail admins to ensure that the email server your using accepts connections on the port in question. If it does then your...
July 21, 2014 at 1:53 am
Check the agent for any jobs which have been setup to run CheckDB.
Do you ever perform CheckDB's on your databases manually?
July 21, 2014 at 1:30 am
Yep those steps will resolve the problem.
You will need to ask a few more questions now to the business to determine how to stop this from happening again, primarily around...
July 21, 2014 at 1:27 am
SSMS may have been installed as a 32 bit version, doesn't mean that your server is 32 bit.
To check connect to your server via SSMS and run PRINT @@VERSION
You should...
July 21, 2014 at 1:18 am
You would need something to be running outside of the SQL instance, for example a powershell or WMI script which checks the service at regular intervals and emails you if...
July 21, 2014 at 1:13 am
This will probably help you out and it details how to get the hierarchy out of the AdventureWorks database for Manger vs Employee
http://technet.microsoft.com/en-us/library/ms186243(v=sql.105).aspx
July 18, 2014 at 3:51 am
What object is object_id 1913773875? If its not the table you have already detailed can you provide the same information for that table.
July 17, 2014 at 9:11 am
Can you post the deadlock graph from the system_health extended event?
July 17, 2014 at 8:21 am
Can you post the deadlock graph from the system_health extended event or by switching on traceflag 1222
dbcc traceon (1222,-1)
July 17, 2014 at 4:55 am
Viewing 15 posts - 2,281 through 2,295 (of 6,401 total)